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

Powerautomate & Excel

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 

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @ThomasKoller 

You can create a scheduled cloud flow.

vLilyWmsft_0-1643014448978.png

vLilyWmsft_2-1643015274668.png

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

vLilyWmsft_3-1643015396814.png

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

Expression:

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

vLilyWmsft_4-1643015510619.png

Expression:

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

vLilyWmsft_5-1643015631568.png

Expression:

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

vLilyWmsft_7-1643015816356.png

Save and test the flow.

This is my test excel.

vLilyWmsft_9-1643016130939.png

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

vLilyWmsft_8-1643015922112.png

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.

View solution in original post

1 REPLY 1
v-LilyW-msft
Community Support
Community Support

Hi @ThomasKoller 

You can create a scheduled cloud flow.

vLilyWmsft_0-1643014448978.png

vLilyWmsft_2-1643015274668.png

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

vLilyWmsft_3-1643015396814.png

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

Expression:

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

vLilyWmsft_4-1643015510619.png

Expression:

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

vLilyWmsft_5-1643015631568.png

Expression:

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

vLilyWmsft_7-1643015816356.png

Save and test the flow.

This is my test excel.

vLilyWmsft_9-1643016130939.png

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

vLilyWmsft_8-1643015922112.png

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,154)