cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
Community Support
Community Support

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

Hi @brucem,

 

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?


@brucem 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.
Highlighted
New Member

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

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

Highlighted
New Member

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

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?

Highlighted
Super User
Super User

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

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

Highlighted
Frequent Visitor

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,426)