Power Automate Custom Approvals on SharePoint Document Library (Majority Wins with View Formatting)

This video is a step-by-step tutorial on creating custom approval responses using Power Automate flows with SharePoint Document Libraries. We will build a majority wins approval workflow scenario based on the custom approval responses. If majority vote for Yes, then the document approval process will be marked as "Approved" else "Rejected". We will setup our approvers dynamically by leveraging a SharePoint Group. The process is dynamic as the number of approvers are based upon the members of the Group.
We will also apply SharePoint View Formatting to enhance the user experience for the Document Approval workflow process & track the status of the Quorum (Majority wins) approval.

Topics covered:
✔️ Power Automate Custom Approval Responses
✔️ Dynamic approvers with SharePoint Group
✔️ Document Library View Formatting
✔️ Approval Status Tracking
✔️ Quorum Approvals (Majority Wins)

#SharePoint #PowerAutomate #Approvals #ViewFormatting #DccumentLibrary

🤝 Let’s connect on social:

Table of Contents:
00:00 - Introduction
00:35 - SharePoint Document Library Setup for Approvals
01:55 - Create an Approval workflow with Custom Responses
02:58 - Dynamic Approvers from SharePoint Group
06:37 - Quorum Approvals (Majority Wins) - Wait for all responses approval type
11:33 - Document Approval flow in action
13:10 - Document Library View formatting
15:35 - Query Dataverse to get Approvers taken decision info
16:26 - Subscribe to Reza Dorrani channel

[tetsuyakawahara]

Awesome!! Great view formatting that allows you to see at a glance the approval status of a document and who approved it🤩🤩
I love this view formatting😍
And the flow instructions are always so clear, so detailed, so helpful! Thanks Reza for all the really great videos!

[UlyssesHaq]

You are unparallelled in your PowerAutomate magnificence. Without you, we are truly lost. Thank you.

[tbone]

I'm awestruck. Nailed it, Reza... Bravo! 👏🎆

[moserbua]

It's so unbelievably good what you provide in terms of knowledge transfer. Thank you a thousand times dear Reza 🙌👍👍👍

[lyndzhang]

The column formatting json is so cool! Love it!

[ajaychoudhary]

Again a great video...no one like you Reza 🙏🙏🙏

[alzaimoor]

Excellent, I like formatting, well done

[oluwatobiyusuf]

Awesome video. Thanks for the knowledge shared

[ledbetter]

Thanks for the extreme detail here. Looking to create a fairly simple approval process utilizing Approvals in Teams combined with Sharepoint and Power Automate. We have 2 proofreaders that support 25 users. Each user must submit multiple attachments at once for approval. At a minimum 2 attachments since we have the final external facing document and a "Bible" document to proof against. Right now I cannot figure out how to submit multiple attachments in the default Approvals app. Also would like the ability for the proofreaders to be able to select either Approved or Rejected along with a text field to provide feedback if rejected. I'll keep looking at the other examples you have provided, but wanted to throw this out there as a potential idea for a more simplified tutorial idea perhaps? Thank you!

[marianelarey]

Hi Reza! Love your videos! I was wondering if you can explain a flow where you have a list of task and when you complete all tasks someone can approve this list. Greetings from Argentina 🇦🇷

[PowerPlatformDiv]

Awesome, I'm looking for something like similar Thanks @Reza

[claytonirlanda]

Great video, thank you. Do you have a video of how know who are pending to approve the document? I can see at the end of the video you have this inside of the second branch > do until, can you share the link of that video as well?

[ayhanhacioglu]

Hi Reza,
I love watching your powerapp videos.
Thank you for your great work and sharing.
I would like to ask you one question for using wmic with powerapps.
In your opinion, can we use wmic together with powerapps for collecting software inventory from the computer?
What do you think about this? Is it possible?

Thanks in advance
Ayhan

[Gwenneke]

Hi Reza, great demo! Is it possible to use the flow without SP Group member E-mails and to use the e-mails instead?

[utsavacharya]

Awesome . It will be very helpful if you put some demos on repeating tables in powerapps with canvas as well as customize list form

[pawan.poojari]

Great tutorial. Thanks.
The Approvers Person list not getting updated after the first person approves it.

[kyles]

Great videos Raza. I am looking for ideas on a slight modification to the above scenario. I want to have an approval that waits for all, but only waits for 24 hours. How would you adjust this solution for this change to the scenario?

[santiagoares]

Hi Reza. Great video as usual.
Instead of waiting for all responses to calculate majority, how can I end the approval process after I get 2 responses.
In my scenario I use custom responses, wait for all responses with only one option which is Approve. Also it would be great to update the list item approval history column with then name of the approver and the timestamp of their approvals.
Thanks and greetings from Argentina. 🇦🇷

[julien]

Nice video Reza, regarding "Query Dataverse to get Approvers taken decision info" is it possible to pull the data in real-time when the user takes the approval decision instead of waiting for all approvals to respond?

[Reaven]

It works, thanks for the video😀. I have a question how to display additional comments of accepting people🤔