Flow Approval Dashboard in Power Apps for SharePoint

[@cvkealey]

Great video, Reza. One neat little enhancement I found (through trial and error) was that if you want to pre-select "Approve" or "Reject", you can append "&Response=Approve" (for Approve, obviously) - without the quotes - to the end of the response URL. This would let you create separate "Approve" and "Reject" buttons in the app. I've also tried using this technique to pre-fill the Comments field, but have not found the correct URL parameter to use. One of the other outputs of the "Create an approval" action is an adaptive card. It'd be great if that could be opened directly in Power Apps (to avoid sending the approver off to another website). That may be possible with a component?

[@RezaDorrani]

Wow man! That such a cool find. Mind if I share that with everyone on social platforms?

[@cvkealey]

@@RezaDorrani Sure, have at it! If you Tweet it, you could tag/mention me (@Chad_V_Kealey).

[@cvkealey]

@@RezaDorrani Correction: it's actually "?response=Approve" (not &Response)

[@RezaDorrani]

@@cvkealey Tried it and it works

[@robofski]

Humbling to know even Reza can learn something from KZbin 😊 (great tip BTW)

[@jamesmoran2601]

Reza, I've watched so many of your videos without commenting - excellent. This one in particular will be a great help. Please keep it up.

[@RezaDorrani]

You should comment more else how would I know you like my videos :)

[@riaanthiart1173]

Thanks

[@RezaDorrani]

Thank You

[@fakharahmedkhan5157]

Reza.. You just made my weekend. This is exactly what I was looking for. Thanks a lot. ❤

[@RezaDorrani]

Glad I could help!

[@mcduru9079]

Awesome content. All the videos bring at least a piece of information that you can use to upgrade your work. A big thanks Reza. Keep up and happy new year!

[@RezaDorrani]

Happy to hear that!

[@Liamscott92]

Great video Reza! Pro tip: if you’re only within Sharepoint and haven’t got a Powerapp and want to avoid people changing the approval status in by hand, create a calculated column referencing the status column (=status) and hide the initial field in the form. Tada: you’ll have a greyed out status column which can only be set by powerautomate!

[@RezaDorrani]

Nice tip!

[@chadalthaus3866]

SO good, Reza. I've considered something like this, and you've brilliantly put it all together.

[@chadalthaus3866]

After watching the whole thing, you put this together way better than I could have imagined. I really like how you store the link to the approval and launch that from a button.

[@RezaDorrani]

Thank You Chad

[@RezaDorrani]

You can even launch the approval and pre-set the approval decision by using &response=Approve or &response=Reject in the approval link (One of my wonderful subscribers got this to my notice)

[@chadalthaus3866]

@@RezaDorrani very nice! That’s a great tip.

[@ajaychoudhary5596]

I am looking the same solution.thanks a tons Reza..I like the way you represent and explain the things😊😊😊.

[@RezaDorrani]

Glad to know this is useful and thanks for watching

[@JesterHammer]

Awesome video. I have been searching for this design pattern for a while. Thanks and keep up doing good videos like that!

[@RezaDorrani]

Thanks for watching and liking this video.

[@reniersmit1564]

Great Video and well presented. Well done.

[@RezaDorrani]

Thank You

[@KidsStudyDanceStudio]

Excellent work, enjoyed watching. Also implementing in my project too. Really helps a lots. thanks a tons for your effort sir

[@RezaDorrani]

You are most welcome

[@NKBobcat]

We have an intern starting next week and I needed a project that was valuable but not critical for the intern to work on. I am going to use your idea to create the ability to monitor workflow status and what approval step the item is on in a graphical way. This way I have a nice project for the intern that will provide value to our company. In my normal capacity and workload, I would have had to do this on my own time. Thank you for a great idea Reza!

[@RezaDorrani]

That is a great idea. Would love to see what the intern comes up with. If possible then share with the community. Good luck!

[@NKBobcat]

@@RezaDorrani will do!

[@jayo3074]

@@NKBobcat make sure you pay the intern well aswell

[@NKBobcat]

@@jayo3074 we pay interns very well and sometimes hire them post graduation.

[@andreesteves7616]

Absolutelly Awesome. Thanks for sharing this content with us!

[@RezaDorrani]

You bet!

[@muhannednidal3647]

Excellent work, enjoyed watching.

[@RezaDorrani]

Thank You

[@BABA-is8kv]

Reza, you are truly amazing!

[@RezaDorrani]

Thank You :)

[@sujisam5508]

Thank you so much Reza! Amazing video!

[@RezaDorrani]

My pleasure!

[@niklassimacek6424]

Hello Mr. Dorrani, first I want to thank you for your great and helpful videos. Saved me a lot of times! I got one question about the look. How did you get the small status symbols on the picture of the approvals? Have you made a video for this? Best greetings from Germany!

[@RezaDorrani]

The video for designing the leave request dashboard is here kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@manoharreddy2577]

Thank you Reza.. its awesome 👍👍

[@RezaDorrani]

You're welcome 😊

