question

nileshkodulkar-3248 avatar image
0 Votes"
nileshkodulkar-3248 asked MayankBargali-MSFT commented

Logic App trigger expression

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

azure-logic-apps
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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.

0 Votes 0 ·

Hello @MayankBargali-MSFT ,

Dataverse connector with row addition trigger is what I'm utilizing.

0 Votes 0 ·

and it is a choice column

0 Votes 0 ·

1 Answer

MayankBargali-MSFT avatar image
0 Votes"
MayankBargali-MSFT answered MayankBargali-MSFT commented

@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.

195975-image.png

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.

195927-image.png

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.


image.png (26.6 KiB)
image.png (69.7 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MayankBargali-MSFT , Can you confirm that you have used choice column for this POC?

0 Votes 0 ·

@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.

0 Votes 0 ·