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!
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.
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.
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
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.
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
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.
@@jayendrakhadikar1291 Hehe. Cannot. I have a lot of other items in my backlog which have a higher priority since many have requested it. Also, balance rows is a very specific request.
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
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.
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
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.
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.
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/
Reza, Your videos are very informative, thank you very much for your effort. I have a question about the Ticket Status field. Without using a Custom Form, maybe using JSON, can we restrict the possible values of the Ticket Status field based on its current value? For example, when Status='In Progress', the 'New' option is removed from the options, and when status='Resolved', the options are only 'Resolved' and 'Cancelled' etc.
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.
Thanks You. Approval pending since(Mins) column value is being calculated on the fly using column formatting. It will not be available in Power Apps. Power Apps has functions where you can do a Date Difference between the current date and time & the approval start time.
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.
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.
Hi Reza, Your videos are very helpful and excellent. I would like to learn dataverse in Traditional Power apps(not from Teams), could you please suggest any reference videos or materials. Requirement is need to create an app by using dataverse from traditional power apps. Waiting for ur reply.. Thank you in Advance
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👍
This is awesome Reza, I have learned so much from your channel. I have a challenge; currently building a Powe App and there is a field with hundreds of vendor options. How can I either filter or click on a find option next to that field and select from the hundreds of options and then set the selected vendor as the value for that field. Any help of useful links would be appreciated. Thanks in advance 🙏🏾
Galleries would be the answer. How - I would have to recreate your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani hello Reza, thanks for the response. I will post the scenario with screenshots as you advised. I hope this is something you can do a tutorial for. I think many of your users will find it valuable. Also, I saw an option for Combo box as you can filter results as you type in the box. However you have to connect the lookup field to another list in Sharepoint Cheers Stephan
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
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.
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 It's incredible the things that are possible make with this tools. I already implement some examples of you videos in my organization and this is the next, no doubt! Greetings from Spain, A Coruña.
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
Hi Reza, is somewhere the full flow including the dynamic approval shared/public? It would be great to search for in power automate not to start at zero. The result you build here is great! Best Regards, Oliver
Video description includes links to download flow and formatting. Also includes link to my approvals playlist that has several step by step approval videos.
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?
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, 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
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.
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?
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” ?
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
Hi @Reza.... I really appreciate the effort put in by you to create this video. With help of this video I was able to create a similar flow to fulfil my requirements. Thanks. After creating the flow, I am facing a scenario for which I need your support : Lets suppose, If there are 2 approvers and first approver approves the request (without putting any comments .i.e. comment field is empty) and second approver rejects the request (without putting any comments .i.e. again comment field is empty), then as per the flow we will not come to know which approver rejected the request as Approval Timeline column will show that request is rejected and in comments field we will get no information as it will be empty as both approvers did not put any comments. Is there a way out by which we can display the information under "Approval Timeline column" in a way which shows clearly which approver accepted the request and which approver rejected the request without making comments field set as a mandatory field for approvers.
The approval name, decision and comments are all recorded in timeline. Comments is optional. Timeline would still show who approver is and what decision they have taken. Video description has link to download the flow. You can give that a try and check this in action.
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.
Thanks, amazing like always, reza I have a question, is it possible to change the column of the title column? I know that it can be renamed, but if it is a list that now I want the title to be another field of the list, is it possible? do you have any video about it? thanks :D
@@RezaDorrani when I made the list I decided that the name of the person should be the title, but now I want another column that has the last names to be the title, the list already has several records, I just want to do that so that the last name column shows the options share and the other options that the title column puts when you hover over the record, but I don't know if that's possible, Gracias Reza
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)
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.
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
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
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.
@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.
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
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.
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!!
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, 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.
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
Possible. We would have to define some logic to position the circle at specific intervals. (may be use margin property). I will have to recreate your scenario to provide the exact code.
@@daxteoh27 I would have to try it out myself. I have moved on to other videos now. So this will not be anytime soon. I do have a video on multi-step approval coming tomorrow with more formatting tricks.
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.
Thank you so much for the other great video. Can you please guide me if I unselect approver comments from my view then comments do not show on the timelines card? In your video, the approver comments are not showing in view but showing properly on the timelines card so please guide. Thank you so much again.
@@RezaDorrani I formate Approver comments column using the same JSON and it did the work. So either apply the JSON on approver comments or add/update comments in Timelines column both will work.
@@RezaDorrani I get error Can you please help. The 'inputs.parameters' of workflow operation 'Update_item_2' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/ApprovalPendingSince' is required to be of type 'String/date-time'. The runtime value '" "' to be converted doesn't have the expected format 'String/date-time'.
Hi sir GM, i am taking backup for a SharePoint list every day in CSV format into share point folder now I want to get the number of records in that CSV file need to send count in a mail using power automate. Can suggest some thing for me
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 🙏
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 SOOOOOO AWESOME!! you're reading my mind again Reza!!
🧠 📖
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.
Give this man a MEDAL!!! Impressive Reza.
Thank You 😊
The love of the audience is my biggest MEDAL.
One year later and this still feels like gold
Thanks
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.
Thanks Reza for sharing this lovely tutorial. Much appreciated!
You are most welcome
Amazing Reza, thanks for sharing this kind of videos, you're the best 👏👏👏👏
Glad you enjoyed it!
As always awesome tutorial, thank you Reza! You are a true MS MVP 👌👍
Thank you 🙏
Thanks Reza and it's Superb. Now i came to know how to use Emoji icons ( Windows + dot)
Thanks for watching
This is great, you keep amaze me with your ideas
Thank you very much!
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.
Perfect as always... Thank you for sharing these helpful videos and solutions.
My pleasure!
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
No words, simply awesome ❤️❤️❤️
Wow, thank you
Thanks Dear Reza... Awesome...🙏
Most welcome 😊
Thanks so much Reza. I gained a lot
Great!
Super helpful and thanks for posting Reza.
Glad it was helpful!
Amazing!! Thanks for this great video🤩😆😍
My pleasure 😊
Thanks for sharing Reza 👍👍
👍
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.
Excellent Thanks Reza
Thank You
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, 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 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
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.
Very informative. Thanks for sharing. Pl make a flow to remove duplicate from list and update status of balance rows.
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.
@@RezaDorrani You can consider this as lot more request.
And thanks for responding.
@@jayendrakhadikar1291 Hehe. Cannot. I have a lot of other items in my backlog which have a higher priority since many have requested it.
Also, balance rows is a very specific request.
Hi Reza, The video is just awesome, can you please post the Json for the Approval Timeline Column
Video description has links to all the JSON code and the sample flow.
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
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.
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
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?
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
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.
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/
Reza, Your videos are very informative, thank you very much for your effort.
I have a question about the Ticket Status field. Without using a Custom Form, maybe using JSON, can we restrict the possible values of the Ticket Status field based on its current value? For example, when Status='In Progress', the 'New' option is removed from the options, and when status='Resolved', the options are only 'Resolved' and 'Cancelled' etc.
Thanks.
You cannot update dropdown options with JSON.
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.
This is awesome, great job, can we use output of column “approval pending since(Mins)” ?, I mean can I use it in powerapps?
Thanks You.
Approval pending since(Mins) column value is being calculated on the fly using column formatting. It will not be available in Power Apps.
Power Apps has functions where you can do a Date Difference between the current date and time & the approval start time.
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.
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
Hi Reza, Your videos are very helpful and excellent. I would like to learn dataverse in Traditional Power apps(not from Teams), could you please suggest any reference videos or materials. Requirement is need to create an app by using dataverse from traditional power apps. Waiting for ur reply.. Thank you in Advance
Check aka.ms/powerappsresources
Great job Reza. 👍👍
Where can we find the column formatting code that you have used to create a timeline or time since the last update?
Video description has all the links
@@RezaDorrani Thanks Reza
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👍
This is awesome Reza, I have learned so much from your channel. I have a challenge; currently building a Powe App and there is a field with hundreds of vendor options. How can I either filter or click on a find option next to that field and select from the hundreds of options and then set the selected vendor as the value for that field. Any help of useful links would be appreciated. Thanks in advance 🙏🏾
Galleries would be the answer.
How - I would have to recreate your scenario to provide any guidance.
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani hello Reza, thanks for the response. I will post the scenario with screenshots as you advised. I hope this is something you can do a tutorial for. I think many of your users will find it valuable. Also, I saw an option for Combo box as you can filter results as you type in the box. However you have to connect the lookup field to another list in Sharepoint
Cheers
Stephan
@@nohpetsrs I will add this request to my backlog. But I will need a lot more folks requesting this to give it a higher priority.
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
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.
Excellent video! This is what I had in mind, I wasn’t sure if this was possible. Is it possible to add reminders as a parallel action?
Possible. Check the approvals playlist on my channel.
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
A M A Z I N G
T H A N K Y O U
@@RezaDorrani It's incredible the things that are possible make with this tools. I already implement some examples of you videos in my organization and this is the next, no doubt! Greetings from Spain, A Coruña.
@@albertocastro365 Thank you 🙏
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
Could you share,
How to create department list as a prerequisite of this approval process
Its a simple SharePoint list that has the Title column and an Approvers column of type person or group multi select
Can all this fantastic work be accomplished in a MS List instead of a SP List?
Absolutely! A Microsoft List is a SharePoint List :)
@@RezaDorrani thanks for confirming!
Hi Reza,
is somewhere the full flow including the dynamic approval shared/public? It would be great to search for in power automate not to start at zero.
The result you build here is great!
Best Regards,
Oliver
Video description includes links to download flow and formatting. Also includes link to my approvals playlist that has several step by step approval videos.
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
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, 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?
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.
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!!
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 @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 👍🏻
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
Hi @Reza.... I really appreciate the effort put in by you to create this video. With help of this video I was able to create a similar flow to fulfil my requirements. Thanks.
After creating the flow, I am facing a scenario for which I need your support : Lets suppose, If there are 2 approvers and first approver approves the request (without putting any comments .i.e. comment field is empty) and second approver rejects the request (without putting any comments .i.e. again comment field is empty), then as per the flow we will not come to know which approver rejected the request as Approval Timeline column will show that request is rejected and in comments field we will get no information as it will be empty as both approvers did not put any comments.
Is there a way out by which we can display the information under "Approval Timeline column" in a way which shows clearly which approver accepted the request and which approver rejected the request without making comments field set as a mandatory field for approvers.
The approval name, decision and comments are all recorded in timeline. Comments is optional.
Timeline would still show who approver is and what decision they have taken.
Video description has link to download the flow. You can give that a try and check this in action.
@@RezaDorrani thanks for your prompt response. Ok. Let me try again.
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
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.
Thanks, amazing like always, reza I have a question, is it possible to change the column of the title column? I know that it can be renamed, but if it is a list that now I want the title to be another field of the list, is it possible? do you have any video about it? thanks :D
You can rename it. You can always have another field that you add to the form. Not sure I understood your question.
@@RezaDorrani when I made the list I decided that the name of the person should be the title, but now I want another column that has the last names to be the title, the list already has several records, I just want to do that so that the last name column shows the options share and the other options that the title column puts when you hover over the record, but I don't know if that's possible, Gracias Reza
@@sadelina2763 You can always create another column and name it title or last name. You can use column formatting to create that link experience.
@@RezaDorrani Ooh okay thanks 🤩
how do i see the video of the dynamic flow you showing at the end
Thanks
Video description has link to download the flows.
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
Hi Reza, is it possible to add a CC Email in the Approval workflow?
Great question. You have me stumped :)
I would say No.
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.
Thank you so much Reza. How do we do the chat with Approvers on the column formatting
Video description has link to download the JSON samples from my GitHub repo.
@@RezaDorrani thank you!
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.
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
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
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
@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.
hello i try yo find the json about the column approval timeline but i can't, please can you help me
All details are in video description
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.
What is multiple user create item in at a time. Will it work for all??
Try it and see
I cant seems to find the get approval decision =(
Video description has links to download the sample 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
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.
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!!
Reza can i also track process timeline ex movement of tickets from one department to other from a unique trigger within Microsoft forms ?
Not sure with Microsoft forms.
Hello Reza i have an issue with this video, it starts very well and at the end it get lost because the Dynamic flow at the end how did you build it
Video description has link to download the flows.
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.
Do you know why I would be getting the below?
There is nothing below :)
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.
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
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.
Never think of such format can be done! What if we have more than 3 choices of Status, how do we justify the content, Reza?
Possible. We would have to define some logic to position the circle at specific intervals. (may be use margin property).
I will have to recreate your scenario to provide the exact code.
@@RezaDorrani Can't wait to see it Reza!
I was struggling to find it online as majority of them used number to gauge the progress.
@@daxteoh27 I would have to try it out myself. I have moved on to other videos now. So this will not be anytime soon.
I do have a video on multi-step approval coming tomorrow with more formatting tricks.
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.
Wondering if this approval timeline trick can be applied in a PowerApp that is pulling from a SharePoint list?
Possible. SharePoint uses JSON code. Power Apps code language would be Power Fx.
Thank you so much for the other great video. Can you please guide me if I unselect approver comments from my view then comments do not show on the timelines card? In your video, the approver comments are not showing in view but showing properly on the timelines card so please guide. Thank you so much again.
Will it solve the problem if i write flow history in the time lines column instead of Approver comments and then specify the time lines field in json?
It must be a part of the view (is in my case as well, may be column is on right of screen so not visible).
It could but logic would change.
@@RezaDorrani Thank you so much for your reply.
@@RezaDorrani I formate Approver comments column using the same JSON and it did the work. So either apply the JSON on approver comments or add/update comments in Timelines column both will work.
Can you please send "Flow calculate date difference" commands
Video description has the link
@@RezaDorrani I get error Can you please help.
The 'inputs.parameters' of workflow operation 'Update_item_2' of type 'OpenApiConnection' is not valid. Error details:
Input parameter 'item/ApprovalPendingSince' is required to be of type 'String/date-time'. The runtime value '" "' to be converted doesn't have the expected format 'String/date-time'.
Hi sir GM, i am taking backup for a SharePoint list every day in CSV format into share point folder now I want to get the number of records in that CSV file need to send count in a mail using power automate. Can suggest some thing for me
I do not have any references on this topic. I recommend posting your query on forums powerusers.microsoft.com
@@RezaDorrani thank you sir
I actually created an approval library before I saw this - does it have to be a list?
It can be a Library as well. Check ruclips.net/video/c4a3_VUDwk0/видео.html
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.