[@liraspberry6966]

Amazing ！thank you for sharing，Reza ！

[@RezaDorrani]

You are most welcome

[@joshuabernardini7457]

In the video at 14:15, dragging the action. I can't seem to get passed this point? It won't allow me to drag. What do you think I'm doing wrong?

[@RezaDorrani]

Might be a browser related issue. Try with a different browser.

[@joshuabernardini7457]

@@RezaDorrani Thanks for the reply. It's telling me I can't move it because the action depends on the other. I don't think it's a browser issue.

[@RezaDorrani]

@@joshuabernardini7457 That's because you have some dynamic content in there that's dependent on another action. I would have to look at your flow to provide any guidance. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/

[@MrJackieWacky]

Fantastic tutorial, as a beginner its easy to follow, can you add how to create the leave requests in a company calendar and how we can show different staff with different vacation day totals, eg they started halfway through the year or have extra days from service time in the company?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I make videos when I get multiple requests on a topic. I have video ideas in backlog with over 30+ requests. I would recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@Jinoda]

So helpful, thank you very much.

[@RezaDorrani]

Great! Thank you for watching

[@aktharhussain6527]

please mention video number 1/2/3 on video title so that we can follow. its confusing from where we should start the videos for making a Leave request app.

[@RezaDorrani]

I will do that going forward. I actually did not plan the part 2 on this one. The response I received made me make another video.

[@mron4161]

Reza, your videos are incredible! - I'm really looking for some additional help, and I don't know how to get it so I figured I'd just post here and see what happens. I'm looking to create something like this below, however I can't find the right video that addresses the specific needs of my organization. For us, I need to create something like this except when a user is making the request, there are approximately 8 different types of documents (Work Instructions, SOP's, etc.), and each document type has different approvers required. The next level of complication is that each document type doesn't always require the same types of approvers. Our contract is broken down into 3 parts really, the ABC side, the DEF side, and the XYZ side (to keep it simple). Let's say Bob creates a Work instruction, ready for review. Right off the bat, approver 1 is required. Then Bob needs to make the determination of whether this affects the ABC Group (approver 2), or the DEF group (Approver 3), or the contract as a whole (which then also needs Approver 4 also). So, a Work Instruction requires between 1-4 approvers each time, and the next document type is the same in that it can also require between 1-4 (Ish) approvers. This is my struggle. I don't know how to build something like that and then add it into some nice App interface like you have here. Any way you can help? I spend every night currently combing through videos trying to find something like that but no luck anywhere. I envision a Request form that has a CHOOSE field with the different document types, then it asks which groups this document affects (ABC, DEF, or XYZ) and the customer can select as many of those 3 groups that he wants, to include all 3, and those then determine which approvers are required. HELP PLZ!

[@RezaDorrani]

Hi Ron, Firstly, thanks so much for watching & liking my videos. I do not have a video on your specific use case. It would be difficult to get videos related to organization specific needs. You could post your scenario on the forums and check if someone has done something similar powerusers.microsoft.com/ OR you could get consulting help to get this done. I will add your request to my backlog but chances of video being made are slim as I would need a lot more folks requesting this topic.

[@mron4161]

@@RezaDorrani Thanks for the reply Reza! I hope you and the family are safe and healthy in this crazy world of ours! As far as my complicated request goes, I've spent the last 10 years in IT supporting different agencies, and that concept made reality, and understanding it of course through one of your incredible videos, would be a real game changer in terms of supporting these agencies. A lot of people would love something like that around the folks that I support currently. There are some great groups of high level folks that are just getting into the Power Apps/Power Automate world and I'm sure many of them would love to see a video like this. I will say this, there's nothing out there like what I described, at least as far as I've found so far. I feel like it would be a masterpiece of a video. If you ever want to give this thing a try, please let me know. I'd love to talk it through and again, you'd reach new levels of Greatness as far as I'm concerned as there is nothing like what I described out there currently. Take care my friend! Micah

[@RezaDorrani]

@@mron4161 Send me the process on [e-mail] I will try and see what is possible with it and *may be I might make a video on it.

[@TheKermit2110]

Another brilliant tutorial Reza, thanks so much. Wondered if you had an in depth tutorial on the App build itself or if you've provided a import zip for it? Thanks again

[@RezaDorrani]

Check kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@SandyZhao-Sunshine]

Great video and great comment, Reza. I learned a lot about power platforms from your video, and I really appreciate it. One more question, Can we cancel the flow on the power apps side?

[@RezaDorrani]

Most welcome! Canceling flow is not an out of the box option. You would need to query inbuilt approval Dataverse tables to cancel the approval flow which would in turn require all power app users to have a premium license.

[@SandyZhao-Sunshine]

@@RezaDorrani Thanks😊

[@SandyZhao-Sunshine]

Yes, get it. Can we use the same way as the approve or reject, we launch a URL sending parameters to open the slide and let the requester cancel the requester.

[@RezaDorrani]

@@SandyZhao-Sunshine I have not tried that, but should be possible

