Unanswered

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!

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

krootz 458 on at

Like (0)

Report

@Anonymous If the score is part of the data being added, you can skip list rows. If not and the score is calculated in the excel sheet itself, you can use the "Get Row" action instead to fetch that single row that was added.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

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

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!!

Was this reply helpful? Yes No