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?
Join digitally, March 2โ4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
12 | |
8 | |
4 | |
4 | |
3 |
User | Count |
---|---|
12 | |
8 | |
5 | |
5 | |
4 |