[@billowiti3527]

Hi Reza. This is an amazing piece. Do you have a video on how to create the power app where users can login and either request/approve the leaves? Thank you!

[@RezaDorrani]

Thank You. Here is the video link kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@TheSusiew]

This is a great video - do you have more information on how to create the canvas app part?

[@RezaDorrani]

Yes! It's a different video kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@TheSusiew]

@@RezaDorrani , thank you

[@ArohShukla]

Reza.. Another excellent video. Do we have anyway to integrate this Power Virtual Agents so that employees can search their leaves balance without contacting the HR personal?

[@RezaDorrani]

Yes, can be done. I have done 1 video on Power Virtual Agents which showcases how to get data from Dataverse but same concept applies to SharePoint as well kzbin.info/www/bejne/pWPHmpatqNKLiMk

[@ArohShukla]

@@RezaDorrani you are awesome!!

[@ElaizaEspanola]

Hi Reza thank you for another great video! I’m wondering if you have a tutorial where an if an approval is sent, the approver has an option to request for more information? So it’s not either approve or reject.. thanks in advance!

[@RezaDorrani]

Most welcome! I do not have a video reference on that scenario

[@p.j.skibin9261]

Hello Reza. First, thanks for your videos they help me a lot! I’m curious how would one restrict access once the app is done so that requestors could not just click “Login as Approver” and vice vice versa?

[@RezaDorrani]

Even if tHey login as approver they wont see any tasks as the approval screen shows tasks assigned to current user.

[@p.j.skibin9261]

@@RezaDorrani ahh that makes sense, thank you for responding so quick!

[@RanjitSingh-xk9sb]

Thank you for great content.

[@RezaDorrani]

Thanks for watching!

[@darikae4719]

Awesome video, Reza! but where did you get the green check mark in the comment from?

[@RezaDorrani]

Those are emojis ✅

[@darikae4719]

Got it! Thanks, Reza!!!

[@abdulhaleem771]

Awesome. I was trying to achieve something similar to this. Thanks for the detailed explanation. Can we directly call approval action from the powerapp button (Approve/Reject) rather than navigating to flow page. Is there any api available for flow actions (approve/reject/re-assign)?

[@RezaDorrani]

No APIs

[@jean0961]

Thanks @ Reza this is awesome, can you also make a video on how to create the dashboard/app

[@RezaDorrani]

I will plan to do a part 2 on this where I showcase how I built the gallery and more. I have a session tomorrow on Power Apps galleries. If possible join my session - events.powercommunity.com/powerapps-developer-bootcamp-2021/ I also have a video on gallery designs - kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@omirahnoor8627]

Hi Reza, Amazing workflow video. But I am stuck on 26:00 mins I can't drag the manger approval down to HR approval. I am seeing this This action cannot be dragged below actions that depend on it." error message.

[@RezaDorrani]

I have made the sample app and flows available for download. Links are in description of this video - kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@chetanchauhan8482]

Awesome!!. Is there any way we can directly take action as Approve or Reject, without going Approval center?

[@RezaDorrani]

To directly take action you would need to update the Approval Tables in Dataverse which would require premium license capabilities for every App user.

[@powerplatforminsights]

Hey Reza, amazing video. can you pls also share a link of your video for the login screen , as a employee or manager , many thanks!

[@RezaDorrani]

This video was built with an existing template that Power Apps provides. The only supporting/connected video is kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@prajwalskateel]

awesome video, thank you

[@RezaDorrani]

Glad you liked it!

[@lucaswolffdematos1009]

Muito bom, como sempre!

[@RezaDorrani]

Obrigada

[@navodwickramathunga7015]

This video was great. Can you share leave request power app making video

[@RezaDorrani]

Many have requested me to make a video on the App itself. I have added it to my backlog.

[@mystiquelassiter5972]

Is there a video covering the development of the Leave Request application?

[@RezaDorrani]

I am working on a part 2 where I will showcase how I built the App

[@liraspberry6966]

@@RezaDorrani looking forward to it！

[@RezaDorrani]

@@liraspberry6966 Which parts of the App would you like me to build in video 2?

[@Anon0326]

when i try to move the manager approved below hr approval it does not allow me with info "This action cannot be dragged below actions that depend on it." you did the step at 14:12 minutes

[@RezaDorrani]

This error typically means something is dependent on actions above it. You may have to remove specific dynamic content properties between actions and try moving.

[@Anon0326]

@@RezaDorrani thank you

[@brendanbowen7097]

Awesome Reza! I really like that timeline where you can see the user photo and status icon and where it is in the process. Is that part of a nested gallery within that gallery or just referencing This item. Within the gallery? Maybe I'm over thinking it..😅

[@AdiCristea]

it's being shown at the end of the video, he's leveraging only the ThisItem property of the gallery.

[@RezaDorrani]

It uses the ThisItem property of the gallery.

[@brendanbowen7097]

@@RezaDorrani Totally missed that last part of the video - sorry. Thanks!

[@RezaDorrani]

