Want to loop through Excel Online Table Rows, using values in certain column as input for action

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So I have a Table in an Online Excel file, with a single column, called "Column1" - what I want to do:

- for each row in the table

- read the value in column 0 of the row

- if it is empty, do nothing

- if it is non-empty, send it as the subject of an email

So if a Table has 5 rows where column 0 is non-empty, I should get 5 emails, each one with the subject as one of the column 0 cell contents.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you please show a bit more about your Excel table?

Where are your Excel file stored?

Further, could you please share a bit more about the column 0 within the following statement?

@Anonymous wrote:

- read the value in column 0 of the row

I suppose that you want to read the value in Column1 of each row, is it true? I have created a Excel file (whose data formatted as a table) in my OneDrive for Business folder.

I have made a test on my side and please take a try with the following workaround:

Add a proper trigger, here I use Flow Button trigger.

Add a "Get rows" action, specify File Name and Table Name.

Add a "Apply to each" action, input parameter set to output of "Get rows" action.

Within "Apply to each" action, add a Condition, click "Edit in advanced mode", type the following formula:

@empty(items('Apply_to_each')?['Column1'])

Within "If/no" branch of Condition, add a "Send an email" action, Subject field set to Column1 dynamic content of "Get rows" action.

Image reference:

The flow works successfully as below:

Best regards,

Kris

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

Like (0)

Report
Copy link

Link copied!

Briliant, this worked, thanks - I was using "List All Rows" instead of "Get Rows" - what is the difference?

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

Like (0)

Report
Copy link

Link copied!

Okay, so the next thing I need to get right. I want this to run every 4 hours:
- read each row from the Excel table (working)
- each non-empty row is the address of an RSS Feed
- watch each of those feeds for new items
- email each new item link as an email

I've got it working once-off (i.e. read the excel rows once, then continuously scan for new items) - but I need to refresh the read of the Excel file every 4 hours, so that any news feeds added to it will be updated. What makes it tricky for me is that the "When a Feed Item is Published" action is a continuous action that never terminates and moves onto the next step?

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

Like (10)

Report
Copy link

Link copied!

Hi @v-xida-msft. I don't see GET ROWS for Excel Online. Only GET A ROW.
How does one loop through an Excel Online sheet when it wants a Key and Key ID for a single row? I can't seem to find a way to put For Each in there.

Thanks

Was this reply helpful? Yes No
DAGEM 30 on at

Like (0)

Report
Copy link

Link copied!

There's an Action you can search for called Recurrence. This allows you to determine a time frequency for triggering the flow (make sure Recurrence is at the top of your flow).

Was this reply helpful? Yes No
cfh4030 6 on at

Like (0)

Report
Copy link

Link copied!

Hello,
I see you have a "Get rows" action. I only have "Get a row" available. Is "Get rows" a premium feature?

Was this reply helpful? Yes No
RomanTech 2 on at

Like (0)

Report
Copy link

Link copied!

EDITED: Accidental thread jack, I meant to create a new post. My problem is similar: https://powerusers.microsoft.com/t5/Building-Flows/Excel-Read-cells-that-contain-usernames-and-passwords-Log-into/m-p/1795769**

Was this reply helpful? Yes No