Reza, the Approval timeline (this blew my mind), assigned to with deep link with Teams and time duration, Ticks ‘trick’ was a great tip, and usages of column formatting are exceptional. You covered an end-to-end solution here… You are amazing! 😊 ...as always!
Whenever I'm starting a new project at work I always check Reza's channel for things just like this. Even if you don't use this exact scenario you can apply the ideas to many other scenarios successfully.
What a new great video ! Everything seems to be easy with you ! Thank you so much. We find with you each time something more than in others channels and each time you are able to propose a global solution with everything that we need at office for our end users. Great jobs as always, I've done a lot of progress since I watch your video. Thank you so much from Paris and I'm sure that a lot of your subscribers have this same feeling
This is awesome. in fact , i have utilized this in one of my approval workflows, making it more dynamic. i utilized Apply to Each to trigger approvals based on Transaction Value, which could be 2 / 3 / 4 / 5 level of approvers based on the transaction value. i captured the approval history at each stage and showed them using the Emoji Formatting Technique, you shared. Thanks a ton for creating this.
Hi Reza! I would really appreciate your help, at 15:20 I see that the "Responded at:" has an expression that I do not know. Currently my "Responded at:" has an dynamic content of the Responses Response Date but it shoots it out the sharepoint in a yucky format such as 2024-01-04T03:15:44Z. What did you write in the expression to concat the response response date to be in the easier format of M/dd/yyyy H:mm ? Thank you!
Hi, This video was done a while ago and I do not remember the specifics. Please check video description and see if there is any link to download sample.
Reza, in the "Add to comments array" step (15:15), I'm getting an error when running the flow: The variable 'varApprovalComments' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'varApprovalComments' only supports values of types 'Array'. What did I miss?
I am looking for the JSON that shows USER PICTURE AND NAME, please. It is in minute 3:22> I tried many diff places but I could not find it. Please help.
Hi Reza, great content. Thanks for sharing the knowledge. Is there a video on adding a checkbox for the approvers when they go through the approval process to ensure they have read and understood the details of the approved items? I need to see how a check box and some text can be included in that workflow.
I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Am I the only one not able to make the "ticks" expression shown in the video @ 10:55 not work? I get an error that says, "The expression is invalid" ['requestDate'])),100),1000000000),60)
mr.Reza wanna ask something, in this case ( start and wait approval everyone must approved ) if the approver one rejected it. how to make it automatically change the status to reject ? ( not waiting for approvars 2 for respon )
@@RezaDorrani how about in this condition mr.reza 1. if approval 1 rejected, so the item will go to reject 2.if approval 1 approve, and then we need for approval 2 for approve. if approval 2 approve so the item will be approved otherwise if approval 2 rejected so the item will go to rejected
Great video Reza. 2 Things: 1) The JSON Approval History popup shows HTML tags. How do I fix that? If I change the column to plain text I lose the line-item carriage returns. 2) The JSON Approval History popup loses the background color when scrolling. Thanks.
Love this!!! Now that I have this complete. Do you have or can you suggest a video/demo for how to create a progress indicator dashboard in PowerApps for it.
Hi Raza, Exactly at 9:53 time in this video when you select responses approver and it's applied once, what we should choose when we have multiple approvers, in my case I have VarApprover. 2nd Thing what will be the expression for Time Taken, the one you mentioned its doest work Please reply it's urgent, Thank you!
Video description has link to download sample flow. You can check all the code in it. I have not come across the issue you are mentioning, hence I am not sure on what the fix is. Best to post your issue with screenshots on the forums at powerusers.microsoft.com
hey @reza dorrani, first of all your videos are an unbelievable resource and thank you so much for sharing them with us. However my approval timeline formatting is showing anything with a "New" Approval Status as a green on the far left. Any idea what could be preventing it from turning blue in the code? If i use the code provided on your github site, all the approved and new status appear as blue where I would expect them to be on the timeline.
Most welcome! I have not come across any issues with this so not sure. My only guess is you have probably not added all the columns needed for JSON formatting in the view
Hi, with the JSON for the approval timeline, i can get the colours and positions correct but the details of the timeline are not showing when you click on the dot. Only when 'New' are showing as 'No History Available'. I cannot see any other column names I need to update in the JSON - any ideas?
I have not come across this issue hence not sure what the reason is. Video description has link to download sample flow and json code. Important for all columns leveraged in json to be a part of the view.
Hi @Reza Thanks for sharing such an insightful video. I have a query : You created "Approval Timeline" column as "Multiple lines of text field" but in my case when I create the column as "multiline text field" it is showing a hyperlink named "View Entries" by default as per MS feature and only If I click on it, I am able to see the Approval History comments which I have appended through Power Automate Flow. Could you please guide me how can I rid of this hyperlink "View Entries" and directly show the comments on my main SharePoint List view page instead.
@@RezaDorrani Thanks for your prompt response. Yes I have used Append feature while defining the column. But what did you mean by : “Version enabled scenario” ?
Hello, Ask where is the code for the Ultimata power in the Time Taken approval chronology part: this does not work for me div(sub(ticks(formatDateTime(utcNow(),'yyyy-MM-dd')),ticks(item()?['requestDate'])),100),1000000000),60) Thank you
Did you download the flow from the video description? requestDate must be the exact internal name of your column - case sensitive Column type must be date in SP.
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
Hello, thanks for this great video. I have a question. What if the approvers are different people. With dynamic content. For example the manager of the requestor is one of the approvers.
Hello Reza, very amazing video 👏👏👏. I failed at fill "Assigned To" column in "update the item of SharePoint" action. Could you please give me some hints ! I have initialized Array Variable named "varApproversPersonArray" same as your demo, then append the Approver Person Name(from Get Departments action) into this array via apply to each. When I put this array variable(varApproversPersonArray) into column "Assigned To" of update item of SharePoint, the action " update item of SharePoint" keeps running and can't stop during test. I have check the structure of "Assigned To" column from SharePoint, it is defined as person or group type with multi-selection. I don't know where is the trouble of my flow or SharePoint list? If possible, could you share your "Approvers", "Approvers Array", "Approvers Person Array" initialization and assignment operation with me. TKS
Thanks for liking the video. I have provided a lot of reference links in video description. As for your issue, I will have to look at your flow in action to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hello Reze, many thanks for your reply, the trouble has been resolved. I need to give name property "Claim" for the varApproversArray, then it will be allowed add into SharePoint list. Now, I have suffered a new trouble. I have not got the adaptive card same as your demo from my teams connector. The OperationId is "PostUserAdaptiveCard", what is the user的name in teams connector?
You always provide such perfectly explained videos, detailing the processes that have been instrumental in helping me build my flows. It's nothing be superb! Do you have a similar video for sequential approvals that you could point me to?
This approval is awesome. I do have one question - is there a way to format the email output form the approvers response array so that it matches they way it looks in the SharePoint list?
Possible. It will require a lot more work to get to it. You would need to the the Rich Text feature of multi lines text column in SharePoint and then accordingly plug in the HTML for creating the user format.
Thank you Reza! - I have a question please - I cannot find the expression formula you are referring to - to copy from your link - that will show the "Time Taken" by using that tick command. I looked at the link but it does not seem to have hte specific string to copy for this specific video. Can you help point me to that line? Thanks
@@RezaDorrani Thank you for the reply! I did try that but for some reason when try to import the package, the button to actually import is greyed out - not sure why. I will give that another try. Thanks again! :)
@@troybrown5138 Button will become active once you have all the connectors related to flow configured. It will be at bottom of flow import page once you upload zip file.
While doing the timeline. Am unable to view the text when clicking on the timeline. Tax is stored in approval history column. Any idea how I can get the text to show on the timeline
Video description has link to download JSON and flow. Give that a try. Important to ensure the view in SharePoint has the columns which are being used in JSON formatting m.
Hi Reza, nice video! I am having a little issue where my minutes (Approval Pending Since) are not coming in correct format after adding the json, thank you
Video description has the code base link. I will have to look at your json, sharepoint setup and flow in action to know the cause of your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you for taking your time and answering my question, sure thing, I will post my screen shots and code at the above listed site, thank you👍
Hi Reza - Thank you for a great video. I have a question, is it possible to have power automate update the attached word document with the approver names and date of approval once the approval flow is complete?
HI Reza, the approvalpendingtime.json file did not work for me i see a static blue dot and unable to see the popup that displays all the information, can you please help ?
You need to ensure all columns being referenced in json are part of video. Video description has link to all artifacts showcased in video. I have not run into this issue, so not sure what the exact reason would be.
I make videos when I receive multiple requests on a topic. Every quarter 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.
Hi Reza, from your video "Power Automate Multi Level Approval Workflow | Serial Approval | Multiple Approvers" where in this flow would I input the Add to comments array, join? I tried to place it after the condition if length is equal to VarCounter under the If yes branch but this seems to not work
Great work again Reza. Quick question, have you noticed Team action missing as of late. It looks like some Team actions have been merged together with additional options inside. Example of this is the action "Post your own adaptive card as the Flow bot to a user" no longer exists, you need to use "Post adaptive card in a chat or channel" and then choose as Flow bot > Post in Chat > then you can add recipients and an the adaptive card.
Video description has link to my GitHub repo. It includes the flow zip file which you can import. I have also included the link to my blog post on ticks function.
@@rebeccalooi275 All the expressions are inside the flow. Once you import the flow, you will get the expression. I do not have the flow anymore and hence do not have the expression handy.
I've used your video to perfect our approval flow. It worked great! Unfortunately, I've been tasked with changing the approvers list. I need the flow to be assigned to one user, and upon approval, it's sent to another user. I can't figure out how to change it without breaking the rest of the flow. Please help
I know this is a year too late, but hopefully someone will be able to answer this question. So in the example here, Reza is using a list where each item is one document it seems. In my scenario, my team submits packages for review. There may be 3 word docs and 2 pdf files in a package. Would this approval workflow work for folders that have multiple documents in them? In this case, I would want to treat a folder as an individual "item" so that team members can go into a folder, review, revise and send onwards to the next person in the chain.
I do not have a video reference on this scenario. Forums is the best place to post issues/queries. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you so much for your response Reza! I realized than an item can have links appended to it as attachments. I will see if this works instead of using folders. Thank you again for your dedication to providing high-class instruction to your viewers!!
Hi Reza, Thank you again for your videos, they've helped me so much. Do you have a specific video which goes through the the population of the 'assigned to.' column? I've got my dynamic approvers working but can't seem to get my flow to correctly populate the assigned to column with all approvers from the person picker from the approvers list. Regards
Your most welcome. Video description has link to download sample flow. May be that includes the dynamic approval logic. I also have a full playlist on my channel on approvals which has a wide variety of scenarios covered.
Hello Reza, I appreciate the time and the level of detail that you provide on your videos. I want to use this format but I would like to trigger the flow with Form submission including a picture attachment from the form. How can I accomplish that?
I have not experienced this issue hence not sure what the reason for your issue could be. Video description has link to download sample for formatting.
Reza love this and I have been trying to replicate . Can I ask what was the exact JSON you used for the column formats for Timeline and days approved For some reason mine isn't working.
Hey Hi, I need your help. I could not find Status Value when im create a update item(sharepoint) in power automate. i could not find a option like status value
Video description has link to download entire solution. As for your issue, I have not experienced the mentioned issue and hence not sure what the cause or fix for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, Hope you are doing well. I have a question, we have a document library with folders for each request and now it's more than 2000. and giving delegation warning while filtering the items and the attachments are not showing for each request. how to filter this without delegation warning from the document library. thank you.
Great! I just released another version of formatting with multi-step approvals. Let me know what you think of this as well - ruclips.net/video/gb_FUeRjgg4/видео.html
Reza, I am trying to recreate your flow (cutting and pasting where possible), and for step 8 (updating the item) I am using a SharePoint update item, I select the site address, list name, and then for the ID, it gives me the option to select from the "Get Items Department Task" or "When an item is created" - when I select either one of those it nests it in a new "Apply to each" function and adds "Select an output from the previous steps" where it adds "(Sharepoint)value - Am I doing something incorrect here?
May be :) I will have to look at your flow in action to provide any guidance. I would recommend to post your issue/query with screenshots on the forums at powerusers.microsoft.com.
Hi Reza, thank you very much for your videos and tutorials. They have been very useful in my project work. I have created the approval timeline in a document library and a SharePoint List using the JSON that you provided. Everything works fine in the list. However, I am unable to see the approval history when I click on the timeline in the document library. I cannot figure out what the problem is in the library. I have already modified the column names to match those in the JSON.
I will have to look at your JSON formatting in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Awesome video bro thank you really appreciate it. Just one question here, instead of "floor((Number(@now)-Number([$Created]))/(1000*60)) + ' min(s)'" how can i stop the time once the approval is done. I have a column named (Approved/Rejected Date) I tried to change the code but it not working.
HI Reza, thanks for the amazing work. I followed the entire video to build mine. How can I set users to recieve email notification when they make request from share point.
I am not following your approval pending since column. in your github it's saying single line text and in you video it's sayin date and time column. also in your JSON you used a column name 'CurrentApprovalStartDateandTime' i don't see the column in your video. can you explain how can i get the timer like your created, please
Github has the flow, SP column types and all you need. It's been a while since I did this video and not possible for me to remember each step. Give the github solution a try and in case of issues, I recommend posting issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thanks for the tips. Could I use this formating stuff on custom columns of a document library in sharepoint? or this only works on sharepoint lists?
Loved the video. Awesome. 🙏🙏👌Did something similar using spfx listview command set and column formatter. No Power Automate and was dynamic. I too "Stealed" from pnp samples.
@Reza, Could you please tell us if we have more than 3 status then how we can decide pointer position. Like New, In progress, Pending, Rejected, Approved, On hold etc.? Here we are using center, left alignment but ho we can achive this withou alignment.
In that case you would have to use some relative positioning. Check width of element, divide by number of status and accordingly apply margin. I have not tried this scenario though.
There is no direct (programmatic) way to cancel a flow run. You would need to query Dataverse for that and update System Tables which is not recommended.
Reza this PHENOMENAL content and it arrives at just the right moment. I have a question please. Approvals and Document Library: when approvals are submitted, if the file in document library is open, the flow fails - error400 file is locked for shared use. It has become a nightmare. Can you help suggest how to overcome this??
Thanks, For documents being opened and file locked, I have not run into those scenarios. I will recommend you check on the forums at powerusers.microsoft.com/
does anyone know why the following is an invalid expression "convertFromUtc(triggerBody()?['Created'], 'Arabian Standard Time', 'M/dd/yyyy h:mm tt')", Isn't that recommended built-in syntax after I press "/" and choose the Created option. I used Reza's syntax from the video and It's working now.
@@RezaDorrani nvm it resolved when I copied your syntax. I'm having trouble now finding the expressions used to calculate the time taken for the approval from the description! If you can direct me it would be great.
@@RezaDorrani I noticed that you recently are just sticking with power apps to automate approval workflows, why is that? is it more convenient? this is my first encounter with an automation of that sort for a PR approval process and I need to support functionalities like reassignment (or holding the pr for further clarifications and corrections) and visibility over who approved and who didn't and how much time it took. Any advice would be great!
@medonic There is not specific reason. I go based on user requests and what I feel like making at that moment. My advice would be to check or post your query on forums in case someone has done something similar community.powerplatform.com/
Hi Reza, I'd have some issues need your help: 1. Can you share me the if expression in "Append array to Approver comment". I used the expression to get the decision from each approver. 2. Approver comment when click the button in Approval timelines only seen for current ticket, the previous show blank window. Thanks.
Hi Reza, unfortunately the text „approval started by…“ doesnt show up in the grey box of my approval timeline, although I can see those if I click on settings of the item and check the meta data manually. so my grey text box consistently stays empty. only if the item is new, it shows „no history available“ - which is part of the json code. but after switchting the status - as I said - the box stays empty. any tipps to fix it?
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
Reza, thank you so much for the videos, they have helped me so much. I do have a question though. I have the cost of a quote in a column and it is only valid for a certain number of days and then it expires, so I would like to have a RAG colour code providing me with a visual indication of how many days were left until it expired based on when it was added and changing colours at certain periods when it counted down to so many days left, how would I do it?
@@Cartoonhotpot Search for Microsoft documentation on list formatting. Here are some samples on github github.com/pnp/List-Formatting/tree/master/column-samples
Hey Reza, I love the flow. But, when I test it, I keep getting hit will a "Null" error. My flow doesn't seem to like the "Null" in the Update item area. Can you help?
I have not run into this issue. May be add expressions to check if that value is null. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Amazing video! If I have multiple approvers and I want all of their responses, but want to live track who has responded so that I can know whose approval is pending - how can I do that. Later I want to check if all approvers approved or anybody rejected as well. Thank you in advance!
In case of everyone must approve or wait for all responses, the flow will not move ahead until the approval task is complete. To check who responded while the task is running, you would need to query Dataverse Tables for Approvals in a parallel branch. This will require premium licensing + admin access to the tables. I did a video on reminders wherein I query Dataverse to check to see which users have not yet responded - ruclips.net/video/ZupQ0AbDl0I/видео.html
@@RezaDorrani Do you think we could avoid the premium licensing if we did parallel branches for several single approvals, somehow collect a count of approvals and if all approved update item as approved? Each separate approval could just update the timeline. Would that work?
@@fleurwilliamson5920 Yes you could do that. But then your approvers would need to be more or less static since you have those many parallel branches pre-created.
Hi Reza, amazing video really easy to follow. I need help though. I've managed to get the Approval timeline to appear correctly, however when I click on the timeline it shows the grey box with "=if(Approvalstatus]!='New',[$Approvalcomments],'No History Available'. The choices and Approval status column match the ones in the video. The only thing I cannot find in your video is [$Approvalcomments] which I did not create due to it not being in the steps. Where can I link approval comments into the list?
Hi Reza, hope you could help with this: Howcan I update mi sharepoint list item status as cancelled when an approval is canceled from Power Automate/Action Items/Approvals
I'm not sure if there is an action to catch canceled approvals. When approval is canceled, if flow does move ahead, I'm sure it would give some sought of JSON output. You would need to catch that and accordingly update list item status.
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
how about in this condition mr.reza 1. if approval 1 rejected, so the item will go to reject 2.if approval 1 approve, and then we need for approval 2 for approve. if approval 2 approve so the item will be approved otherwise if approval 2 rejected so the item will go to rejected
@@RezaDorrani The solution file is invalid. The compressed file must contain the following files at its root: solution.xml, customizations.xml, and [Content_Types].xml. Customization files exported from previous versions of Microsoft Dynamics 365 are not supported. This is the error message I am getting
@@RezaDorrani thank you, the link you provided definitely helped. For the video you put a link to (for a selected item) how would the flow work if we put 3,4 approvers? Would they all get the email for approval and what would happen to the Sharepoint list? How would that be updated? Thanks!
@@andjelamihajlovic5614 That is upto you to decide. You could send the approval actions serially, or everyone must approve etc. only you read the responses, you can take the action on the list item.
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
We are sending the email to the distribution list but we are not able to log the approver name from the distribution list while we are able to log the approver name if the email goes to the individual. Kindly confirm how can we capture the approver name from the distribution list(DL)?
This is an amazing e2e tutorial Reza! I am so glad i stumbled upon your channel. Thank you for sharing this to newbies like me :) I have a question though, what if i want to run a report to export the data from this list to an Excel, will i be able to get the whole Approval History log as one column in the same row, as how it is in the Sharepoint list?
Hello Reza, the item link in "start and wait for approval" works fine if the assigned to was my email, however all other users are receiving this error "Sorry something went worng, no item exists...". what am i missing here?
@@RezaDorrani Thank you for your prompt reply. When i customised my sharepoint list in powerapps the links stopped working. If i copy the same list without customisation, the links would work... i'll keep trying.
Thanks! I have not done a video on that so not sure. I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
Where is the "Jaw Drop" emoticon 😲. Thanks for sharing Reza. 👍👍👍👍
😁
Reza, the Approval timeline (this blew my mind), assigned to with deep link with Teams and time duration, Ticks ‘trick’ was a great tip, and usages of column formatting are exceptional. You covered an end-to-end solution here… You are amazing! 😊 ...as always!
Thank You 🙏
Whenever I'm starting a new project at work I always check Reza's channel for things just like this. Even if you don't use this exact scenario you can apply the ideas to many other scenarios successfully.
Thank you for your kind words & thank you for following my channel.
Watched the entire cookbook and going back through the salient ones. Honestly Reza, you are such an asset to the community. Thanks
Thank You!!!
What a new great video ! Everything seems to be easy with you ! Thank you so much.
We find with you each time something more than in others channels and each time you are able to propose a global solution with everything that we need at office for our end users.
Great jobs as always, I've done a lot of progress since I watch your video. Thank you so much from Paris and I'm sure that a lot of your subscribers have this same feeling
Thank You so much for the wonderful feedback. It means a lot!
This is awesome. in fact , i have utilized this in one of my approval workflows, making it more dynamic. i utilized Apply to Each to trigger approvals based on Transaction Value, which could be 2 / 3 / 4 / 5 level of approvers based on the transaction value. i captured the approval history at each stage and showed them using the Emoji Formatting Technique, you shared. Thanks a ton for creating this.
Great! Happy to know these techniques are being used.
Thanks for sharing.
THIS IS SOOOOOO AWESOME!! you're reading my mind again Reza!!
🧠 📖
Give this man a MEDAL!!! Impressive Reza.
Thank You 😊
The love of the audience is my biggest MEDAL.
Hi Reza! I would really appreciate your help, at 15:20 I see that the "Responded at:" has an expression that I do not know. Currently my "Responded at:" has an dynamic content of the Responses Response Date but it shoots it out the sharepoint in a yucky format such as 2024-01-04T03:15:44Z. What did you write in the expression to concat the response response date to be in the easier format of M/dd/yyyy H:mm ? Thank you!
Hi,
This video was done a while ago and I do not remember the specifics. Please check video description and see if there is any link to download sample.
Amazing Reza, thanks for sharing this kind of videos, you're the best 👏👏👏👏
Glad you enjoyed it!
Awesome video! Thanks so much. One question.... @15:20... What is the "Approval Decision" expression in the "Add to comments array" ??
Thanks!
Video description has link to download entire flow. You can check all the code in it.
Reza, in the "Add to comments array" step (15:15), I'm getting an error when running the flow: The variable 'varApprovalComments' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'varApprovalComments' only supports values of types 'Array'. What did I miss?
I don’t know what you missed as I have not come across this issue.
Video description has link to download the flow. You can give that a try.
Nevermind, I've found the answer. I replaced the "set variable" action with an "append to array variable" and it worked! Thanks a lot!!
For dynamic approval workflow, it’s very fast for me but i will try to learn.🤣
Thank you for this great video🥰
You’re welcome 😊
Video description has a link to my full video on dynamic approvers.
This video was more focused on the Approval Timeline.
Reza first of all thank you for your work! It is realy helpful iven for people who do not know how to code.
You’re most welcome and thanks for watching
having an issue with the time, every time approvers approve the request, it captures the same time for all the approvers.
My most recent video shows an easier way thanks to a new function.
Check ruclips.net/video/tiLyIL6Q2Wk/видео.html
I am looking for the JSON that shows USER PICTURE AND NAME, please. It is in minute 3:22> I tried many diff places but I could not find it. Please help.
That is a column setting for person type column.
Hi Reza, great content. Thanks for sharing the knowledge. Is there a video on adding a checkbox for the approvers when they go through the approval process to ensure they have read and understood the details of the approved items? I need to see how a check box and some text can be included in that workflow.
I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Reza you are great...i am big fan of you and your awesome videos...👌👌👌👍👍👍
Many many thanks
As always awesome tutorial, thank you Reza! You are a true MS MVP 👌👍
Thank you 🙏
Am I the only one not able to make the "ticks" expression shown in the video @ 10:55 not work? I get an error that says, "The expression is invalid"
['requestDate'])),100),1000000000),60)
I have not come across any issues hence not sure
mr.Reza wanna ask something, in this case ( start and wait approval everyone must approved ) if the approver one rejected it. how to make it automatically change the status to reject ? ( not waiting for approvars 2 for respon )
Change the approval type to “first to respond”
@@RezaDorrani how about in this condition mr.reza
1. if approval 1 rejected, so the item will go to reject
2.if approval 1 approve, and then we need for approval 2 for approve. if approval 2 approve so the item will be approved otherwise if approval 2 rejected so the item will go to rejected
@@muhammaddzakysyahputra6714 For that you need to create a serial approval pattern.
Check multi step approval workflow video on my channel
This is great, you keep amaze me with your ideas
Thank you very much!
Hi Reza, excellent video again. Is there a video on using custom responses in an approval workflow? Would love to see a video on that.
Thanks!
Check approvals playlist on my channel. I have done a video on that topic.
@@RezaDorrani thanks so much!
Hello Reza, is this the video you meant?
ruclips.net/video/c4a3_VUDwk0/видео.html
Thank you Reza, all your videos helped me a lot!!
Glad to hear that!
Great video Reza. 2 Things: 1) The JSON Approval History popup shows HTML tags. How do I fix that? If I change the column to plain text I lose the line-item carriage returns. 2) The JSON Approval History popup loses the background color when scrolling. Thanks.
1 - use multi lines of text column without html option
2 - I have not experienced that so not sure
Love this!!! Now that I have this complete. Do you have or can you suggest a video/demo for how to create a progress indicator dashboard in PowerApps for it.
Awesome! Thanks.
May be this helps ruclips.net/video/0U5jax-zMIc/видео.html for the progress indicator in Power Apps
Perfect as always... Thank you for sharing these helpful videos and solutions.
My pleasure!
Thanks Reza for sharing this lovely tutorial. Much appreciated!
You are most welcome
Hi Raza, Exactly at 9:53 time in this video when you select responses approver and it's applied once, what we should choose when we have multiple approvers, in my case I have VarApprover.
2nd Thing what will be the expression for Time Taken, the one you mentioned its doest work
Please reply it's urgent, Thank you!
Video description has link to download sample flow. You can check all the code in it.
I have not come across the issue you are mentioning, hence I am not sure on what the fix is. Best to post your issue with screenshots on the forums at powerusers.microsoft.com
One year later and this still feels like gold
Thanks
hey @reza dorrani, first of all your videos are an unbelievable resource and thank you so much for sharing them with us. However my approval timeline formatting is showing anything with a "New" Approval Status as a green on the far left. Any idea what could be preventing it from turning blue in the code? If i use the code provided on your github site, all the approved and new status appear as blue where I would expect them to be on the timeline.
Most welcome!
I have not come across any issues with this so not sure. My only guess is you have probably not added all the columns needed for JSON formatting in the view
No words, simply awesome ❤️❤️❤️
Wow, thank you
Hi, with the JSON for the approval timeline, i can get the colours and positions correct but the details of the timeline are not showing when you click on the dot. Only when 'New' are showing as 'No History Available'. I cannot see any other column names I need to update in the JSON - any ideas?
I have not come across this issue hence not sure what the reason is. Video description has link to download sample flow and json code. Important for all columns leveraged in json to be a part of the view.
Hi @Reza
Thanks for sharing such an insightful video.
I have a query : You created "Approval Timeline" column as "Multiple lines of text field" but in my case when I create the column as "multiline text field" it is showing a hyperlink named "View Entries" by default as per MS feature and only If I click on it, I am able to see the Approval History comments which I have appended through Power Automate Flow.
Could you please guide me how can I rid of this hyperlink "View Entries" and directly show the comments on my main SharePoint List view page instead.
My column does not have append query turned on. I think it does that for version enabled scenarios.
@@RezaDorrani Thanks for your prompt response. Yes I have used Append feature while defining the column.
But what did you mean by : “Version enabled scenario” ?
@@PremKumar-sc7pv Turn off append query and try.
Ok. Got it. Thanks Reza 👍🏻
Hello, Ask where is the code for the Ultimata power in the Time Taken approval chronology part: this does not work for me
div(sub(ticks(formatDateTime(utcNow(),'yyyy-MM-dd')),ticks(item()?['requestDate'])),100),1000000000),60) Thank you
Did you download the flow from the video description?
requestDate must be the exact internal name of your column - case sensitive
Column type must be date in SP.
@@RezaDorrani Please can you send it to me I can't find it in the description ..... thank you
Here is the link - github.com/rdorrani/SharePoint/tree/master/ApprovalTimeline
Amazing!! However I am missing if the requestor canceled the approval. How can I use that to update the sharepoint column?
Welcome!
I have not explored that scenario, hence not sure of the steps.
Hi Reza what is the if expression for Approval Decision in 15:23?
Video description has links to download the flow.
Thank you for this video!!!! Could you help me about the calculate difference between datas. I didn’t find the calculate.
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
Hello, thanks for this great video. I have a question. What if the approvers are different people. With dynamic content. For example the manager of the requestor is one of the approvers.
In flow, you can dynamically define the approvers. I have done several videos on it.
Check ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Hello Reza, very amazing video 👏👏👏. I failed at fill "Assigned To" column in "update the item of SharePoint" action. Could you please give me some hints !
I have initialized Array Variable named "varApproversPersonArray" same as your demo, then append the Approver Person Name(from Get Departments action) into this array via apply to each. When I put this array variable(varApproversPersonArray) into column "Assigned To" of update item of SharePoint, the action " update item of SharePoint" keeps running and can't stop during test. I have check the structure of "Assigned To" column from SharePoint, it is defined as person or group type with multi-selection. I don't know where is the trouble of my flow or SharePoint list? If possible, could you share your "Approvers", "Approvers Array", "Approvers Person Array" initialization and assignment operation with me. TKS
Thanks for liking the video.
I have provided a lot of reference links in video description.
As for your issue, I will have to look at your flow in action to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hello Reze, many thanks for your reply, the trouble has been resolved. I need to give name property "Claim" for the varApproversArray, then it will be allowed add into SharePoint list.
Now, I have suffered a new trouble. I have not got the adaptive card same as your demo from my teams connector. The OperationId is "PostUserAdaptiveCard", what is the user的name in teams connector?
@@paladinli4732 Not sure about ur adaptive card issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
You always provide such perfectly explained videos, detailing the processes that have been instrumental in helping me build my flows. It's nothing be superb! Do you have a similar video for sequential approvals that you could point me to?
Most welcome!
I do not have a similar video for sequential approvals.
This approval is awesome. I do have one question - is there a way to format the email output form the approvers response array so that it matches they way it looks in the SharePoint list?
Possible. It will require a lot more work to get to it. You would need to the the Rich Text feature of multi lines text column in SharePoint and then accordingly plug in the HTML for creating the user format.
@@RezaDorrani thanks for the quick response
Thank you Reza! - I have a question please - I cannot find the expression formula you are referring to - to copy from your link - that will show the "Time Taken" by using that tick command. I looked at the link but it does not seem to have hte specific string to copy for this specific video. Can you help point me to that line? Thanks
Video description has link to download the flow. Flow includes all the expressions.
@@RezaDorrani Thank you for the reply! I did try that but for some reason when try to import the package, the button to actually import is greyed out - not sure why. I will give that another try. Thanks again! :)
@@troybrown5138 Button will become active once you have all the connectors related to flow configured. It will be at bottom of flow import page once you upload zip file.
While doing the timeline. Am unable to view the text when clicking on the timeline. Tax is stored in approval history column. Any idea how I can get the text to show on the timeline
Video description has link to download JSON and flow. Give that a try.
Important to ensure the view in SharePoint has the columns which are being used in JSON formatting m.
Hi Reza, nice video! I am having a little issue where my minutes (Approval Pending Since) are not coming in correct format after adding the json, thank you
Video description has the code base link. I will have to look at your json, sharepoint setup and flow in action to know the cause of your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you for taking your time and answering my question, sure thing, I will post my screen shots and code at the above listed site, thank you👍
Hi Reza - Thank you for a great video. I have a question, is it possible to have power automate update the attached word document with the approver names and date of approval once the approval flow is complete?
Possible by using word connector.
HI Reza, the approvalpendingtime.json file did not work for me i see a static blue dot and unable to see the popup that displays all the information, can you please help ?
You need to ensure all columns being referenced in json are part of video. Video description has link to all artifacts showcased in video. I have not run into this issue, so not sure what the exact reason would be.
Rezza, what if the approver comes from a column, each document/item has its own approver. Could you create a tutorial on that? Thanks in advance.
I make videos when I receive multiple requests on a topic. Every quarter 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.
Hi Reza, from your video "Power Automate Multi Level Approval Workflow | Serial Approval | Multiple Approvers" where in this flow would I input the Add to comments array, join? I tried to place it after the condition if length is equal to VarCounter under the If yes branch but this seems to not work
Add to comments array must be right after the approval decision is taken .
Join will be after the approvers loop is done.
Great work again Reza. Quick question, have you noticed Team action missing as of late. It looks like some Team actions have been merged together with additional options inside. Example of this is the action "Post your own adaptive card as the Flow bot to a user" no longer exists, you need to use "Post adaptive card in a chat or channel" and then choose as Flow bot > Post in Chat > then you can add recipients and an the adaptive card.
The Teams based actions were always in preview.
Preview meaning it can be changed prior to becoming Generally Available.
I did notice the changes.
Great video. Can you let us know where the ticks expression is?
Video description has link to my GitHub repo. It includes the flow zip file which you can import. I have also included the link to my blog post on ticks function.
@@RezaDorrani I cant find the ticks expression you used in the video either.. could you please copy and paste it here?
@@rebeccalooi275 All the expressions are inside the flow. Once you import the flow, you will get the expression. I do not have the flow anymore and hence do not have the expression handy.
Thanks Reza and it's Superb. Now i came to know how to use Emoji icons ( Windows + dot)
Thanks for watching
I've used your video to perfect our approval flow. It worked great! Unfortunately, I've been tasked with changing the approvers list. I need the flow to be assigned to one user, and upon approval, it's sent to another user. I can't figure out how to change it without breaking the rest of the flow. Please help
I have done many approval videos (check approval playlist). You can mix and match logic from multiple videos.
I know this is a year too late, but hopefully someone will be able to answer this question. So in the example here, Reza is using a list where each item is one document it seems. In my scenario, my team submits packages for review. There may be 3 word docs and 2 pdf files in a package. Would this approval workflow work for folders that have multiple documents in them? In this case, I would want to treat a folder as an individual "item" so that team members can go into a folder, review, revise and send onwards to the next person in the chain.
I do not have a video reference on this scenario. Forums is the best place to post issues/queries. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you so much for your response Reza! I realized than an item can have links appended to it as attachments. I will see if this works instead of using folders. Thank you again for your dedication to providing high-class instruction to your viewers!!
Hi Reza,
Thank you again for your videos, they've helped me so much.
Do you have a specific video which goes through the the population of the 'assigned to.' column?
I've got my dynamic approvers working but can't seem to get my flow to correctly populate the assigned to column with all approvers from the person picker from the approvers list.
Regards
Your most welcome.
Video description has link to download sample flow. May be that includes the dynamic approval logic.
I also have a full playlist on my channel on approvals which has a wide variety of scenarios covered.
Hello Reza, I appreciate the time and the level of detail that you provide on your videos. I want to use this format but I would like to trigger the flow with Form submission including a picture attachment from the form. How can I accomplish that?
I don’t think there is any trigger that checks picture attachments. You can trigger flow on form submission and then get its attachments
Hello Reza
thanks for the super video.
Question.
How do i change the Pacific time Zone? Because it does not correspond to my time zone.
Thanks
Change it to any time zone of your choice.
Here is the list: docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones
Nice video Reza! I am having issues from the PNP. I can not find the column formatting that you used. Could you help me find when exactly you have it?
PnP link must have moved. Check comments if someone did post updated link or try searching for it online. Im not aware of updated link.
The column formatting for my approval timeline doesn't work :( it is always on the far right no matter what status
I have not experienced this issue hence not sure what the reason for your issue could be. Video description has link to download sample for formatting.
Reza love this and I have been trying to replicate . Can I ask what was the exact JSON you used for the column formats for Timeline and days approved For some reason mine isn't working.
Link to JSON code is in video description.
Which one from the many headings. What is it named?
Hey Hi, I need your help. I could not find Status Value when im create a update item(sharepoint) in power automate. i could not find a option like status value
Video description has link to download entire solution.
As for your issue, I have not experienced the mentioned issue and hence not sure what the cause or fix for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, Hope you are doing well.
I have a question, we have a document library with folders for each request and now it's more than 2000. and giving delegation warning while filtering the items and the attachments are not showing for each request.
how to filter this without delegation warning from the document library.
thank you.
Check ruclips.net/video/TmRFAP7xTwk/видео.html
Thanks Dear Reza... Awesome...🙏
Most welcome 😊
This is really cool! I will definitely try to replicate this after work today! thank you so much for sharing.
Great!
I just released another version of formatting with multi-step approvals.
Let me know what you think of this as well - ruclips.net/video/gb_FUeRjgg4/видео.html
Super helpful and thanks for posting Reza.
Glad it was helpful!
Reza, I am trying to recreate your flow (cutting and pasting where possible), and for step 8 (updating the item) I am using a SharePoint update item, I select the site address, list name, and then for the ID, it gives me the option to select from the "Get Items Department Task" or "When an item is created" - when I select either one of those it nests it in a new "Apply to each" function and adds "Select an output from the previous steps" where it adds "(Sharepoint)value - Am I doing something incorrect here?
May be :) I will have to look at your flow in action to provide any guidance. I would recommend to post your issue/query with screenshots on the forums at powerusers.microsoft.com.
Hi Reza, thank you very much for your videos and tutorials. They have been very useful in my project work. I have created the approval timeline in a document library and a SharePoint List using the JSON that you provided. Everything works fine in the list. However, I am unable to see the approval history when I click on the timeline in the document library. I cannot figure out what the problem is in the library. I have already modified the column names to match those in the JSON.
I will have to look at your JSON formatting in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Thanks Reza, I have solved the problem. I have another question - Is it possible to attach supporting documents to a file in a document library?
@@hannahmay3078 Look into document sets
@@RezaDorrani Thanks for this suggestion Reza, it has worked perfectly :)
Hi Hannah, I'm having the exact same problem as you, my approval timeline does not show when I hover over it. Could you share the solution?
Awesome video bro thank you really appreciate it. Just one question here, instead of "floor((Number(@now)-Number([$Created]))/(1000*60)) + ' min(s)'" how can i stop the time once the approval is done. I have a column named (Approved/Rejected Date) I tried to change the code but it not working.
You would need to add like an if condition to checking if approval is not pending. I would have to try it to get exact expression hence giving hint.
HI Reza, thanks for the amazing work. I followed the entire video to build mine.
How can I set users to recieve email notification when they make request from share point.
If user is making the request, why would they need a notification then :)
I am not following your approval pending since column. in your github it's saying single line text and in you video it's sayin date and time column. also in your JSON you used a column name 'CurrentApprovalStartDateandTime' i don't see the column in your video. can you explain how can i get the timer like your created, please
you are talking about this exactly at 13 minute in the video
Github has the flow, SP column types and all you need. It's been a while since I did this video and not possible for me to remember each step. Give the github solution a try and in case of issues, I recommend posting issue with screenshots on the forums at powerusers.microsoft.com
Another awesome tips, by the way can we do this steps in document library? If yes are the steps the same as shown in this video?
Yes you can! Steps would be similar.
Check my playlist (it has some doc lib ones in there) - ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
Hi Reza, thanks for the tips. Could I use this formating stuff on custom columns of a document library in sharepoint? or this only works on sharepoint lists?
Works for both lists & libraries
Loved the video. Awesome. 🙏🙏👌Did something similar using spfx listview command set and column formatter. No Power Automate and was dynamic. I too "Stealed" from pnp samples.
Great 👍
@Reza, Could you please tell us if we have more than 3 status then how we can decide pointer position. Like New, In progress, Pending, Rejected, Approved, On hold etc.? Here we are using center, left alignment but ho we can achive this withou alignment.
In that case you would have to use some relative positioning.
Check width of element, divide by number of status and accordingly apply margin.
I have not tried this scenario though.
Hi Reza, This is amazing thank you! I was wondering if there is a way to cancel the flow run from the list item that triggered it as well 🤔
There is no direct (programmatic) way to cancel a flow run. You would need to query Dataverse for that and update System Tables which is not recommended.
Reza this PHENOMENAL content and it arrives at just the right moment. I have a question please. Approvals and Document Library: when approvals are submitted, if the file in document library is open, the flow fails - error400 file is locked for shared use. It has become a nightmare. Can you help suggest how to overcome this??
Thanks,
For documents being opened and file locked, I have not run into those scenarios.
I will recommend you check on the forums at powerusers.microsoft.com/
In the demo, there is a column for Ticket due date. Can you please help me how to configure on the same?
Video description has link to my GitHub repo which walks you through the steps.
does anyone know why the following is an invalid expression "convertFromUtc(triggerBody()?['Created'], 'Arabian Standard Time', 'M/dd/yyyy h:mm tt')", Isn't that recommended built-in syntax after I press "/" and choose the Created option. I used Reza's syntax from the video and It's working now.
Whats the difference between the syntax in video and that one
@@RezaDorrani nvm it resolved when I copied your syntax. I'm having trouble now finding the expressions used to calculate the time taken for the approval from the description! If you can direct me it would be great.
@medonic I did this video years ago and do not remember the specifics. If anything was shared, link would be kn video description.
@@RezaDorrani I noticed that you recently are just sticking with power apps to automate approval workflows, why is that? is it more convenient? this is my first encounter with an automation of that sort for a PR approval process and I need to support functionalities like reassignment (or holding the pr for further clarifications and corrections) and visibility over who approved and who didn't and how much time it took. Any advice would be great!
@medonic There is not specific reason. I go based on user requests and what I feel like making at that moment.
My advice would be to check or post your query on forums in case someone has done something similar
community.powerplatform.com/
In "Add to comments array", was it a set variable or append to string/array variable?
I have done this video long back so do not remember. Video description has link to download sample flow. You can check the full code in there.
@@RezaDorrani Thank you Reza. I was able to confirm it by importing the flow. Thanks for the tutorial.
Hi Reza, I'd have some issues need your help:
1. Can you share me the if expression in "Append array to Approver comment". I used the expression to get the decision from each approver.
2. Approver comment when click the button in Approval timelines only seen for current ticket, the previous show blank window.
Thanks.
Video description has link to my GitHub repo which includes the flow + the column formatting JSON.
Give it a try and see if it helps.
Hi Reza, unfortunately the text „approval started by…“ doesnt show up in the grey box of my approval timeline, although I can see those if I click on settings of the item and check the meta data manually. so my grey text box consistently stays empty. only if the item is new, it shows „no history available“ - which is part of the json code. but after switchting the status - as I said - the box stays empty. any tipps to fix it?
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
Hello Diba Dubida, I am having the same issue. Were you able to find a solution?
@@Aaron-zk4ls omg thank you, it really worked and it was so easy to begin with 😭😭
@@0888biga check this comment bro, it fixed it for me
Can i know which one is the statement that for expression of time taken, i open the link provided in description but i dont get it...
I believe I shared the entire flow demonstrated in video. Video description has the link. Download and flow and check the code.
Reza, thank you so much for the videos, they have helped me so much. I do have a question though. I have the cost of a quote in a column and it is only valid for a certain number of days and then it expires, so I would like to have a RAG colour code providing me with a visual indication of how many days were left until it expired based on when it was added and changing colours at certain periods when it counted down to so many days left, how would I do it?
Your question is related to json formatting. Check the documentation, it includes samples. I have not tried this scenario.
@@RezaDorrani thanks for the quick response. Could I ask, what documentation, thanks ?
@@Cartoonhotpot Search for Microsoft documentation on list formatting.
Here are some samples on github github.com/pnp/List-Formatting/tree/master/column-samples
Hey Reza, I love the flow. But, when I test it, I keep getting hit will a "Null" error. My flow doesn't seem to like the "Null" in the Update item area. Can you help?
I have not run into this issue. May be add expressions to check if that value is null. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I will post to the forum, will you be able to very it?
@@AbraxasKing I go to forums to assist only in my free time. There are many other experts on forums.
Hi Reza, Amazing video!
If I have multiple approvers and I want all of their responses, but want to live track who has responded so that I can know whose approval is pending - how can I do that.
Later I want to check if all approvers approved or anybody rejected as well.
Thank you in advance!
In case of everyone must approve or wait for all responses, the flow will not move ahead until the approval task is complete.
To check who responded while the task is running, you would need to query Dataverse Tables for Approvals in a parallel branch.
This will require premium licensing + admin access to the tables.
I did a video on reminders wherein I query Dataverse to check to see which users have not yet responded - ruclips.net/video/ZupQ0AbDl0I/видео.html
@@RezaDorrani Do you think we could avoid the premium licensing if we did parallel branches for several single approvals, somehow collect a count of approvals and if all approved update item as approved? Each separate approval could just update the timeline. Would that work?
@@fleurwilliamson5920 Yes you could do that. But then your approvers would need to be more or less static since you have those many parallel branches pre-created.
Hi Reza, amazing video really easy to follow. I need help though. I've managed to get the Approval timeline to appear correctly, however when I click on the timeline it shows the grey box with "=if(Approvalstatus]!='New',[$Approvalcomments],'No History Available'. The choices and Approval status column match the ones in the video. The only thing I cannot find in your video is [$Approvalcomments] which I did not create due to it not being in the steps. Where can I link approval comments into the list?
I've manage to show No History available - Now it is not showing the audit trail when 'Pending' or 'Approved'
Video description has link to download sample App + the link includes the schema of the list to be created. Give that a try.
Video description has link to download sample App + the link includes the schema of the list to be created. Give that a try.
Hi Reza, hope you could help with this: Howcan I update mi sharepoint list item status as cancelled when an approval is canceled from Power Automate/Action Items/Approvals
I'm not sure if there is an action to catch canceled approvals.
When approval is canceled, if flow does move ahead, I'm sure it would give some sought of JSON output.
You would need to catch that and accordingly update list item status.
@@RezaDorrani Thanks for your reply, how can I catch this JSON output?
@@andysanchez8732 I do not have the exact steps on it. Approval action for flow will have that output. I have not tried your scenario.
I am getting an error with regard to the null value One or more fields provided is of type 'Null', a different type is expected. any suggestions
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
how about in this condition mr.reza
1. if approval 1 rejected, so the item will go to reject
2.if approval 1 approve, and then we need for approval 2 for approve. if approval 2 approve so the item will be approved otherwise if approval 2 rejected so the item will go to rejected
Check multi step approval video - ruclips.net/video/gb_FUeRjgg4/видео.html
Hi Reza,
in the append comments variable step, what is the syntax of the function you are using to check if it is approved or rejected?
I believe all the code (flow and json) is shared in video description
@@RezaDorrani I tried to import your flow solution from the github but there is a file missing in the zip which is throwing an error in Power Apps
@@akshay._.solanki A lot of folks have installed it without issues. Not sure why it is happening in your scenario.
@@RezaDorrani The solution file is invalid. The compressed file must contain the following files at its root: solution.xml, customizations.xml, and [Content_Types].xml. Customization files exported from previous versions of Microsoft Dynamics 365 are not supported.
This is the error message I am getting
@@akshay._.solanki I dont think its a solution file. Its just the flow.
How can we do this. but for the "assigned to" give an option to the requester to choose to whom will the approval go?
For that you would need to use a different trigger ruclips.net/video/2Hp9CTd8zQU/видео.html
@@RezaDorrani thank you, the link you provided definitely helped. For the video you put a link to (for a selected item) how would the flow work if we put 3,4 approvers? Would they all get the email for approval and what would happen to the Sharepoint list? How would that be updated? Thanks!
@@andjelamihajlovic5614 That is upto you to decide. You could send the approval actions serially, or everyone must approve etc. only you read the responses, you can take the action on the list item.
The filter query 'Category Value' will not populate for me. Any suggestions?
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
We are sending the email to the distribution list but we are not able to log the approver name from the distribution list while we are able to log the approver name if the email goes to the individual. Kindly confirm how can we capture the approver name from the distribution list(DL)?
I am not sure about that. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani thanks for your suggestion. Will check in the mentioned forum
I only email list，how build person claim array for add to sharepoint multi person columns?
I have done plenty of approval videos. Some include sending approvals to multi person columns.
Check ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Hi Reza, is it possible to add a CC Email in the Approval workflow?
Great question. You have me stumped :)
I would say No.
This is an amazing e2e tutorial Reza! I am so glad i stumbled upon your channel. Thank you for sharing this to newbies like me :) I have a question though, what if i want to run a report to export the data from this list to an Excel, will i be able to get the whole Approval History log as one column in the same row, as how it is in the Sharepoint list?
Yes it would export as whole approval in single row since the column stores entire approval history information.
@@RezaDorrani Thanks for the response Reza, would you happen to have a tutorial on how to use your own adaptive card on the Approvals for Outlook?
@@yojie120 I do not have a video on adaptive cards in Outlook. I have it in my backlog.
@@RezaDorrani thanks for the reply.. hopefully there will be soon :)
Hello Reza, the item link in "start and wait for approval" works fine if the assigned to was my email, however all other users are receiving this error "Sorry something went worng, no item exists...". what am i missing here?
Permissions issue may be. Approvers do not have access to that item in SharePoint.
@@RezaDorrani Thank you for your prompt reply. When i customised my sharepoint list in powerapps the links stopped working. If i copy the same list without customisation, the links would work... i'll keep trying.
@@noraaridi7177 That is weird. Keep trying. Try posting on the forums as well at powerusers.microsoft.com
hello Reza you can make a video teaching how to make a pop up ?
example: when someone access the page comes a welcome pop up
This one is already it my backlog.
I will give it a higher priority.
Cool Thank you
hi, great channel . can u help me. how convert time zone for this output " Responses Response date" ..thx u
Thanks!
I have not done a video on that so not sure.
I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
Hello Reza, thank you for these videos. I am having an issue where my card is showing "
You are probably using a rich text multi line column. Video showcases multi line text column without rich text enabled.