Cant get a few conditions work in Power Automate

[Harris021]

Hi all,

I have set up a workflow using SharePoint list and Power Automate, allowing users to choose up to five flights. The details of the first two flights are visible to all users. For additional flights, I've added a checkbox for users to select ("Add more flights"), allowing them to choose up to six flights.
My challenge is ensuring that the manager only receives details for the flights the user selects. If a user selects three flights, the manager should only see details for those three flights in the email. I've successfully implemented the first condition, but I need to figure out how to add the other conditions.

[v-yueyun-msft]

Hi , @Harris021 

According to your screenshot , you have realized to judge if the user selects the "Add more flights" in your list.

Do your "first two flights" and the "other flights" column are all "Choices" column in your list?

Can you show us the data types of fields in your SharePoint and what other Conditions you want to add so I can help you better!

Best Regards,

Yueyun Zhang

[Harris021]

Hi @v-yueyun-msft 

The check Box column will be a trigger for sending the email to the managers. So, the condition is that by default, the user fills out the first and second flight details, and the email will be sent to the manager for approval. However, users sometimes need to add the third, fourth, fifth and sixth flights. What I need is if the users select the third and fourth flights, the manager will receive one email with details of the first, second, third and fourth flights.

[v-yueyun-msft]

Hi , @Harris021 

Thanks for your response! 

So you mean you want to send an email when the user selects "Add third filght", "Add fourth filght", "Add fifth filght", "Add sixth filght" one or more than one. Is that correct?

Best Regards,

Yueyun Zhang

[Harris021]

Only one email with flight details, as my first screenshot, I managed to get the first condition right which sends separate email if the user select the third flight or not, and I don't know how to add the conditions for the fourth, fifth and sixth flights

[v-yueyun-msft]

Hi , @Harris021 

Thanks for your response! If you want to add the condition, you can directly add it here:

And if you want to get the detailed for the flight , you can use expression, for example this is get the Date information:
if(triggerOutputs()?['body/Addthirdflight'], concat( 'Flight 3 Date :' ,triggerOutputs()?['body/Flight3Date'] ) ,null)
if(triggerOutputs()?['body/Addfourthflight'], concat( 'Flight 4 Date :' ,triggerOutputs()?['body/Flight4Date']) ,null)

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[Harris021]

Please let me know where you added this condition after the first screenshot I mentioned here. Do you create as a New step or you continue under the Yes as Add an Action?

[v-yueyun-msft]

Hi , @Harris021 

Thanks for your response, you could add this judgment in your  condition after the first screenshot and do not need to create a new action or step.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[Harris021]

Hi @v-yueyun-msft 

I am new to Power Automate and don't understand your point. If I follow your suggestion, I will end up with two options to send the email; I need at least five options to send the email to the manager based on the user selection.

Email Option 1: Flight one and two details

Email Option 2: Flight One, two and three details 

Email Option 3: Flight One, Two, Three and Four details

Email Option 4: Flight One, Two, Three, Four and Five details

Email Option 5: Flight One, Two, Three, Four, Five and Six details

[v-yueyun-msft]

Hi , @Harris021 

Thanks for your response ! I may misunderstand you need! 

According to your description, you want to generate 5 different conditions and send corresponding emails. Does your Flight 4 need to exist in Flight 3 before it can be selected?

So only when the [Add third flight] = true , the user can select the  "Add fourth flight" in your list?

Best Regards,

Yueyun Zhang

[Harris021]

Hi @v-yueyun-msft 

First Condition, the user either require flight three or not. If the user select (Add third flights (Yes/No column)) then it will trigger the flow and send the email to the manager. 

Second Condition: When the user select third and fourth (add flights option). In this case manager should receive the flight information for the 1,2,3 and 4 flights.

Third Condition: When the user select third, fourth and fifth (add flight option).In this case manager should receive the flight information for the 1,2,3,4 and fifth flights.