@@brendanbowen7097 No worries 😉

[@gowdhamansarangapani2123]

Thanks for the video..I made myself as approver, like shown in video, Through email notification when am taking action its not going to approval form instead its going to home screen and nowhere i couldnt approved the ticket. What might be the issue?

[@RezaDorrani]

Issue must be with your logic of deep linking. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@MAG.experiences]

Hi Reza please make a video on Child Flows in power automate as well. If there is already such a video and please share the link.

[@RezaDorrani]

I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.

[@Vikassharma-ed8sp]

Hi Reza, your content and knowledge on PA is great! We do have a case where we are using Approvals in Flows, but for Dynamics 365 CRM. We have a case where user wants to bulk approve or reject their assigned approvals requests. Do you have any content on it? or if flows provide any API to update approval request (cant do from Dataverse as its the part of managed solution)

[@RezaDorrani]

I don’t believe there is any option for bulk approvals. Approval info is stored in Dataverse. There would be some option to update the approval tables but this is not something I have tried or looked into. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@prasadk3828]

Great Video, Reza. Could you share the Dashboard design video link?

[@RezaDorrani]

kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@sininv1]

Hi Reza.. this is awesome. Thanks Will u be able to teach also item check out and return records for admin and user. Thx

[@RezaDorrani]

I will add your request to my backlog but chances of video being made are slim as I will need a lot more folks requesting this topic for me to give it a higher priority.

[@gregjovenf.trinidad6535]

I Cannot drag down the manager's action since the Hr action is depended on Manager action, Please help

[@gregjovenf.trinidad6535]

Please respond to this,

[@RezaDorrani]

I am assuming you mean remove the manager action completely. I would have to update the App based on your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

[@RezaDorrani]

Responded

[@chidangphuong1869]

Hey Reza! Thanks so much for your video. It's exactly what I'm looking for. Do you have in mind any ideas how to create a Flow to manage the Leave quota for each employee, like after the leave request is approved, the quota of days-off will be updated accordingly, and this info will be shown to both employees and HR too? Thanks again!!

[@RezaDorrani]

My goal was to just showcase an idea. Yes, this can become a full fledged solution, get leave balance from HR system and update the leave count accordingly. I do not have any specific videos on that though. I will recommend you check on the forums at powerusers.microsoft.com/

[@supriyochatterjee4095]

Sir it will be great if you can please upload a video with detailed steps on how to create an automated dashboard in Power Apps like it will have several fields like Employees name, ID, Email, Salary,etc. etc. and on clicking the Employee ID or Email all other data's will automatically populate and reflect in the forms and table

[@RezaDorrani]

Will add this request to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.

[@supriyochatterjee4095]

@@RezaDorrani Ok Sir it will be very helpful if you can please kindly make it urgently because it's very very important and required ASAP

[@RezaDorrani]

@@supriyochatterjee4095 I have a backlog of over 100 items. Urgency is based upon number of requests. I will need a lot more folks requesting this topic. If you need ASAP, then check on forums at powerusers.microsoft.com

[@supriyochatterjee4095]

@@RezaDorrani Ok Sir as you wish but please kindly make a video on the topics as suggested as it will be of great help for anyone in any industry

[@RezaDorrani]

@@supriyochatterjee4095 I understand but I have to be respectful of everyone's request.

[@Eclipse4444EZG]

Do you have a walk through on how to create this exactly SharePoint list?

[@RezaDorrani]

No

[@brandonluu9475]

Is there a step-by-step video on how you built that powerapp dashboard? It looks really nice.

[@RezaDorrani]

I have a session tomorrow on Power Apps galleries. If possible join my session - events.powercommunity.com/powerapps-developer-bootcamp-2021/ I also have a video on gallery designs - kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@mariasaba8091]

Hi Reza great video! Is there a way to convert leave requests to pdf? Also can we export them to a folder and list them for records? Thank you

[@RezaDorrani]

I have done videos on exporting to pdf. In fact my most recent video shows that.

[@nani1485]

Can you please share the link for creating the canvas app for request and approval page ASAP if you don't mind please🙏

[@RezaDorrani]

kzbin.info/www/bejne/ZoaYm5SuYt-Af8U is the only other video I have on this topic.

[@lilachmaman4726]

Hi Reza, thanks for the tutorial! Is there any option to update the approver response directly from Power Apps? Or the only option is through the approval dashboard in Power Automate?

[@RezaDorrani]

To update from power apps one would have to update the Approval Tables in Dataverse (not recommended) + it would make the App a premium App.

[@lilachmaman4726]

Do you have a tutorial that explains who to do this?

[@RezaDorrani]

@@lilachmaman4726 I do not have a video reference for this

[@TheElementminer]

@@RezaDorrani Why do you not recommend this?

[@RezaDorrani]

@@TheElementminer Because we would be modifying system tables like Approvals. If its schema changes, it could cause issues.

[@mystiquelassiter5972]

Did anyone have an issue moving the "Manager approved" step below the "HR Approval" action. I keep getting a dependency error (This action cannot be dragged below actions that depend on it.). @Reza, any ideas?

