Trigger Condition Not Working as expected

(0) Share

Report

Posted on by davidtheilman

Hello:

I have a SharePoint List created and in one of the fields you are asked to select "job location"

You have six options to choose from

I am trying to create a Power Automate that starts with "When an item is created"

Site Address and List Name are correct

I want the flow to look and determine which "job location" is selected to determine if the flow process starts or not

In my testing, I am entering "Education Services" as the entry that will start the process and I am using the "Trigger Condition" in the "When an item is created" settings, however it is not working

Can you please take a look at this and let me know what you think is wrong? Also, if you need more information, just let me know

Thanks in Advance!

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@davidtheilman

Can you tell me the column type of the Location services column?

Also, this type of comparison is case sensitive.

Was this reply helpful? Yes No
Verified answer

yashkamdar 1,044 on at

Like (1)

Report
Copy link

Link copied!
Hello Team,

No that does not look correct.

I believe you have a choice type column and therefore you should have the following expression as a Condition in the settings of the Trigger

@equals(triggerBody()?['Jon_x0020_Venue_x0020_Location']?['value'],'EducationServices')

I have done this a zillion times in my environment and this expression has always worked, let me show you a for example-

If I click on CLICK TO DOWNLOAD for the outputs, you can see the expression worked when I wanted the trigger to go off only when the value is ONLINE

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
davidtheilman 13 on at

Like (0)

Report
Copy link

Link copied!

@yashkamdar

That worked PERFECT.....Thank you so much!

Was this reply helpful? Yes No
yashkamdar 1,044 on at

Like (0)

Report
Copy link

Link copied!

Hello Team,

So glad that I could help you out in this !!

Thank you.

Keep exploring the community, by asking interesting questions, by answering questions, we are all here to help each other out.

Was this reply helpful? Yes No
Capshoo1 17 on at

Like (0)

Report
Copy link

Link copied!

Can I just double check...Will the expression have to change if each choice has a different colour formatting?

Was this reply helpful? Yes No
mr_lipovsky 2 on at

Like (0)

Report
Copy link

Link copied!

but it does not work for me. I am using the same condition as you.

Was this reply helpful? Yes No