cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dwrm
Frequent Visitor

Checking values from a row in Excel and appending to an array if value = "X"

I am trying to create a flow that will check the results of a row from an Excel file stored in OneDrive for Business.  I need it to check all the values in the columns for "Deficient" and, if found, append the column name that was marked deficient and the value of a remarks column to an array.  Once completed checking the values I am hoping to output to an html table to email to someone.  There are 350+ columns in the spreadsheet (of which half are values to check and half are the remarks) and I was trying to find a way to make a for each check the column values, but I am stumped. I have tried using list rows present in a table, but when I try to check for condition it wants to do one at a time.  I really do not want to have to create a flow to check 175 individual values.

Any suggestions to automate this check?

2 REPLIES 2
manuelstgomes
Super User II
Super User II

Hi @dwrm 

 

Sure, here's a way to fetch the information from an Excel document dynamically.

https://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow

 

I created a Power Automate for myself that I adapt each time I want something like that. Something like this:

small-Screenshot_2020-01-01_at_17_16_11.jpgsmall-Screenshot_2020-01-01_at_17_16_21.jpg

 

Is this what you need?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

 

yashag2255
Dual Super User II
Dual Super User II

Hey @dwrm 

 

You can create a dynamic array and add the conditions to then populate the individual values into that array (the Flow will definitely have to check for individual values in this case and can be achieved using the apply to each). Here is a similar terminology that I have used earlier to detect and delete duplicate records on Dynamics but the similar terminology to populate and compare values with arrays can be used in your case. https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Delete-duplicate-records-items-fro... 

 

Hope this Helps!

 

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!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (70,913)