Unanswered

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

(0) Share

Report

Posted on by dwrm

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?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

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:

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

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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-from-Dynamics-365-CRM-CDS/ba-p/334853

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!

Was this reply helpful? Yes No