[@RezaDorrani]

The app is provided for download at github.com/rdorrani/PowerApps/tree/master/LeaveRequestApp

[@brandonluu9475]

@@RezaDorrani Hey Reza, Thanks for the flow+powerapp, you're awesome! just a question though, I noticed that the flow in this video compared to the one in the github link are different, is the one within github the updated version? Thanks!

[@RezaDorrani]

@@brandonluu9475 Yes :)

[@christoperpramudita6391]

Hi Reza, Thank you for sharing this insightful video. Are you planning to publish a full step-by-step video tutorial to create this amazing tool in the coming days, since I have lost in "18:24 - Build a Flow Approval Dashboard in Power Apps for SharePoint", I can't follow in the part of creating Power Apps? THKS.

[@RezaDorrani]

Part 2 is coming this Tuesday. I will show how to build the App.

[@RezaDorrani]

If you need to see the video earlier for your project work then send me an email at [e-mail] I will share the lini

[@carlalirazan7030]

@@RezaDorrani hello Reza, can i send you an email as well as i would like to request an early preview of the video too. I was about to share on our team later on our tech forum that it this kind of approval flow is possible. Thanks for this great idea! You just unlocked the answer on our current question/challenge!

[@RezaDorrani]

​@@carlalirazan7030 Video is live now on my channel.

[@surajnautiyal8810]

Hi Reza, thanks for this content. can you please share or upload leave request app tutorial from scratch that you displayed in this video?

[@RezaDorrani]

Part 2 of the video coming next week in which I showcase how to build it from scratch. I will also plan to share the App after part 2 releases.

[@surajnautiyal8810]

Thanks Reza. I hope you will upload that content very soon.

[@RezaDorrani]

@@surajnautiyal8810 Next week

[@beunlimited9581]

Hi Reza, Thanks for the amazing video. I just want to ask i tried to drag Manager Approval Item below HR Approval. But power automate says this "This action cannot be dragged below actions that depend on it" Any advice for this? Thanks again Reza! :)

[@RezaDorrani]

There is some action below or above that has a dependency on it. You would have to check. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

[@beunlimited9581]

@@RezaDorrani Thanks Reza!

[@beunlimited9581]

@@RezaDorrani I think it's bcs i select the item on the Manager Approval section. So, that's why it says has a dependency on it. When i select when an item is created, i can drag it down. Do you think that is correct? Thanks again!

[@RezaDorrani]

@@beunlimited9581 I have no clue. It is difficult to provide guidance here on chat. Best place to post the issue would be the forums.

[@kingsleyo.ukaegbu746]

Please how did you personalize the approval dashboard to show only the log-on/requestors request details? how were you able to pull up the details on status?

[@RezaDorrani]

Video of Leave Request App - kzbin.info/www/bejne/ZoaYm5SuYt-Af8U Description also contains link to download sample app.

[@amitloutube]

this is good! Is it possible to do bulk approval of say 20 workflows from powerapps, using gallery- single comment for approve or reject and then those tasks will be approved

[@RezaDorrani]

Possible however it would require querying and updating Dataverse which makes the App a premium feature. Also, you would need to give App users additional access rights on the Approvals based Dataverse tables.

[@amitloutube]

@@RezaDorrani great thanks we tried updating but it does not complete the actual task may be I missed something it shows as completed, I think via postman I could post with json as {"properties":{"response":"Approve","comments":"dddd"}} but it requires bearer token which I am very close to getting and then post works just great

[@RezaDorrani]

@@amitloutube It is not that straightforward. You would have to pass token. I would recommend you check on the forums at powerusers.microsoft.com/ in case someone had sone something similar.

[@reniersmit1564]

How do you add an attachment for sick note perhaps? Thank you

[@RezaDorrani]

Use attachments control in form.

[@p.j.skibin9261]

Hello Reza, so how would we structure the flow if we wanted to allow the user to choose the approvers within their form rather than by using the “Get Manager” step?

[@RezaDorrani]

In the app, add an option for user to select approvers and send those details over to flow. I do not have a specific video reference for this scenario, hence giving the idea.

[@manniecobham]

Thank you so much Reza. My flow keeps giving me an error message when I want to save it "No Microsoft Dataverse database for this environment has been provisioned. Run this approval flow to initiate provisioning." What do I do about this?

[@RezaDorrani]

Looks like your are deploying the application in an environment that has no database provisioned. Flow approvals requires a database in the environment. Ask your environment admin to create one or import this application in the default environment.

[@rjparihar8101]

Thanks! As we can’t change the ‘Created By’ in approval flow. Is there any workaround to setup approval flow without using approval actions?

[@RezaDorrani]

Im not sure about other ways. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@SoumyaAnurag]

Hi Reza Great Work.. . This is exactly what I have created, tough the outlay is bit different. I do have an attachment that is required to be attached by requester and also the approvers need to see and check the attachment. Do you have an additional inputs on attachment. Eid Mubarak !

