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.
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:
@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
Briliant, this worked, thanks - I was using "List All Rows" instead of "Get Rows" - what is the difference?
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
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).
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
25 | |
24 | |
24 | |
21 | |
17 |
User | Count |
---|---|
56 | |
39 | |
38 | |
30 | |
30 |