Unanswered

Using conditions in my flow

(0) Share

Report

Posted on by condotma

Hello,

I am trying to automate the following and am getting stuck. I am currently keeping track of completions of a module I have created with an MS Form. I have a flow set up to pull needed information from the Form into an Excel Table, one piece being the office location of the person who completed the module. What I would like to do is when I go to this table, to be able to trigger a flow to send an email based on a condition. If the office location does not appear anywhere else in the column, then it will send one email. If the location is already present (someone from that office has completed the module), then a different email will send.

I have the trigger has For a Selected Row in Excel. I think I need to use the Filter Array and then Condition steps, but am not sure what to input in these steps.

Any help would be greatly appreciated! I'm still new to Power Automate and don't have all of the formulas and steps down yet.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@condotma ,

You can set up a manual trigger or a recurrence trigger (maybe once daily) if you want it to run automatically.

Do you have a finite list of locations somewhere that you can compare against?

What you want is simple

Loop through all the locations (from master list)

Query the Excel table where the Location field matches the location

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @condotma

So you want to send email based on row you have selected right ?

Was this reply helpful? Yes No
condotma 22 on at

Like (0)

Report

Hi @Nived_Nambiar,
Correct. It’s based on the row selected.

Thanks,

Was this reply helpful? Yes No
condotma 22 on at

Like (0)

Report

Hi @SudeepGhatakNZ,

thanks for the suggestion. I want the flow to check against the other entries generated in the table. Would checking against a master list be necessary?

Thanks,

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @condotma

You can try this way

For demo, I have created an excel file which looks like this

1. Use the trigger for a selected row
2. Next use the list rows in table, inside that specify all file details and in the filter query section specify a condition

where the variable office location is coming from selected row trigger, here this query is trying to filter the rows based on rows having officelocation column value equal to the value of officelocation of selected row.

3. Next use an if condition with condition as

length(outputs('List_rows_present_in_a_table')?['body/value']) = 1

outputs('List_rows_present_in_a_table')?['body/value'] represent the rows as output from list rows in table after filtering using filter query.

if the condition is true, then it means that officelocation for selected row doesn't appear anywhere in the column
else, it appears somewhere else.

Hope this logic would help in building the flow 🙂

Flow complete picture

Was this reply helpful? Yes No
condotma 22 on at

Like (0)

Report

Hi @Nived_Nambiar,
Thank you! This makes sense and it gets my flow to run!
However, it only runs the No condition, even if I only have 1 of that location in the table.
I took some screenshots of the flow...am I missing anything or did I input anything incorrectly?

Thank you!

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

The way you have inserted the length function is wrong , check the above screenshot on how i have done it.

Was this reply helpful? Yes No
condotma 22 on at

Like (0)

Report

That makes sense! In the body/value section of the length function, am I inputting the column name?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Length function is used to calculate length of array here
outputs('List_rows_present_in_a_table')?['body/value'] is an array of rows, so length of this would be equal to number of rows obtained from list rows from table action and if you remember we have used filter query to filter only the rows which has officelocation equal to the selected office location value in list rows from table action.
So in short, list rows from table gives u the rows whose office location column would have value equal to selected row office location value and length of that gives how many rows are there.

Hope all is clear now.

Was this reply helpful? Yes No
condotma 22 on at

Like (1)

Report

Hi Nived,

Thank you for the explanation. It does make sense to me now.

In the yes and no step. I would like to send a different email based on the result. So if it is unique, one email is sent. If it is a duplicate, another email is sent.
Do I require to use to those Compose actions or can I just insert the send an email action?

Thank you for all of your help thus far. It is greatly appreciated!

Was this reply helpful? Yes No