[@RezaDorrani]

Can easily be done. You can send the attachments either as list item attachments or an independent one.

[@SoumyaAnurag]

@@RezaDorrani Well in my flow I have approval notifications set through emails. So I have used "Get attachments", "Initialize variable", "get attachment content"', " append to array variable" this helps me to get the attachment independently in the email notifications instead of a link. My question is whether the same model will work in your approval model where the approval action can be done in the power app.

[@RezaDorrani]

@@SoumyaAnurag yes. Since I am still Creating approval in flow and even to take decision approver goes to flow.

[@SoumyaAnurag]

@@RezaDorrani Yes right. I got it at 22:57 .

[@johnaudu6961]

Hi Reza, Thank for sharing this video...I really appreciate. is there a way you can show me how you get Manager Image and that of HR Image?

[@RezaDorrani]

I have person type columns to store manager and hr approver information. I refer to the images of the person column in my gallery. I am working on a part 2 video wherein I explain the gallery design.

[@johnaudu6961]

@@RezaDorrani Cool

[@RezaDorrani]

@@johnaudu6961 Let me know what you would like me to build as part of the video. Just the gallery or the whole App?

[@johnaudu6961]

@@RezaDorrani Its just the gallery most especially the part where you get the Managers Image and HR

[@RezaDorrani]

@@johnaudu6961 Ok

[@RyanSmith-mh1lj]

Hi Reza, thank you for the wonderful video, since I am using my dev/personal account, how I should add a user or myself as Manager? My Flow failed at first, please direct me to one of your video or just advise me, much appreciate it!!

[@RezaDorrani]

It used AD connector to get manager. You can set user as manager in AD so the flow will pick it up. New M365 developer environments allow sharing apps with multiple users.

[@RyanSmith-mh1lj]

@@RezaDorrani , appreciate your kind information, I will create user as manager in AD, thanks again! Your videos are very beneficial.👍

[@capitalgoose97]

Hi Reza, awesome video, I am just having 1 problem: Around the 10:30 mark in the video, you put a link in the field ‘Approval Link’, I have ‘Approval Comments’ but missing the Link field underneath, is there something I can enable to see this field?

[@RezaDorrani]

Approval Link is a column in the SharePoint list. It will show up in update item action in flow if column is created in SharePoint.

[@capitalgoose97]

I have realised my mistake, I hadn’t realised the Sharepoint columns controlled the ‘Update Item’ field on Power Automate. Thank you!

[@capitalgoose97]

Sorry another question, in Powerapps when I look at the Power Automate tab it doesn't show me flow, after a quick look on forums it suggests my flow needs to use a 'Power Apps Trigger’, I have deleted and recreated the whole flow in case I missed something but still cannot see the flow from Power Apps

[@RezaDorrani]

@@capitalgoose97 it should show up as long as app and flow are in same environment. I will recommend posting your issue with screenshots on the forums

[@ashu60071]

I was wondering how did you maintained those records in sharepoint. Can you tell me how did you do that??

[@RezaDorrani]

github.com/rdorrani/PowerApps/tree/master/LeaveRequestApp

[@culitz]

how about if the leave request is approved and the requester needs to edit the request. what will be the flow?

[@RezaDorrani]

I would have to try that scenario out to know the steps. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@sebastiancorredor8153]

Hi Reza, Have you the creation video of this app?

[@RezaDorrani]

Here it is kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@divyanshipareek5918]

Can we use kanban board view in power apps? How can we create it . Can u make a separate video?

[@RezaDorrani]

Possible - powerusers.microsoft.com/t5/Building-Power-Apps/Kanban-Board-Gallery-move-to-next-lane/td-p/754362 I will add this request to my backlog.

[@divyanshipareek5918]

@@RezaDorrani Thanks Reza. I will take it as reference and definitely will be waiting for ur lecture on this.

[@RezaDorrani]

@@divyanshipareek5918 I will need a lot more folks to request this topic, in order for me to give it a higher priority.

[@dannya.5812]

Hey Reza, when following your steps at 12:12, I have the use case where I am using an M365 group for the approvers (instead of doing the "Get Manager" method) so multiple people could start the approval process for my flow. Given this, how would I need to update my flow to still have the same process/outcomes as yours in this video? I understand that this may not be enough info for you. Any help would be appreciated :)

[@RezaDorrani]

Not enough info + I would have to try it out to know the steps. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@St_NiKoS]

Hi Reza, thanks for your videos. Small suggestion regarding approval comments - you can activate versioning in the "Leave request" list and then activate "Append Changes to Existing Text" on the "Approval Comments" multi-line text column. Once it's done, each time you update the "Leave request" item SharePoint will append automatically timestamp and new text above the previous entries in this column. So, by doing this, there's no more need to copy approval comments from previous steps in each Power Automate update list item action block. P.S. Do you have any particular videos or articles on how to overcome the 30 days flow duration limit in order to manage automatically the long-lasting approval processes and resend approval requests ?

[@RezaDorrani]

