Hello, I need help in creating logic app trigger expression.
I want to trigger logic app only if column value matches with a specific value. This is what I have tried so far:
@equals(triggerBody()?['columnname'],'value')
I can see an instance in "Trigger history" but nothing in "Runs history". Can someone help me to troubleshoot this?
Regards,
Nilesh
@nileshkodulkar-3248 Thanks for reaching out. Can you share more details on what trigger and connector you are using so I can assist you further.
Hello @MayankBargali-MSFT ,
Dataverse connector with row addition trigger is what I'm utilizing.
@nileshkodulkar-3248 Thanks for the confirmation. Your trigger condition looks good, but it looks like the columnname may be incorrect as there is DisplayName and Name different at dataverse end and the logic app returns the Column Name and name in the Display Name table and what you receive in the trigger body.
@equals(triggerBody()?['columnname'],'value')
My column display name was name in dataverse table but the columnname was craf9_columnname which is return as same in the response body in my case
@equals(triggerBody()?['craf9_name'],'mayank')
If your condition is matched, then the Trigger History Fired column will has the Fired value else it will be empty as below.
To verify if you are using the right output property, please navigate to the Trigger History and select any of the non-Fired run and review the Output link to find the actual output return by the connector and then use the same property in your trigger condition.
Feel free to get back to me if you need any assistance.
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.
@MayankBargali-MSFT , Can you confirm that you have used choice column for this POC?
@nileshkodulkar-3248 The test was performed with the Choice datatype. To validate you can remove the trigger condition and verify the output first. Only the fields/columns that are returned in the trigger output can be used as the trigger condition so your logic app workflow is triggered.
17 people are following this question.
