Just been following the steps to use the people picker column (21:46), but adding the Approvers Email is throwing in another Apply to Each. I tried following the rest of the step anyway but the flow failed and gave me this error message: "The execution of template action 'Apply_to_each_8' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_7')' is of type 'Object'. The result must be a valid array." Am I doing something wrong or does the video need an update?
@RezaDorrani3 жыл бұрын
You can use the expression item()?['Email'] to grab the users email which should not create the second for loop.
@jonesyp803 жыл бұрын
@@RezaDorrani Thanks for the reply, that has worked a treat. Absolutely swear by your channel for my flows and apps, keep up the great work. 👍😁
@RezaDorrani3 жыл бұрын
@@jonesyp80 Thank You :)
@tiagodjin3 жыл бұрын
@@RezaDorrani Hi Reza, I´m having the same issues and tried to insert in the map field, but it says it´s not a valid JSON. What I am doing wrong? Should I add something prior this expression? Tks!
@RezaDorrani3 жыл бұрын
@@tiagodjin I would have to look at your flow screenshot to provide any guidance. Try posting your issue with screenshots on the forums at powerusers.microsoft.com/
@paularoberts53243 жыл бұрын
Reza, you're a great teacher - I'm so glad I found your videos. Best stuff I've found after weeks of trying to learn how to set up Approvals in Power Automate
@RezaDorrani3 жыл бұрын
Glad you found my channel and welcome!
@josephansah4 жыл бұрын
You just have a really great way of teaching so that people just get it. And the little suggestions that show attention to detail are so useful and make it easy for anyone to find a way to make the outputs of their flows so intuitive and user friendly. More power to you 🙂✨
@RezaDorrani4 жыл бұрын
Thank you for the wonderful feedback Mojo
@evolutionofj5443 Жыл бұрын
Thank you for just keeping it to the steps! Some "how to" videos are so hard to watch because they go on and on and on about nothing.. You are like do this do that do this do that and voila! I appreciate that so greatly!
@RezaDorrani Жыл бұрын
So happy to hear this feedback. My style is to get straight to the point 😊
@golfnutt83 жыл бұрын
What an outstanding tutorial! Thank you Reza for putting this video out there for Power Automate learners!
@RezaDorrani3 жыл бұрын
Glad you enjoyed it!
@toddcjohnson14 жыл бұрын
Just completed my multiple approvals. Works great. Thank you!
@RezaDorrani4 жыл бұрын
Thank you Todd. Happy to know it was useful.
@saafiyahadams40223 жыл бұрын
Curious to know how you set the email addresses? I'm busy with 3 tier approvals but when I update the second approval list to the second department it sends out to the first departments email addresses.
@ThoughtDiffusion4 жыл бұрын
SInce long I was just thinking to develope this in my project, we had no clue of it and we kept this kind of things to be in the last bucket. Now this video has really helpful to me and we have develope the big componet on your idea. You are awsome. I am thankful to you and looking for such good videos on power apps which are not avaiable or people seeking for it.
@RezaDorrani4 жыл бұрын
Thank you for such amazing feedback.
@yehunlavolontededieu3224 жыл бұрын
Thank you Thank you Thank you Reza for each minute and sec you invest in the preparation of these vidoes and trying your best to make it simple for us to understand and going back and forth to diff tabs just in effort to making it easy for us to understand.
@RezaDorrani4 жыл бұрын
Wow that is some amazing words for me. Thank you and appreciate everyone who watches my videos. 🙏
@andrewsmalley4 жыл бұрын
Thank you so much Reza, this video is just what I needed to implement an approval process in my app. Love the cookbook series!
@RezaDorrani4 жыл бұрын
Thank You Andrew
@baldaniyahenik4 жыл бұрын
Again Very well explained. I liked the 'Approver comment' concept which is helpful to understand to an end user in real case business scenario. Thanks for sharing.
@RezaDorrani4 жыл бұрын
Thank you Henik
@gustavomonne49214 жыл бұрын
Great video, as always the idea of the Audit Trail and the emojis very clever. Thanks
@RezaDorrani4 жыл бұрын
Thanks for watching Gustavo. Audit trail is imp since flow run history is only 28 days.
@michaeldonohue71864 жыл бұрын
Thank you so much for making this video! It was so helpful,. I have watched your expressions 101 and 201 and still learning, Thank you for providing examples of the tools and a way to understand them. Having a hard time converting UTC time but working on what i may have done incorrectly. Thanks!
@RezaDorrani4 жыл бұрын
Thank you for watching Michael. Glad you have seen the expression video series.
@safetysay27563 жыл бұрын
Great teaching skills, Reza!
@RezaDorrani3 жыл бұрын
Thank you! Cheers!
@sujithamary90663 жыл бұрын
I started watching all your videos…it really helped me so much in learning power apps and flows…I would like to request you to show how can we log history for multiple approves…I mean like parallel approvera
@RezaDorrani3 жыл бұрын
Will add it 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.
@richardshaw83263 жыл бұрын
Thoroughly enjoyed your videos @Reza--very informative and well-presented. Following the steps for the people picker (also on 21:45), and not erroring out (yay!), but somehow only getting the first person in the people picker column. Wondering what I'm doing wrong and if anyone else has run into this behavior.
@RezaDorrani3 жыл бұрын
I will have to look at your flow in action to provide guidance. I would recommend to post your issue/query with screenshots on the forums at powerusers.microsoft.com
@richardshaw83263 жыл бұрын
@@RezaDorrani thank much. Just posted on there and tagged your kind self 😊
@RezaDorrani3 жыл бұрын
@@richardshaw8326 I go on forums only in my free time (very limited these days). Hopefully you get a response from the many experts there.
@angzien91083 жыл бұрын
Hi, having the same issues as only getting 1st person in the people picker. have u resolved the issue ?
@RezaDorrani3 жыл бұрын
Check pinned comment thread for video.
@Naseemkhan-hl3kx Жыл бұрын
Great work raza bhai. waiting for more videos on dataverse.
@RezaDorrani Жыл бұрын
I will try my best
@robotsretrosspaces2 жыл бұрын
Can I just say, this is an excellent tutorial!
@RezaDorrani2 жыл бұрын
Yes, you can :) Thank You!
@amysenecalcote87363 жыл бұрын
Great video Reza, so helpful - however I have a question that was not answered here, maybe you have in another video? How can we configure the approvers from the SharePoint Site owners group?
@RezaDorrani3 жыл бұрын
To get SharePoint group users, check kzbin.info/www/bejne/jYWTaZuAZt93r9k
@gregoryreddin12223 жыл бұрын
Reza, as others have said your videos are great. You are direct and straight to the point. Very easy to follow. Quick question, could you share how you inserted emojis in the flow? I would like to learn how to do this. Thanks.
@RezaDorrani3 жыл бұрын
Thank You for the feedback! The emojis were just copy pasted from the web - emojipedia.org/
@DanielADamico4 жыл бұрын
Always w/ great videos! Thanks Reza!
@RezaDorrani4 жыл бұрын
Thank you Daniel.
@ipigney3 жыл бұрын
Great series Reza, thanks so much for taking the time to prepare these very useful videos. I am trying to replicate the dynamic approvers scenario in my own environment but every time I try to insert the Select action on the Approver Email entity the step is wrapped in a second "Apply to Each" loop. This fails when run because the output from the select is an object and it needs to be an array. I've followed your steps a dozen times and checked that the output from "Get Items" has the expected values (the Approvers are in an array, and each one has a single Email entity), but I'm at a loss why the flow editor keeps putting an Apply to Each loop around the Select action. I've searched online for several hours and I'm about to give up on Power Automate altogether. Any pointers?
@RezaDorrani3 жыл бұрын
Can you point me to the time in the video wherein I show this scenario. Sorry its been a long while since I did this video :)
@ipigney3 жыл бұрын
@@RezaDorrani Hi Reza, around 21 minutes, you start by adding a Select step.
@RezaDorrani3 жыл бұрын
@@ipigney Ok. The select action will add an apply to each loop since Approvers is a multi select person column. After select key is to use the join function as shown in video and then append it to the variable.
@amreiss3 жыл бұрын
@@RezaDorrani I am having the same issue. Same as Ian, I am unable to replicate as you have in the video. I start the select statement and enter "Approvers", this forced a for each loop (which makes sense and same as you have in the video). When I go to map the Approvers Email, the second I select, it creates another for each loop (this does not happen to you in your video). It would be amazing if you could go back into your power automate flow you used for this video, delete the select command and recreate the select piece as I think you may run into the same error - perhaps caused by a change in how Office handles people objects?
@RezaDorrani3 жыл бұрын
@@amreiss This must be some change in flow schema if it is creating a double loop. I will check this once I come back from my vacation :)
@dkfresh66563 жыл бұрын
@Reza - Thanks again for another great video! I had one question regarding the dynamic approvers using the 'get department' approver list with the people picker column. On the step where you use the 'select' operator and do the 'map' to the approvers email - when I try this, it adds another apply to each loop. In your video it did not. I continue with your steps but then i get an error "the result of the evaluation of 'for each' expression'@items('Apply_to_each')' is a type of 'Object'. The result must be a valid array." Any thoughts on what could be causing this?
@RezaDorrani3 жыл бұрын
I have had 2-3 people tell me about the same issue of a second loop. Looks like some schema change from MSFT that is causing that, This is something I have to look at. Meanwhile try posting this query on the forums at powerusers.microsoft.com/
@azul31063 жыл бұрын
Wow - you see it, too :) I am not going crazy. Did you find a solution to this? I have attempted to implement and run into the same problem. Thank you for any feedback you can provide :)
@RezaDorrani3 жыл бұрын
Here is the fix. Use expression item()?[‘Email’] inside the main for loop to avoid the second one.
@azul31063 жыл бұрын
@@RezaDorrani Thanks for responding. If you were to amend the video, where do I place this expression in the loop? After I set up the filter query in "Get Items" as in the video, I do Data Operations -> Select. In "From", I choose the "Approvers" column in Dynamic Data (which opens the first loop). In "Map", I choose "Approvers Email" (which triggers the second loop). But if I enter item()?['Email'] in either, I get an error 'enter a valid JSON'. Thanks so much for any clarification.
@RezaDorrani3 жыл бұрын
@@azul3106 In the first for loop. If its causing error then I would have to see your flow in action to know exactly why. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com
@brucelee-sq6vd3 жыл бұрын
Hi Reza, In 21:34, after switch to text mode, 1. I insert dynamic content "email", 2. and it auto add another apply to each. Doesnt seem work as what you did. Is this trick still applicable?
@brucelee-sq6vd3 жыл бұрын
i manage to resolve the issue by insert expression item()?['Email'] instead. Guess this is some UI bug.
@RezaDorrani3 жыл бұрын
Looks like you got it to work using item()?['Email'] expression.
@chantalmeynendonckx30583 жыл бұрын
Dear Reza, many thanks for your fantastic approvals cookbook serie! I have a question on the dynamic approvers... taking your SharePoint list as example, is it possible to select both Marketing and Finance as department. I have enabled multiple choices on the list, but I am not succesful in creating the Power Automate approval. thanks for your help as always! :)
@RezaDorrani3 жыл бұрын
Possible but the flow would have more loops. I would have to try it out to provide guidance. I recommend posting your query with screenshots on the forums at powerusers.microsoft.com/
@alejasa47342 жыл бұрын
I have exactly the same case where Multiple Departments will be selected each time dynamically- Is there any solution for that?
@edilks932 жыл бұрын
Just incorporating your approval steps here into my flow and gotten an error at the "approval" step. Error message of "BadRequest. The request failed. Error code: 'InvalidApprovalCreateRequestAssignedToMissing'. Error Message: 'Required field 'assignedTo' is missing or empty.'." My assigned to field is using the varApproved variable according to your video. Not sure where it went wrong. Also would like to add that you've been my Power Automate savior. Especially to those without much IT/coding knowledge, your video has been super helpful so far.... Cheers mate!
@RezaDorrani2 жыл бұрын
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@hareshassanali37193 жыл бұрын
Thx Raza for you continuous great effort but I have a question if you could explain for us how you create the assigned to column in the Help disk list.
@RezaDorrani3 жыл бұрын
It is a person type column of type multi select.
@hareshassanali37193 жыл бұрын
@@RezaDorrani thx sir, but sorry what I was need is category column and how you link it with the Departments.
@RezaDorrani3 жыл бұрын
@@hareshassanali3719 Its a lookup column to Departments list.
@chamreth3 жыл бұрын
May you share me the study part from Beginner to Pro Power Apps ? source and material please. All your video is amazing and clear.
@RezaDorrani3 жыл бұрын
Check my playlists kzbin.infoplaylists Also check aka.ms/powerappsresources
@pvsrk924 жыл бұрын
Great video. Especially Data Operations one was awesome...Thank you
@RezaDorrani4 жыл бұрын
Thanks for watching
@HadiElJundi2 жыл бұрын
Hi Reza. First of all, thank you very much for your videos, I have never seen such detailed intricacy in any tutorial I have encountered. I praise your great work and clear explanation throughout all your videos and tutorials. Simply wonderful! I have been able to create the same concept in your video, but through a document library to have dynamically grabbed approvers from a list I created in my SharePoint site. I have tested the workflow and it triggers correctly, with the status (Draft, Approved, Rejected) correctly marking, and the flow is running successfully when tested. However, I have noticed that the approval request notification reaches the approver multiple times, even after the approval or rejection is completed. Also, I noticed that, after the document is approved or rejected, its status returns to "Draft" in the sharepoint library to which this workflow is connected. Any idea on why this is the case? I see check marks (marking that the work ran successfully) as well. Your advice would be greatly supported.
@RezaDorrani2 жыл бұрын
Thanks for the feedback on the content. Much appreciated! As for your issue, I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@adnan1343 жыл бұрын
Hi Reza, Thank you for creating this tutorial. It really helped me understand the concepts and build an automated flow. I would like to ask you: What is the type of "Approval Comments" Column in your SharePoint List. I enabled versioning on my SharePoint list, created a Column of type: "Multiple lines of text" and checked "Append changes to existing text" to ensure the history is logged correctly. All comments are logged correctly EXCEPT that there is my name and date appearing before each comment automatcially. Also, I can see "View Entries" link to see the history instead of the comments directly in SharePoint. Can you kindly advice: 1. How did you setup your "Approval Comments" column in SharePoint List 2. How can I make sure that the comments are directly displayed in "Approval Comments" column, instead of "View Entries" hyperlink Thank you for your extended support.
@RezaDorrani3 жыл бұрын
Approval comments columns is a simple multi line text column (no versioning turned on). In the flow, I ensure I append the previous comments prior to adding the latest comment. View entries shows up if versioning is turned on.
@kristensoderlund93882 жыл бұрын
Thank you Reza! Your videos are very helpful. I have looked through the approval videos and I cannot seem to find out how to prevent the "pending" status from updating to "approved" until all approvers have responded... I am working from a document library approval flow.
@RezaDorrani2 жыл бұрын
There are videos that show that. Here is my full approvals playlist kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
@robbeckwith7120 Жыл бұрын
Hi Reza, thank you for all your videos - they are a guiding light to get going. I've tried copying this approval flow using the current Power Automate and it keeps inserting for each loops everywhere (when in your video they do not appear). The nested loops keep complaining and failing when I try to implement the dynamic people picker, towards the end of the video (the Select, Join and Set functions). Any advice on how to stop these loops?
@RezaDorrani Жыл бұрын
Most welcome! I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@zixintang13053 жыл бұрын
Thank you so much for making this video. How can we handle the scenario that the flow has been running halfway, waiting for approver to approve but we changed the approver from A to B?
@RezaDorrani3 жыл бұрын
Once approval task is assigned to an approver, it can be reassigned by the approver of the task. Updating approvers in configuration list, will not automatically update the tasks.
@HazelChikara4 жыл бұрын
Wow, that is very comprehensive, thank you!
@RezaDorrani4 жыл бұрын
Glad you enjoyed it! Thank you Hazel.
@ResponsibleXI4 жыл бұрын
Woww!! Incredible Reza!!
@RezaDorrani4 жыл бұрын
Thank you 😊
@maxw10613 жыл бұрын
Hi Reza, thank you for this very helpful video. What I liked a lot: 1. I was looking for a solution to send emails to users within a "multiple user" column. Thanks for your awesome explanation of how doing so. 2. Including the in depth view on the JSON queries is awesome. This helped me tremendously to understand and use this to my advantage 3. Potential Video Idea: What are the options we flow creators have, to ensure data protection of the users of the flow? This is the final thing I'm struggling with in my workflow: In the very last step, my workflow grabs a file from a SharePoint library. The file got uploaded by a random user, initially triggering the workflow. Once all approvals are in, the file is sent automatically via a Send an Email (V2) action to a person in HR. Unfortunately, this email appears in my outlook mailbox within "sent items" including the attachment. --> question is: what are my options to keep the file secure and hidden from myself? Using service accounts? Deleting the email from my sent items folder? Or can the flow be initialized under another user in the first place? I fear that this will be the end of my otherwise very helpful workflow :(
@RezaDorrani3 жыл бұрын
Thanks for the feedback and glad you liked the video. Understanding JSON and working with expressions is key. I will also recommend the following playlist for learning expressions - kzbin.info/aero/PLN-cZRQeAiDVQ-6ZWGr43yyTcpu6mUgrR
@JoyceZhang-xj1xw Жыл бұрын
Hi Reza, Thank you for this very helpful video. I have a question. Is it possible to let the approvers to approve one by one? once the first approver approved, then go to the second approver
@RezaDorrani Жыл бұрын
I know a guy who did a decent video on this topic. Check kzbin.info/www/bejne/nZPCd4ibh8-anZY
@juliusalinda3820 Жыл бұрын
But the the approvers are not dynamically picked from the sharepoint list
@BABA-is8kv3 жыл бұрын
Just an Amazing Video! Thank you!
@RezaDorrani3 жыл бұрын
You are most welcome
@GIO2000114 жыл бұрын
Thanks for the awesome video. I was doing an approval flow and I was using a hard text email in an excel table, so this is far better way. A question, how do you show the people's photo? I found that in the modern view you can't have it and you need to switch to the classic version. I think you are using the modern view, so how do you do it?
@RezaDorrani4 жыл бұрын
Using PnP column formatting samples. github.com/pnp/sp-dev-list-formatting/tree/master/column-samples I also have a video coming out tomorrow which will be on interest for SharePoint folks - kzbin.info/www/bejne/r5DFlZ2Dh62Jo7s
@GIO2000114 жыл бұрын
@@RezaDorrani thanks for that resource! I didn't know it, and there is a lot more. The new video is also great! I wasn't able to find the exact json code that you used; could you, please, share the code you use? Thanks again!
Hi Reza.. Thanks you for this great Video. How did you make the "Approval Comments" field hidden when a new item is created/ when a new entry is added?
@RezaDorrani4 жыл бұрын
Hi Calvin, that needs to be done in SP. You can customize SP list forms and hide fields. docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide
@calvinmunisi3464 жыл бұрын
@@RezaDorrani Thank you very much it worked! :)
@sadashivappagirish73293 жыл бұрын
Thanks for all of your videos. Request your help to resolve the issue: In case of dynamic approvers, my flow requires any one approval, but I want to notify the other approvers that the task is picked up and its in progress. Any directions, will be of great help.
@RezaDorrani3 жыл бұрын
There is no option to take ownership of a task. If your approval type is first to respond, the first person to respond, their decision will be taken as the outcome. If other approvers respond, they will receive a notification that a task is complete. You can also send them a notification email from the flow if required.
@sadashivappagirish73293 жыл бұрын
@@RezaDorrani Thanks for your reply.
@sadashivappagirish73293 жыл бұрын
@@RezaDorrani I have created a workflow for document approval. Once the document is approved it moves to different folder for better tracking. Now, I want to update the workflow with three folders, but here I am not able to establish or get the link of the file to add action from second folder. Any pointers please.
@RezaDorrani3 жыл бұрын
@@sadashivappagirish7329 Best pointer would be the community forums - powerusers.microsoft.com/
@jp007k3 жыл бұрын
Thank you for sharing this; it is quite helpful.
@RezaDorrani3 жыл бұрын
Thanks for watching
@TheMKTube3 жыл бұрын
Amazing video Raza! Thank you! A bit off-topic but is there a way an approver can recall/cancel their approval after approving the item, let’s say within 1 hour (let’s suppose in case something changes)?
@RezaDorrani3 жыл бұрын
Approver cannot recall or cancel a completed approval. If a modification is made, then you can design the workflow to retrigger. Check my approvals playlist - kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
@alzaimoor794 жыл бұрын
Great video, simple and very clear explain, how do you use emoji? What’s keys to input emoji?
@RezaDorrani4 жыл бұрын
I literally just copy pasted them from the web into the editor
@kurtcasteleyn233011 ай бұрын
Hi, first of all: great content in your cookbook, it's been a great help for me! I still have this question: do you have an example of dynamic approvers in this situation: Approver 1 approves, Approver 2 approvers, Approver 3 rejects => creator gets notification of rejection of Approver 3 and modifies the file => After reactivating the flow, Approver 1 and 2 does NOT get notification, only Approver 3... Txs for the reaction(s)
@RezaDorrani11 ай бұрын
Thanks! I do not have a specific video on your scenario.
@gopalyadav94729 ай бұрын
Hello Reza, Thank you for all you do ❤ I'm trying to build a Dynamic Approval flow, Similar to the one you've shown here. However, My flow filter in Get items has 3 filters" (Department eq 'DEPARTMENT VALUE') and (Country eq 'COUNTRY VALUE') and (RiskLevel eq 'RISK LEVEL VALUE') ". When i test the flow, the slow doesnt get inside the "Apply to each" action and gives an error at "Start and wait for approval"(There's an error in your flow preventing the creation of Approvals. Use the link below to learn more about the errors with your flow and/or environment configuration.) I'm unsure what I'm doing wrong. (I'm trying Build an approval flow based on 3 filters criteria, The approval goes to a person based on what country, Department and Risk level the user chooses) Please advise 😅
@RezaDorrani9 ай бұрын
I have not come across any issues with this and would have to reproduce your scenario/issue to know what can be done. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.
@gopalyadav94729 ай бұрын
@@RezaDorrani Thank you Reza, Let me try posting it in the Forum with Screenshots. :)
@shadi14772 жыл бұрын
Hi Reza : Thank you for the great video - I am following your example but I am stuck @ 8:30 , I don't see anything start with "Category" on Dynamic content to select. Can you guess what could be the reason.
@RezaDorrani2 жыл бұрын
I cannot guess the reason. I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@davidlopez6385 Жыл бұрын
I have the same issue, did you solve it by any chance?
@vinayayinapurapu3 ай бұрын
great video Reza. Is there an option to remind the approver after is being delegated from one person to another?
@RezaDorrani3 ай бұрын
The only option would be to query dataverse tables to get all that info.
@vinayayinapurapu3 ай бұрын
@@RezaDorrani thank you. Do we have a video on that ? Sorry becoming greedy :)
@RezaDorrani3 ай бұрын
I do not :) Check on the forums in case someone has done something similar powerusers.microsoft.com/
@Dist5143 жыл бұрын
Hi Reza.. thank you for this wonderful series on approvals.. am just stuck on how to add emoji while updating comments back to list 😒😒
@RezaDorrani3 жыл бұрын
Just copy and paste emojis from the web
@subhmajumdar3 жыл бұрын
Thanks a lot Reza for such a nice video.Could you let us know what would be the best approach for approval if we need to create purchase order requests in Bulk? Like, all purchase order details are in a file and all purchase orders listed in a file should go for approval one by one.
@RezaDorrani3 жыл бұрын
All purchase orders in a file? A file is a single entity. Im thinking you need more of a document set functionality, where multiple files are loaded into a single doc set. You can run approvals on doc sets as well. I can add this to my backlog of video requests. However, I would recommend you check on the forums at powerusers.microsoft.com to see if someone has done something similar.
@danpaolocastillo3 жыл бұрын
Great tutorial! Thank you for this. I just have some questions regarding a scenario where there were multiple departments that needs to address the ticket and needs approval of each department. How is that possible?
@RezaDorrani3 жыл бұрын
Check my playlist on approvals. I have a lot of approval patterns covered. kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
@izzulhakim97602 жыл бұрын
Hi Reza. I have a question. On 6mins 41s of your video, how did you add multiple names under the Approvers column? I have been trying to add under this column using “person or group” type and it could only allow me to add 1 name. Would really appreciate your help 🙏🏻 You’ve helped me alot for the rest of your vid’s man.
@RezaDorrani2 жыл бұрын
The person type column has a setting to "Allow Multiple". You will need to enable that in SharePoint column settings.
@biliatto4 жыл бұрын
Amazing! As always! Thanks
@RezaDorrani4 жыл бұрын
Thank You
@boiteaspams46033 жыл бұрын
Thanks a lot. Is there anyway to reassign the approbation if the person receving is not the appropriate one ? I've seen a "Follow up" Button. but it does nothing. Do you know its purpose ?
@RezaDorrani3 жыл бұрын
Currently, I don't believe there is a direct way. I did notice follow up as well. Something to investigate on :)
@boiteaspams46033 жыл бұрын
@@RezaDorrani Sad because it's possible withapprobation list in Power Automate. I also found no trigger and nothing with Ms Graph. Client will be disapointed :(
@RezaDorrani3 жыл бұрын
@@boiteaspams4603 May be a limitation. I will recommend you check on the forums at powerusers.microsoft.com/
@aarongarcia66732 жыл бұрын
Is there a way to do an Approval flow where the person who creates the item can select the approves who need to review. We have a scenario where a user has to submit a User Access Request (UAR). The UAR needs to be approved by his/her/their supervisor and possibly their Unit Chief and possibly up to 1 or more additional Unit Chiefs. Some users need to get access to a different unit's laboratory space and that required separate approvals for each. We are looking for a way to automate this process and NOT have to get wet signatures on a form. The issue I am having with the process you show here is sometimes there are alternate people who ACT as Unit Chiefs, temporarily but only for a week or two and I don't want to have to constantly update names in the list. Is there a way using Power Automate to allow the user to edit the flow in process and SELCT the name of the approver. .This was possible in SharePoint 2010 and 2013 Approval flows.
@RezaDorrani2 жыл бұрын
I have done many videos on approvals covering a lot of scenarios - user selects approvers, dynamic approval patterns and more. Check kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
@vimbaimatanda39122 жыл бұрын
Great tutorial!I have a question, why does the assigned to column in the sharepoint list stay blank?
@RezaDorrani2 жыл бұрын
It does not stay blank. I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@aflyudr063 жыл бұрын
Amazing video thank you. What about creating this flow for a document library? AUtomate asks to select a List (*), but what if I want to set it up for the library and not the list?
@RezaDorrani3 жыл бұрын
There are actions in flow related to files like "when a file is created in a folder". I have a playlist on approvals that has scenarios with document libraries as well - kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
@m.k.t.7971 Жыл бұрын
Hi, Reza! This is a great video. The approval process demonstrated in the video is exactly what I’m look for! I followed all your steps to create a glow but having an error in testing. The ‘Start and wait for an approval’ step has an error message: BadRequest. The request failed. Error code: ‘InvalidApprpvalCreateRequestAssignedToMissing’. Error Message: ‘Required field ‘assignedTo’ is missing or empty’. Could you please help figure out this problem? Thank you so much!
@RezaDorrani Жыл бұрын
Message states that you are not providing a value for assigned to. I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@m.k.t.7971 Жыл бұрын
Thank you so much for your timely response! My flow starts from a Form with attachments and multiple-answer questions. I followed your other videos to create a flow to save the form results to my SharePoint list. Then I followed this video to create another flow to achieve a two layers approval process. The multiple answer question from my list is for category names. Each category has different approved name and approval email text. I store the category approval information in another list. And followed this video to run the approvals. In Filter Query of the ‘Get items’ step, there’s no ‘category value’ dynamic content for me to pick. So, I pick the ‘category’ dynamic content that was generated from the multiple answer question of the form. I guess this is possible reason for my fail. Hope you could help me out my scenario. How to deal with the dynamic approvals from a multiple conditions? Many thanks!
@RezaDorrani Жыл бұрын
@@m.k.t.7971 I have done over 18 approval videos. They are in my approvals cookbook playlist. You can check those to see if they can help frame your scenario. If not, then I would recommend posting your query on forums.
@m.k.t.7971 Жыл бұрын
Thank you, Reza! Your videos are great! I’ll check all of them to see if my issues could be fixed. Your shared forum is also a good resource. Thanks again!
@nbercasio3 жыл бұрын
Great video! Very clear explanation! Question for you, what if all the approvers must approve the item?
@RezaDorrani3 жыл бұрын
Change the approval type to everyone must approve. I have covered the approval types in detail here - kzbin.info/www/bejne/aovRemOVltmMi9E
@LKalldays2 жыл бұрын
Great video! You mention that Approvers (multi-person) vs Approvers Text is easier to maintain but you reference 'Approvers Text' in the Flow. Why? I ask because I get a 'GraphLookUpRequestFailedError' in my Start and wait for approval when I attempt to reference the Approvers (multi-person) column instead.
@RezaDorrani2 жыл бұрын
Writing user emails in a text field - there is a chance of a mistake. I used that technique because its easy to demo. I have done 18 approval videos - in playlist on my channel. I have shown how to use multi select person type columns as well.
@prokshitangadi3 жыл бұрын
Hi Reza, I have a question for you. Is there a way to retrieve a people picker column value after it was entered by a pre-approval person. So the login I have in mind is like this - Request is created in the Microsoft list > A Pre-Approver (Always remains the same) will receive an email, after his/her review they go into the list and assign it to his team members by picking from the people picker column inside the same list > The Pre-Approver Approves the request > Then the flow retrieves the people picker person's email address and send it for his approval> and so and so forth. No second list used in this process. How would the flow look like? do I need to the get items card and filter query ? Sorry if its too long of a request. Thank you for reading.
@RezaDorrani3 жыл бұрын
You would need to get the approver info from the same list item from which the flow is being triggered. You can get it from trigger action itself or filter query to get the info. I would have to recreate your scenario or look at your flow in action to provide any guidance related to the steps needed. I would recommend you give it a try and in case of issues post it with screenshots on the forums at powerusers.microsoft.com
@shawkeme2 жыл бұрын
thank you for your effort , what if I need to select more than one category (multi-select )
@RezaDorrani2 жыл бұрын
I do not have a video reference on multi select category scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@sheryeelok57863 жыл бұрын
Hi Reza, Thank you so much for the great video!! However, im not sure why when the 2nd approver responded, it doesnt reflect the name of both approver on the sharepoint list. When the first approval approves, it will reflect nicely onto sharepoint list. But when the 2nd approver approves, it becomes "Approved By: Approve" Please kindly advice. Thank you!!
@RezaDorrani3 жыл бұрын
Possibly because your flow must not be setting these values correctly. I would have to look at your flow to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@MrVikrant19872 жыл бұрын
Hi Sheryee, did you got the answer for this, i am facing same issue. Please reply.
@gregoryreddin12223 жыл бұрын
Hi Reza, this question might be a little out of scope of this particular tutorial but could you explain how you removed the Approval Status and Approval Comments columns from the modern forms? Did you simply edit the columns and remove them entirely or did you use conditional formatting to hide these? Currently these fields are displaying on my forms and do not want the users to be able to edit these directly. I would prefer to still display these fields as readonly on the forms without explicitly hiding them. It would be nice to see the Approval Comments when viewing the item directly in addition to the view column.
@RezaDorrani3 жыл бұрын
I set those columns as hidden. Form formatting currently does not allow to set columns as read only inside form. You would have to use Power Apps for that.
@jasminekallicharan75162 жыл бұрын
Thanks for this helpful video! how would one go about grabbing the approvers from the department list if they selected multiple departments? I have a form with multiple-choice options for affected departments and was wondering if it's a way to query the department list for multiple selections.
@RezaDorrani2 жыл бұрын
Thanks. I do not have a video reference on this scenario and would have to try it out to provide guidance. Idea would be to loop through the multi select list in an apply to each loop and query department list and load all that information into a variable. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@jasminekallicharan75162 жыл бұрын
@@RezaDorrani Thank you!
@bisolaadeyemi908711 ай бұрын
Hi Reza, Thank you for this video. This scenario shows only one approval (first to respond). In the department share point list, how do I put in 2 or 3 email addresses. The first approval needs to be approved before it moves to the second approval and then the third.
@RezaDorrani11 ай бұрын
Welcome! I have done approval videos covering various scenarios. I will recommend checking my playlist on Approvals.
@TheRamiroB4 жыл бұрын
BRAVO!!! really good video. one question. If you need to assign an approval action to SH security group . you can read using SH API all the user and get an emails? is there another simple way?
@RezaDorrani4 жыл бұрын
You would have to query the SharePoint RESP API. I have a video coming which will show how to do so. So stay tuned :)
@RezaDorrani4 жыл бұрын
Currently, using rest api is the only simple way.
@ronitsuri22603 жыл бұрын
very well explained - thank you Reza
@RezaDorrani3 жыл бұрын
Thank you Ronit
@matuslacko14554 жыл бұрын
Hi Reza, i like the last part on "select" is there a way how to get the UPN from a people picker... keep in mind that not all users have emails
@RezaDorrani4 жыл бұрын
Great point. SharePoint people picker column returns email and claims token as well. You may have to play with the claims token to get your value.
@raulacosta4843 жыл бұрын
Amazing video Reza, I do have one question, I followed all your steps, however, the approvers are not able to open the pdf attachment, any tips for that?
@RezaDorrani3 жыл бұрын
I do not send any attachment as part of my video but that can easily be done. My guess is the attachment data that you are passing is not in the correct format. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@madhurishirsat93033 жыл бұрын
Thank you! This is more closer to my requirement..Just guide me on how to allow approver to add data in that form(edit access for few extra fields) currently it is only view access..when he got link of form by email along with approve & reject button..
@RezaDorrani3 жыл бұрын
I have a video I am working on which allows approvers to have their own forms. Video will be out next week on my channel.
@madhurishirsat93033 жыл бұрын
@@RezaDorrani Thank you so much Reza..Will be waiting for that video!
@madhurishirsat93033 жыл бұрын
Hi..can you share the logic...when video will be out... really stucked...
@RezaDorrani3 жыл бұрын
@@madhurishirsat9303 Video will be out tomorrow. Not possible to post the video logic in chat here :)
@madhurishirsat93033 жыл бұрын
@@RezaDorrani Right :D
@josemag46174 жыл бұрын
Thank you, definitely your videos save a lot of time! I am working on my version of these ideas and have a doubt: In a two parallel approval process flow in TEAMS, if one branch reject the document, left some comments or suggestions in the document assessed. Once rejected, I would like to edit the document that triggered the flow when it was moved into Files tab in TEAMS. When edition is completed in TEAMS, how can I restart the approval flow but only with the person/branch, that initially rejected it? Thank you for your ideas! Greetings from Argentina!
@RezaDorrani4 жыл бұрын
Hi Jose, to restart flow there would have to be either some user action. Etiher doc updated or user triggers flow manually. In flow, in order to only go through approval for the failed process, you would have to maintain some status and check status and accordingly assign the approval actions. Flow trigger conditions would also be key in such scenarios to ensure the flow is only triggered as and when needed. kzbin.info/aero/PLTyFh-qDKAiGFDykUngHNNstTABnc-tLv
@naveench31944 жыл бұрын
It is really a nice video👍...I hope you will help me in addressing the issue : how to manually initiate 'item creation' flow in this tutorial scenario if flow trigger fails due to server load or any other reasons(low plan subscription)
@RezaDorrani4 жыл бұрын
The flow trigger is "When an Item is created" - You can change it with "For a selected item" - Users would then have to manually start the flow.
@akkaradechsrithongchai77663 жыл бұрын
Very good explanation. thank you so much.
@RezaDorrani3 жыл бұрын
👍
@micheall0012 жыл бұрын
Hi Raza, Thanks for the video, Do you have any video with same scenario but for serial approvals flow ?
@RezaDorrani2 жыл бұрын
Check kzbin.info/www/bejne/nZPCd4ibh8-anZY You would need to mix the concepts of both the videos.
@sheeferzyed8957 Жыл бұрын
Hi Reza, Really Great tutorial. Thanks. is it possible to update item (approver comments, assigned to .etc ) without changing version of a document in Dynamic sequential document approval process in SharePoint library.
@RezaDorrani Жыл бұрын
When you update columns of a doc library, it does create a new version.
@sheeferzyed8957 Жыл бұрын
@@RezaDorrani thanks Reza for your prompt replay. is it possible to update coulmns using "send to http Request to sharepoint library" ! without changing version history..!! could you share a video link for "send to http request" if you have. I would like to create a coulmn to view running status of a document approval process (eg . "Aassigned to" - approver name for each level of dynamic sequential workflow) .
@RezaDorrani Жыл бұрын
Probably but not something I have tried. Il recommend posting your query on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@elisecrooks89973 жыл бұрын
I've watched this video soo many times now! Thank you for your awesome work. I have created an approval flow that is based on the teachings in this video. However, I have 2 differences. 1. I have multiple approvers and 2. While the approval is running, I would like to log, each approval response as they come in. I am not able to find a video that covers this scenario. Can you help?
@RezaDorrani3 жыл бұрын
Thank you for watching many of videos many times. I may have covered this in one of my approval videos. Check my playlist - kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe If not in my playlist, then I would recommend you check on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@elisecrooks89973 жыл бұрын
@@RezaDorrani can you recall which of your videos cover this?
@RezaDorrani3 жыл бұрын
@@elisecrooks8997 I do not. Done so many on approvals to be honest. I may have done it.
@chieunguyen9351 Жыл бұрын
Hi Reza, thank you so much for this video, what do I need to do if I want to the form to automatically send to the email that the user entered in the list for approval? (In my list, I setup a column for the user to input their manager's email). I appreciate your help.
@RezaDorrani Жыл бұрын
Simply put that email in assigned to of approval action if they need to be part of approval process. I have a full playlist on approvals which covers a lot of different scenarios. You can take a look.
@sanadsulaiman82824 жыл бұрын
Amazing video as always :) Is there any tutorial for creating the Sharepoint list as you have created, as I am new to the Sharepoint ?
@RezaDorrani4 жыл бұрын
All my demos are based on Microsoft List templates - resources.techcommunity.microsoft.com/microsoft-lists/
@Nadege78954 жыл бұрын
I have been searching for such a video for several months ! Thank you so much. My flow is a little bit different. My trigger is a manual and I'd like everyone to approve. I'd also like to keep trace of all approvals and comments. Is that possible? Does one of your flow explain that point? Thanks in advance for you help and thank you so much for all your explanations..
@RezaDorrani4 жыл бұрын
You are most welcome. For your request - Can be done by parsing through the approval response. I do not have a specific video on that but if you go through all the videos in the approval series, you will be in a position to build one - kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe I do plan a few more videos in future for this series, I will add this request to the backlog.
@Nadege78954 жыл бұрын
@@RezaDorrani thank you so much for your answer. I'm going to have a look at most of your videos ;-)
@stefanobeninati85604 жыл бұрын
Thanks Reza very useful video! Can you share how to show in the same Approvers column both the user profile picture and the name? Thx
@RezaDorrani4 жыл бұрын
You mean in SharePoint? - You can use column formatting to show the approver names and their pictures - github.com/pnp/sp-dev-list-formatting/tree/master/column-samples/multi-person-facepile
@amreiss3 жыл бұрын
Hello, at 21:42 in the video when I put in approvers email it creates another for loop. I have replicated what you did exactly.. When you select Approvers Email it doesn't force you into another for loop?
@RezaDorrani3 жыл бұрын
This looks like a schema change in flow if its causing the double loop. I will check this out and let you know. Please send me an email at reza.dorrani@outlook.com. Your email would be my reminder :)
@learnalittleeveryday78483 жыл бұрын
Exactly the same issue
@RezaDorrani3 жыл бұрын
Fix is to use item()?[‘Email’] expression inside the for loop.
@RezaDorrani3 жыл бұрын
@@learnalittleeveryday7848 Fix is to use item()?[‘Email’] expression inside the for loop.
@learnalittleeveryday78483 жыл бұрын
Reza, Thank you for taking the time to reply and for all of your excellent videos and work. I found the answer in the comments eventually. The logic kinda makes sense. My guess was so close. I think you have seen a few people have the issue so maybe a slight update or pinned reply. Thanks again
@barunroyghatak43802 жыл бұрын
Nice video Reza. Thanks 😊
@RezaDorrani2 жыл бұрын
Most welcome
@Kukdai3 жыл бұрын
Reza instead of sending all tasks to everyone at a time, how do we send a task to the first person in the approval and if he approves then the second and so as to the last in the approval column. Then I will update the outcome and decide if the workflow should continue or not.
@RezaDorrani3 жыл бұрын
I have done several videos including various approval patterns. Check my approval playlist kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
@olegguriev8922 жыл бұрын
Hi Reza. I was trying to add dynamic approvers to document approval process using process from your other video "Power Automate Document Approval workflow for SharePoint". I'm referring to 22:00 of this video. When I select Select feature and put Approvers into From field it creates a loop, just as in your vide. But, when then I put Approvers email into Map field it creates another sub loop for some reason. Any ideas why this can happen?
@RezaDorrani2 жыл бұрын
Probably because it is an array of approvers. I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@besttrue103 жыл бұрын
Dear Reza, I have built my process exactly as yours, except that I had to put between [ ] brackets to solve the error 'is of type 'Object'. The result must be a valid array.' The variable can find the 3 approvers I have in a list, but the approval is only sent to one of them. And it is sent always for the approver I inserted later in the list. What am I doing wrong? Thanks for your attention, you are the best teacher.
@RezaDorrani3 жыл бұрын
You should not have to put the []. I will have to look at your flow in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@teresaagustin51914 жыл бұрын
Reza, thank you so much for making this helpful video. It is perfect for what I need right now. I really like the Approval Comments audit trail. I'm curious about the Approval Comments column settings. Are these the settings you used? multi-line, append changes to existing text on, enhanced rich text to support the emojis.
@RezaDorrani4 жыл бұрын
Great to hear such feedback. The Approval comments column is a simple multi line text column (no append changes, no enhanced rich text). Simple multi line text column supports emojis.
@teresaagustin51914 жыл бұрын
@@RezaDorrani Thank you for providing this clarification Reza. I'm already capturing the necessary email address in my SharePoint list when a user submits a new request via the Power App so I'm hopeful this solution is going to work out well. I didn't know about the emojis and I see some other people are asking as well so I will add that I googled it and saw that you can access them by clicking the Windows icon on your keyboard and then period. Have a great day and please keep all of these wonderful videos coming. You are a great teacher 😊
@RezaDorrani4 жыл бұрын
@@teresaagustin5191 Thank you Teresa and good luck with your approval scenario.
@Ganeshaithandal3 жыл бұрын
Thanks for the response, I have one more question. Can we freeze the first few columns in the Share point list, it helps full if we have so many fields. Can we make it work if we add List to MS Teams ?
@RezaDorrani3 жыл бұрын
Freeze columns is an item on the SharePoint roadmap. I don't think you can currently freeze multiple columns. If it works in SP lists, then it will work in MS Teams as well since it is the same list behavior.
@deirdredornan20253 жыл бұрын
Hi Reza.. Great video !! Im having an issue with the approvers. My flow shows it is picking the email address for the first approver twice but then actually sends the approval to the 2nd person. Wish I could share a pic of my flow output as its so strange. I have 2 apply to each steps that PowerAutomate has automatically created the 2nd one which I cant get rid of. Could this be causing my issue ? If so how can I get rid of the 2nd apply to each ? Thanks
@RezaDorrani3 жыл бұрын
I would have see your flow :) I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com
@shaunthornton61303 жыл бұрын
I was having the same problem; a second nested Apply to each - While I didn't figure out why I was getting the second loop, I realized the reason it was only sending to the second approver. The set variable command inside the second loop was overwriting the first approver, so I changed "Set variable" to "Append to string variable" so it would add the approvers to the string during each iteration. Probably not the most elegant solution but it works now! \o/
@karom77083 жыл бұрын
Thanks, Very professional.
@RezaDorrani3 жыл бұрын
Thanks for watching!
@schonerstefan43958 ай бұрын
Hi Reza , Amazing content as always. I am using your flow as a reference for my scenario however mine is different because i have 3 answers so i am using custom responses -wait for all responses , my issue and i have not figure it out , when the email is sent based on my condition which is set like yours i get the same answer for my response twice and send two e-mails if i have two approvers for example, can that be modified to get only one answer/one email?
@RezaDorrani8 ай бұрын
I am not sure why it would send two in your scenario. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@schonerstefan43958 ай бұрын
@@RezaDorrani Thank you for your reply , i did posted :)
@toqeerh10586 ай бұрын
Hi Reza, @18:09, I am unable to see the link to a video which shows how to add approvers dynamically from SharePoint group - are you able to help please?
Hi @Reza Dorrani , i have a question ?? when you select more than one department !! ( EXP : marketing + security ) , have we to change the flow ?
@RezaDorrani2 жыл бұрын
In my demo, department is single select (from what I remember). So I cannot select multi. If you make it multi select, you will get for loops in flow. You would need to them get information from loops, by setting variables, using expressions like join etc. I do not have a video reference on this scenario and would have to try it out to provide exact steps. I would recommend posting your query on the forums at powerusers.microsoft.com
@yassinechmangui40542 жыл бұрын
@@RezaDorrani thank you
@km-rk6md Жыл бұрын
Hi, Rena! I have a question regarding the dynamic approves. How to get the approves emails from the Department approver list when a user picked multiple departments, especially more than five departments are selected ? The ‘Filter Query’ only has ‘Equal’ and ‘Start with’ foyers, it doesn’t have a ‘Contain’ filter. Thank you in advance!
@RezaDorrani Жыл бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@harshadsekuboyina61522 жыл бұрын
This is Awsome and great learning, please let me know where I have to begin with for mastering power Automation
@RezaDorrani2 жыл бұрын
Im not aware of any master power automate course. Currently, all I have is my videos and they are all grouped into playlists.
@morygold4 жыл бұрын
Great Tutorial, how did you add the emoji !!
@RezaDorrani4 жыл бұрын
Just copy pasted it from the web.
@mron41613 жыл бұрын
Reza, Fantastic Video. This video helped me create the structure for my Flow. One big difference in my flow, is that I have an Approvers Column (Renamed from your Category Column) and in my Start and Wait for an approval action, I use "Approve/Reject - Everyone must approve" because in my organization, all people from the associated list must approve, instead of just one. - SO, here is my question. I noticed that after everyone approves (such as Me (Micah) and Trinita), the Approval Comments field will show the Green checkmark and say Approved by Micah, if I was the last approver, or Approved by Trinita, if she was the last person to approve the request. How would I get this field to show when BOTH people have approved? - OR is there a way to create a new Column instead that shows who has approved and who we are waiting on. Example - John submits new request, and selects my KM Category, which has 3 people in it, Micah, Trinita, and Bob. If Micah approves the document, but we are waiting on Trinita and Bob still, I would like my list to show this somehow. ANYHOW. That is my true goes, so the person who submits this document can come to the list to see who we are waiting on.
@RezaDorrani3 жыл бұрын
You would have to query Dataverse to get that information since all approval info is stored in Dataverse. At end of my approval reminder video, I show how to do check which approvers have not responded kzbin.info/www/bejne/kKbTgmN3l6mfZqs.
@lorindahall Жыл бұрын
Hi Reza, very informative once again! I am trying to achieve something slightly differently. I currently have document library set up with a people metadata column which I've named "Approver". The idea is the person uploading a document can select who will approve it (single person approval). My approval flow uses this column to decide who to send the approval request to. This is all working well. My problem is that the people column allows selection of anyone in the company. In reality I want to limit the selection to a small group of approvers in our department. I don't want the approval notification to be sent to all of them (this would be annoying). Can a people column be customised/filtered to only show members of a certain permissions group (i.e. "approvers") or will I need to create a lookup column and create a SharePoint List of our department approvers? Or is there a better solution?
@RezaDorrani Жыл бұрын
I believe person column type properties in SharePoint has option to limit selection to security groups.
@lorindahall Жыл бұрын
@@RezaDorrani thanks. Found the option :)
@farispeeds4 жыл бұрын
Hi Reza, i follow ovreall the step but when try the flow error always occur on the get items parts, as I mention the category as "gate 1", the eror mention "The expression "Title eq "Gate1" is not valid. Creating query failed." Has checked the on the list as well it exactly same name ("Gate1) both on the approval list and the form list, any idea why? Great video afterall!
@RezaDorrani4 жыл бұрын
Title eq 'Gate 1' - ensure Gate 1 is in single quotes. There should be no usage of double quotes.
@depthcharge30033 жыл бұрын
Thanks, Reza. I'm having an issue with the select operation when getting the email from the array. It's outputting null even though the input information looks correct. The flow runs without error but doesn't finish down the pipe due to the missing email I'm trying to retrieve.
@RezaDorrani3 жыл бұрын
I will have to look at your flow in action to provide guidance. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com