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?
Solved! Go to Solution.
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!
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!
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?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
User | Count |
---|---|
4 | |
3 | |
2 | |
2 | |
1 |
User | Count |
---|---|
11 | |
10 | |
6 | |
6 | |
5 |