All good points. Append changes will not show full history in Power Apps. It will only show latest version. Long running flows - kzbin.info/www/bejne/nmeok2B8ZbVpftU

[@St_NiKoS]

​@@RezaDorrani , you're right, there's no easy way to show the full history of multi-line field changes in Power Apps. Actually, it can be done be doing the API call and concatenating the response results, something like this : www.c-sharpcorner.com/article/display-appended-comments-version-history-from-sharepoint-list-on-powerapps/ But for sure it's much easier just to copy the previous comments to the next update blocks in Power Automate flow.

[@RezaDorrani]

Calling a flow to get data from Power Apps is not the most efficient method. Imagine calling a flow for each item the user visits to get the versions. Imagine scenarios where there are 100s of users simultaneously accessing the app.

[@anjanchidige]

@Reza, fantastic content. Is it possible to approve/reject the flows through REST API? Reason is, we have a Power Pages Portal and I would like to show the requests waiting for approvals for users. When users clicks on Approve/Reject(HTML controls placed by me) button, I call a REST API and update the flow. This should move the Power Automate Flow. Pls suggest.

[@RezaDorrani]

Not that I am aware of.

[@darespusta]

Can you share how you achieve having the profile picture and display name together in a person/group column?

[@RezaDorrani]

In Power Apps? That is showcased at the end of the video. In SharePoint, you can go to column settings and there is a setting which shows the person picture and display name.

[@amyhampton8913]

Why am i getting a message that i can't move the 'Manager approved' under the 'HR Approval' in the If Yes condition. It gives me an error "This action cannot be dragged below actions that depend on it.

[@RezaDorrani]

Because there are dependent actions. You cannot just move actions around if there are dependencies.

[@ajaychoudhary5596]

Reza is it possible bulk approval scenario(means select all approval once and approved in one click).when you feel free pls suggest🤔

[@RezaDorrani]

Not possible with the approval action in flow. It will be one by one.

[@MadRockway]

Hi Reza, Please upload some modal driven apps and portals videos.

[@RezaDorrani]

I have not done any work on portals. No plans to include videos on that. Model-driven I plan to cover as part of my training course coming later this year.

[@Pedrodecarvalh]

Hi Reza, is it possible to instead of having the approval "out of the powerapp" to be inside? so the user doesnt need to leave the app to approve?

[@RezaDorrani]

Possible by connecting to Dataverse tables for approvals and modifying them from App. However this would make the App premium and ever user accessing App will need a premium license.

[@Pedrodecarvalh]

@@RezaDorrani Thanks for the quick answer! do you have some documentation/video on how to do that?

[@RezaDorrani]

@@Pedrodecarvalh I do not have a video on this. I will recommend to check on the forums at powerusers.microsoft.com

[@wAvm]

why does add automatically apply to each when I put the "Leave Type Value"?

[@RezaDorrani]

Probably because leave type is a multi-choice column in your case? I will need to look at your scenario in action to know more. I would recommend posting your issue with screenshots on forums at powerusers.microsoft.com/

[@mellowtones1985]

Hi Reza I have set up an approval flow starting from Forms I see that you used a list, I wanted to know if it matters?

[@RezaDorrani]

I am assuming you mean Microsoft Forms. It does not matter from an approval standpoint. I am working on a video on approvals with documents uploaded via Microsoft Forms.

[@huiyichua135]

Hi Reza, may I know how do you make the PowerApps Dahshboard?

[@RezaDorrani]

kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@JiteshDhumal-q2n]

Is it possible to have to approve and reject button on the PowerApps form than in email?

[@RezaDorrani]

Watch kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@JiteshDhumal-q2n]

@@RezaDorrani Thanks, Reza

[@dxctechnologyslovakia]

Hello Reza, I would like to ask you if it is possible to create approval flow in Power Automate of type "First to respond" and use generated links for every approver in Power Apps as approve/reject buttons, where each approver will have button with his own links (because when you use First to respond, links for approve/reject action are different for every approver). I can't store only one link in sharepoint list item and use it in power app as there will be more links generated. Thank you

[@RezaDorrani]

I have not tried this scenario hence not sure if that is a possibility. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@ramprah8910]

Hi Reza, I am not able to reply to your messages on the Power Users forum. I meant to say, we sure will contact you sometime during July! Thanks.

[@RezaDorrani]

Here is my email id: [e-mail]

[@ramprah8910]

@@RezaDorrani , thanks!

[@AndrewsRosalie]

Hi Reza, May I know what is the reason my status and approval comments cannot be updated in the SharePoint list?

[@RezaDorrani]

I cannot guess the reason here on chat without knowing the full picture. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@paapaak]

where can I get a video of how this was built from sratch?

[@RezaDorrani]

kzbin.info/www/bejne/ZoaYm5SuYt-Af8U

[@vincenthesse8928]

Hello Reza, I hope you're doing well. I have a project but I prefere to ask a question : is it possible to build an app to manage Leave Request in Sharepoint and Power Apps taking into account part-time work, giving people the possibility to take half days off and taking into account public holidays. It should be noted that public holidays change depending on where people are located. Is this a feasible project? Do you have a consultancy service ?

