cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arbangara99
Advocate II
Advocate II

Get the timestamp information from an approval response

On Flow (email approval) when a user approves, I want to update the sharepoint list item column with the date and time of the approval. It works fine with static data, but how cn I get the date and time of approval?

1 ACCEPTED SOLUTION

Accepted Solutions
darogael
Super User
Super User

Hi Arbangara99,

I was able to replicate your scenario successfully on my SPO. I created a simple list with Title, Manager and Approved (date/time column). I used the 'Send SharePoint List item for approval' Flow but I added an extra action. Below is a screenshot of that action. I added an Update Item action and in that action updated the Approved field with Modified. Hope this helps!

 

 

Capture.JPG

View solution in original post

2 REPLIES 2
darogael
Super User
Super User

Hi Arbangara99,

I was able to replicate your scenario successfully on my SPO. I created a simple list with Title, Manager and Approved (date/time column). I used the 'Send SharePoint List item for approval' Flow but I added an extra action. Below is a screenshot of that action. I added an Update Item action and in that action updated the Approved field with Modified. Hope this helps!

 

 

Capture.JPG

View solution in original post

Hi Darogael, Thanks for your solution. That made my day!!

 

Now digging further, I see that when the approver approves, I use the field Modified by Email updated in the sharepoint, but it actually puts my email address instead of the user who originally approved it. Is there a way to get that information too?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,319)