cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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.

5 REPLIES 5
v-xida-msft
Community Support
Community Support

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:2.JPG

The flow works successfully as below:3.JPG

 

Best regards,

Kris

 

 

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Anonymous
Not applicable

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?

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

DAGEM
Frequent Visitor

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,530)