08-17-2021 06:10 AM
In this video we will walk through an end-to-end solution tracking Power Automate Approvals with SharePoint Lists using an approval workflow & SharePoint column formatting.
Using column formatting, we will showcase an Approval timeline which will include a progress / status indicator for showcasing the current state of the approval process related to the SharePoint list item + Approval history which includes all details of the approval action (approver name, approval date, time taken to respond, comments), highlight the current approvers & calculate the time the approval action is in pending state.
This can be handy in identifying where the approval process is taking more time. We will also define dynamic approvers based on metadata & log the approval history to SharePoint list item (best practice since flow approval history is only available for 28 days). Scenario in video is a help desk application in SharePoint where users log information which triggers the approval process.
Topics covered:
✔️ SharePoint Column Formatting
✔️ Approval Workflow using Power Automate
✔️ Dynamic approvers
✔️ Approval history logging
✔️ Approval Timeline
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
watch?v=lYE7NXTDPJY
Hi,
The timeline doesn't work for me. Everything is recognised to "left" regardless of status. Appreciate if I can pick up your brain. Thank you.
Reza,
All your videos are some informative and have helped me build a Procurement Tracking List. Now I do have a couple of issues and wondering if you can take a look:
1. Approval Pending Since: with the json provided for this column (date and time; included time), but the showing time is still 28 million mins. Any ideas
2. Approval Timeline: I submit a new request and it sends me an email and teams notification. However, when I "Approve" the request it comes back to sharepoint as "Rejected"
Here is the json that I changed to satisfy my columns:
Workflow:
And last issue: When I submit new, I have the description of my request. When it sends the request and moves to pending it deletes my description.
Hello, I have the same issue! Did you find a solution ? 🙂
I really enjoy your videos, they are a big help. I am having an issue with the custom card on my approval timeline. I am not showing any text after the process begins. I can see the No History Available when the item status is new but the box remains empty after this status is changed. Any help on this would be much appreciated.