Answered

How to extract values from Excel to be used in a Condition Action

(0) Share

Report

Posted on by Community Power Pla...

I currently have an MS Form that is flowing into an excel spreadsheet with each entry adding a new row into Excel. I have set up some formulas to create a 'Score'. I want to then use this 'Score' as a condition action to automatically trigger a 'Pass' or 'Fail' message in MS Teams.

This is currently the flow i have:

However, whenever the flow runs it takes all the entries in the 'Total Score' excel column rather than the most recent entry that has been added from earlier in the flow - as a result I get multiple posts in Teams. I have tried to taking away the 'Apply to Each' but that did not work.

Does anyone have any suggestions how to build this with only the latest entry into the table being counted?

Thanks!

All responses (11)

Answers (1)

Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to extract values from Excel to be used in a Condition Action

I might do a proper video on the same subject. The one I gave to you is unlisted.
Community Power Pla... on at

Like (0)

Report

Re: How to extract values from Excel to be used in a Condition Action

Thank you so much for putting that together! Really taught me a lot with what can be done and helped me out massively! Thank you!!
Verified answer

Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to extract values from Excel to be used in a Condition Action

I actually anticipated your question and made a video for you last night that shows how to get the information you want:
https://www.youtube.com/watch?v=44yhtLy3CFM&feature=youtu.be
Community Power Pla... on at

Like (0)

Report

Re: How to extract values from Excel to be used in a Condition Action

@Paulie78 Thanks very much for that much appreciated! That expression gives the content of the whole row, is there a way to use the final cell in that row in the condition action?

Currently the below condition is not working as the two parameters are not matching.
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to extract values from Excel to be used in a Condition Action

Also, ignore my last expression, it works fine but it is far too complicated, you can simply do:
last(outputs('List_rows_present_in_a_table')?['body/value'])
Which produces exactly the same result.
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to extract values from Excel to be used in a Condition Action

Take a look at this:
Expression is:
outputs('List_rows_present_in_a_table')?['body/value'][sub(length(outputs('List_rows_present_in_a_table')?['body/value']),1)]
This will give you a new object which contains only the contents of the final row of your excel table, which you can then extract values from.
Community Power Pla... on at

Like (0)

Report

Re: How to extract values from Excel to be used in a Condition Action

@Paulie78 further explanation would be great! As soon as I select the 'Total Score' column as the value for the condition it automatically adds the 'Apply to Each' condition.
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to extract values from Excel to be used in a Condition Action

Yes, you could simply select the final element of the list rows action based on it's length and you could skip the apply each completely, know what I mean or shall I explain further?
Community Power Pla... on at

Like (0)

Report

Re: How to extract values from Excel to be used in a Condition Action

@krootz because the 'Total Score' value depends entirely on the results from the form, I cannot set up the 'Get a Row' because I don't know the value to look for within the 'Total Score' column.
Again, this is based on a very basic understanding of Power Automate, so please let me know if i am doing anything wrong!

Thanks!
Community Power Pla... on at

Like (0)

Report

Re: How to extract values from Excel to be used in a Condition Action

@krootz okay so instead of the 'List Rows' action, i need to be using 'Get Row' action?