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

Any Ideas on Power Automate update a row per day

daily.JPG

Good Morning,

I have a daily check list I created with forms. In order to ensure that each employee has done the daily task each day if the week my thought was to have a excel sheet that is saved with the time stamp per day listed monday, tuesday, etc. Save the time stamp and the unique ID for the date. How can I make the flow decide what day it is to put the unique id in the correct day column?

I was wondering if anyone had any ideas.

1 ACCEPTED SOLUTION

Accepted Solutions

@Anonymous  In this case use utcnow('dddd') it will give day of current date. 

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

View solution in original post

3 REPLIES 3
Hardesh15
Super User
Super User

@Anonymous  Please use one compose and pass expression utcnow() this will capture current date and time. After that pass this compose output in your column unique ID. Date & time is itself a unique ID. 

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Anonymous
Not applicable

update.JPG

@Hardesh15  would the string recognize the day of the week? So then I could condition the flow per day and then 'update a row' per the day column?

Thank you for all the help!!

@Anonymous  In this case use utcnow('dddd') it will give day of current date. 

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

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.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,846)