Powerautomate & Excel

[ThomasKoller]

I want to make the following flow:

• Start on every day on Monday to Friday at 8 am
• In a Excel file, look for the cell with today's date 
• Get the value from the cell below the cell with the date 
• Save it as a string 

How can I make such a flow?

I've never done anything with Powerautomate.

Thanks 

[v-LilyW-msft · Accepted solution]

Hi @ThomasKoller 

You can create a scheduled cloud flow.

Add List rows present in a table and configure it.(my excel is stored in sharepoint)

Add Filter array action to filter out rows whose date is equal to today.

Expression:

formatDateTime(item()?['Date'],'yyyy-MM-dd')

Expression:

formatDateTime(utcNow(),'yyyy-MM-dd')

Expression:

formatDateTime(item()?['Date'],'yyyy-MM-dd')

Save and test the flow.

This is my test excel.

After flow runs, will get rows with date equal to today.

Hope the content above may help you.

Best Regards

If my answer helps, then please consider Accept it as the solution to help the other members find it more quickly.