[@RezaDorrani]

Feasible - Yes. You can send me an email at [e-mail].

[@jonathanvargaszuniga7478]

Hi Reza this is great! Would this work for a standalone app Im creating where I already created the form and need to have another screen just for the Admin ( approver/reviewer)?

[@RezaDorrani]

The App showcased in the video is a standalone App. So concept should work with any App.

[@jonathanvargaszuniga7478]

@@RezaDorrani Reza, do you charge for coaching? Does you or your company can join a call and charge for an hour or 2 depending on the need, I have an app I’ve been working for the past 4 weeks but I see some bugs when sending info to the Sharepoint

[@RezaDorrani]

@@jonathanvargaszuniga7478 Send me an email at [e-mail]

[@jonathanvargaszuniga7478]

@@RezaDorrani done, thanks

[@sumsumtulang25]

the comments name under the approval column can I change to other name like cost centre? like I want the approval to put in the cost centre code for example 305 if he approved the request.

[@RezaDorrani]

Im assuming you mean the data cards on form control in Power apps. You have full flexibility there.

[@sumsumtulang25]

@@RezaDorrani the stage where manager need to approve the leave. In the power automate. After click approve, there is a column under with name comments (optional). I want the manager to key in important details (for eg cost centre) after approve so it would be captured in the sharepointlist. Is it doable? I mean to change the comments name to cost centre name so that manager after approve need to key in the cost centre.

[@RezaDorrani]

@@sumsumtulang25 Approval forms are not customizable

[@akhiljawahar2984]

Is it possible to add Dynamic Approvals in Power Automate for the SharePoint List-based Approval process? This is urgent; please advise.

[@akhiljawahar2984]

How can I restrict access to an approval form using SharePoint login credentials?

[@RezaDorrani]

I have done multiple approval videos that are all placed in a playlist called approvals cookbook.

[@twismfamily]

Although this video was done 3 years ago, Power Automate will not allow me to swap HR Approval above the Manager Approval, unless there is a secret setting I don't know about to allow those kinds of changes.

[@RezaDorrani]

There is no secret setting. It's probably because there are dynamic content values dependent on previous actions being in that order. That's my guess.

[@twismfamily]

@RezaDorrani Yes, but following along your video I have the same information as you do. I wonder if Microsoft changed something between when you built it compared to now. Thanks Reza, your videos are always so awesome ☺️ 👍

[@RezaDorrani]

@@twismfamily I am not aware of any changes since

[@2007pradipta]

Hi Reza i hv few questions 1. Can we approve from powerapp itself without going to flow page? I mean some kind of programming in powerapp. 2. Is it possible if approver goes directly to list he can only see item where he is the approver.

[@RezaDorrani]

1 - You would need to update the system based Approvals tables in order to do so from Power Apps. Not a supported/recommended approach. Currently its best to go to flow. 2 - You could create a view to only show items where user is approver. If you need true security then you would need to break item permissions as the workflow moves along

[@2007pradipta]

@@RezaDorrani thanks a lot ..breaking permission would have adverse effects..since we hv many items to be created

[@RezaDorrani]

@@2007pradipta Not a good idea then to do so. Performance would be impacted. You may need a better data source like sql or dataverse (both are premium). Alternatively, use views in SharePoint to show hide info. Will be more like audience targeting than security.

[@Daviirose3]

Power Automate Approvals has not been installed for this environment. Run this approval flow to initiate provisioning. ??

[@RezaDorrani]

Looks like you are creating your flow in an environment which does not have Microsoft Dataverse database setup. You will need the database created since Approvals information is stored in Dataverse.

[@Daviirose3]

@@RezaDorrani thank you!

[@chintandd]

awesome Reza. Your workflow showing progress looks too good. I will use it in my PowerApps. @Reza - I am not getting "Respond link" in dynamic content. I have used "Create approval" action. Is this option avail. in some feature activation. My account is having E3 license. PS: I am getting "Respond link" in same parallel branch where "Create approval" action exists but not getting "Respond link" in another parallel branch. why that so?

[@RezaDorrani]

You cannot get dynamic content of an action from 1 branch in another parallel branch. You would need to store that in variable so other branch can grab the value.

[@chintandd]

@@RezaDorrani thank you - I grab it in variable and it worked out. Where did you get approval status (approved/rejected) of each approvers ? Do PowerAutomate has out-of-box metadata to capture each approver or did you create custom site column for each approvers?

[@RezaDorrani]

@@chintandd Its a part of the dynamic content that the approval action provides. Check my playlist on approvals - I have a lot of scenarios covered there - kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe

[@sarank75]

How to update SharePoint list data using the canvas app and power automate flow like if I'm going to change my name Ram into Ramkumar in canvas app that time power automate flow going to Update the SharePoint list. can you upload this concept

[@RezaDorrani]

I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Be on the lookout for the next topic suggestion discussion.