Fourth Condition: When the user select third, fourth,fifth and sixth (add flight option).In this case manager should receive the flight information for the 1,2,3,4,5 and six flights.

[v-yueyun-msft]

Hi , @Harris021 

Thanks for your response ! I test it in my side , this is the output of my trigger when i select the Third and Fourth Flights in my List:

This is my flow result :

 You can refer to this:

if( equals( triggerOutputs()?['body/Addthirdflight'] , false) , 'Option1' ,
if( and( equals( triggerOutputs()?['body/Addfourthflight'] , false),equals( triggerOutputs()?['body/Addthirdflight'] , true) ) , 'Option2' ,
if ( and( equals( triggerOutputs()?['body/Addfifthflight'] , false),equals( triggerOutputs()?['body/Addfourthflight'] , true) ) , 'Option3',
if( and( equals( triggerOutputs()?['body/Addsixthflight'] , false), equals( triggerOutputs()?['body/Addfifthflight'] , true) ) , 'Option4' , 'Option5' ))))

The Option1,Option2,Option3,Option4,Option5 is corresponding to the 5 situations you mentioned above:

Email Option 1: Flight one and two details

Email Option 2: Flight One, two and three details 

Email Option 3: Flight One, Two, Three and Four details

Email Option 4: Flight One, Two, Three, Four and Five details

Email Option 5: Flight One, Two, Three, Four, Five and Six details

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[Harris021]

The part that I can't figure out is that they said in the e-mail they want to see only the flights that users added and not all flights with included details flights. For instance, if the users added only four flights, they would want to see four flight details tails and six flight details.

[v-yueyun-msft]

Hi , @Harris021 

Thank you for your reply. You can send the corresponding email according to the above conditions, and then select the corresponding Flight No. field in the body of the email.

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[Harris021]

thanks, let me try your suggestion and I will get back to you.

[v-yueyun-msft]

Hi , @Harris021 

Thanks for your response! 

For the formula above, you can check whether the field names on your side are the same as mine. If they are different, you need to replace the red fonts I marked above.

Best Regards,

Yueyun Zhang

[Harris021]

i @v-yueyun-msft 

For some reason, no matter what I select, it always picking up option1 form me

if( equals( triggerOutputs()?['body/Add_x0020_third_x0020_flight'] , false) , 'Option1' ,
if( and( equals( triggerOutputs()?['body/Add_x0020_fourth_x0020_flight'] , false),equals( triggerOutputs()?['body/Add_x0020_third_x0020_flight'] , true) ) , 'Option2' ,
if ( and( equals( triggerOutputs()?['body/Add_x0020_fifth_x0020_flight'] , false),equals( triggerOutputs()?['body/Add_x0020_fourth_x0020_flight'] , true) ) , 'Option3',
if( and( equals( triggerOutputs()?['body/Add_x0020_sixth_x0020_flight'] , false), equals( triggerOutputs()?['body/Add_x0020_fifth_x0020_flight'] , true) ) , 'Option4' , 'Option5' ))))

[Harris021]

do you know why I am getting error below:

[v-yueyun-msft]

Hi , @Harris021 

Thanks for your response! This is the expression error . Can you give me your  output of your Trigger in your side and which you select it ?

Best Regards,

Yueyun Zhang

[Harris021]

@v-yueyun-msftI managed to fix the error. If you look at the code below, I expect that Option 2 becomes true if I select to add the third flight. But I keep receiving emails for option 1

if( equals( triggerOutputs()?['body/Add_x0020_third_x0020_flight'] , false) , 'Option1' ,

if( and(equals(triggerOutputs()?['body/Add_x0020_fourth_x0020_flight'] , false),equals( triggerOutputs()?['body/Add_x0020_third_x0020_flight'] , true) ) , 'Option2' ,

if( and(equals(triggerOutputs()?['body/Add_x0020_fifth_x0020_flight'] , false),equals( triggerOutputs()?['body/Add_x0020_fourth_x0020_flight'] , false) ) , 'Option3')))