This is nice Reza. Recently used the Grant permission in Sharepoint through Power Automate. I Like the Append feature for Multiline, this makes it easier to see more comments if you have multiple approvers
I have been implementing approval systems in SharePoint for years. There are so many considerations. One part of the recipe that I like to use is this: Set up a multi column rich text field called "History". Hide this from the form. Use workflow to detect when approvals occur and append a line entry into the History column to record the action. This can be formatted using HTML because it is rich text. E.g. "Joe Smith Thu Oct 24 2024 8:34 AM Set Approval 1 to Approved." This allows a summary of approval steps to appear on the list view in one column.
@@RezaDorrani Yes - you are right, pretty much that concept. I just mean that it is something exclusively updated by the workflow. Basically the workflow itself detecting events and keeping a user friendly log of what took place and when.
@RezaDorrani Hi Reza, Is it possible load 3 lakh + rows table into power BI and schedule the reports using data via API Call. I'm able to load only 10k rows at a time
Hi Reza, really helpful videos! I've just started using Power Automate and your videos are great! Question on the approvers list, is there a way to use the current list members, contributors, and designers for the approval flow? Instead of having a separate supporting list.
Hi Reza, great video. One thing i want to ask, what is the best way to remind the approver via email or teams? And how to make the reminder only sent to approver that not yet respond the approval?
Agora eu tomei um susto, pensei que o Reza havia feito um conteúdo exclusivo para o Brasil kkkkkk, achei até estranho, título em português.... mas qdo abriu a voz...kkkk realmente era um AI kkk
This is a great video! I just want to make sure: Why do we give approvers a design access level? Why is a contributor not enough? Is it because of the Content approval method?
Great video as always Reza, one challenge I have is with power automate. I want the approval/rejection email to come from the reviewer, not the owner of the flow.
Great content !! 1) Is it possible to allow members to view only their own requests, without granting them access to view other people's requests, regardless of their status? 2) Is it possible to implement this as a multi-level sequential approval process?
I'm not sure if that's an option. I make videos when I receive multiple requests on a topic. I have topics with over 50+ suggestions that I am yet to get to.
@@RezaDorrani please cross check once you have not done this video. Try to show pending vs approval details when you assign approval for multiple members..
@venkatponnamsnow If you mean a scenario where 1 task is assigned to multiple users and you need to know which users have approved or no, then I have shown it in reminder video where I query dataverse to know which users have not responded. Similar concept can be used to frame your scenario.
Hello Reza, very good content, I will subscribe and take your courses, I had a question that I am trying to integrate your guides and this permissions option would help me for my quote approval flow, what happens is that I want to send approval requests from 3 suppliers, I need the approver to also view the quote files from Power Apps, I am working with SharePoint document libraries to view it by integrating the view into Power Apps, would it be possible to do it with this method in the video or is it only for the SharePoint and list view?
Looking forward to having you join the courses. The same permission settings will be respected by power apps as well and the feature is available for doc libraries also. Give it a shot.
@@RezaDorrani Thanks for your quick response, I've been testing it today, I've activated the approval column in sharepoint, but I can't find that column from power apps, that is, it doesn't detect me, it's as if it didn't exist. Is it something I'm doing wrong or is there another method to do it in Power Apps by restricting these permissions for that approval column? or would it be advisable to use approval from the sharepoint interface?
@j0hN13aL I'm not sure what exactly you are trying. Probably best to post your query on forums in case someone has done something similar community.powerplatform.com/
@@shaikhrijwan9322 All memberships are monthly. Channel membership details thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=c5EBcvvn3Eg
Thank you for sharing just a modernised method of approval, I tried it but approval button is forwarded to automate page instead of being done inside the email body
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hello Raza When the approver recieve email for approval it say requested by Reza however the item was created by Sarah. Can you please explain. Thank you!
Flow Owners connection is used for the approvals action. Best Practice: use a service account for approvals connection or use the requested by property in approvals action to define who the requestor is.
What happens to the approval flow if the approver just goes into sharepoint and approves an item from in the right click menu? Are they integrated and it cancels the automation flow or does the flow sit open until timeout and leave a broken approval request in the power automate pending approvals list?
The approval workflow via flow approvals would be pending. If response if taken by approver on SharePoint, you could check status of approvals in flow and send notifications email.
How to allow user to add notes after the item has been Approved? as the message "Applying changes will cancel your request". As I want my project to be Approved, but the user to add project status notes after the approval process?
The way you explain is just wowwww. Great content. Thanks 👌
Glad you think so!
This is nice Reza. Recently used the Grant permission in Sharepoint through Power Automate. I Like the Append feature for Multiline, this makes it easier to see more comments if you have multiple approvers
Thanks!
The permission handling along with append feature covers all the bases.
I have been implementing approval systems in SharePoint for years. There are so many considerations. One part of the recipe that I like to use is this: Set up a multi column rich text field called "History". Hide this from the form. Use workflow to detect when approvals occur and append a line entry into the History column to record the action. This can be formatted using HTML because it is rich text. E.g. "Joe Smith Thu Oct 24 2024 8:34 AM Set Approval 1 to Approved." This allows a summary of approval steps to appear on the list view in one column.
Did you check the Comments multi line of text column shown in video?
@@RezaDorrani Yes - you are right, pretty much that concept. I just mean that it is something exclusively updated by the workflow. Basically the workflow itself detecting events and keeping a user friendly log of what took place and when.
Love this idea. Thanks!
@RezaDorrani Hi Reza,
Is it possible load 3 lakh + rows table into power BI and schedule the reports using data via API Call.
I'm able to load only 10k rows at a time
@@AK-ij9il This video is not related to power bi :)
I suggest posting your query on forums at community.powerplatform.com/
Por fin, traducido al español, gracias Reza!!
Thanks to UA-cam
A tradução automática para o português Brasil está muito boa, parabéns pelo vídeo
Great to hear
Hi Reza, really helpful videos! I've just started using Power Automate and your videos are great!
Question on the approvers list, is there a way to use the current list members, contributors, and designers for the approval flow? Instead of having a separate supporting list.
Thanks!
I have already done videos on that.
ua-cam.com/video/WT08hJ1zDyw/v-deo.htmlsi=oIa5puNy7tjYZHBg
Great video ❤❤.Thanks 🙏
You are so welcome
Insightful 💡
Thanks
Hi Reza, great video. One thing i want to ask, what is the best way to remind the approver via email or teams? And how to make the reminder only sent to approver that not yet respond the approval?
Check my video on approvals reminders
Extraordinario!!!!!!!!
Thank You
In spanish!!! You are a Genius man! Vamos Reza! 🧉
Thank You!
Agora eu tomei um susto, pensei que o Reza havia feito um conteúdo exclusivo para o Brasil kkkkkk, achei até estranho, título em português.... mas qdo abriu a voz...kkkk realmente era um AI kkk
Yes - it's a new UA-cam feature.
I hope AI is translating it well
This is a great video! I just want to make sure: Why do we give approvers a design access level? Why is a contributor not enough? Is it because of the Content approval method?
Its because of content approval method. You can also create a custom permission level and only grant read and approve permissions to approvers.
Thank you Reza
Most welcome!
Great video as always Reza, one challenge I have is with power automate. I want the approval/rejection email to come from the reviewer, not the owner of the flow.
For scheduled and automated flows. the connection would be flow owners. Better option is to configure using service account.
"looks good" 😅😅-- very much approved!
Thanks 😊
Great content !!
1) Is it possible to allow members to view only their own requests, without granting them access to view other people's requests, regardless of their status?
2) Is it possible to implement this as a multi-level sequential approval process?
1 - You would need to set item level permissions for that I guess.
2 - Possible
@@RezaDorrani #2 would be possible by just adding steps to the workflow for status changes and adding additional choice to the status? Correct?
@@user-uv8cj4cn4l Something I would have to try to know the options.
@@user-uv8cj4cn4l Something I would have to try to know the options.
Hi Rezza, is there a way to embed the approvals in the word document using power automate? If you would make a video on this topic it would be great.
I'm not sure if that's an option. I make videos when I receive multiple requests on a topic. I have topics with over 50+ suggestions that I am yet to get to.
Can we remove the requested by Diplay name in approve mail?.
Approval emails cannot be customized
Awesome
Thanks Rick
A great lesson from Reza! The request is submitted many times in the loop. Could you tell me how to make the thread go through once?
I did not understand the question
@@RezaDorraniHow to close the cycle after approval?
@@futurestudio7812 I still don’t understand. The status is being updated after approval. Not sure what closing the cycle means.
@@RezaDorraniThat's right. The approval status is being updated. And then it starts all over again. You receive another request for approval.
@@futurestudio7812 every change will be another request. That's how content approval works.
Assign approvals to multiple members at same time and show the details pending vs approval in power automation. This vedio wiill help to some floks
I have done many videos on this. Check approvals Playlist linked in video description
@@RezaDorrani please cross check once you have not done this video. Try to show pending vs approval details when you assign approval for multiple members..
@venkatponnamsnow If you mean a scenario where 1 task is assigned to multiple users and you need to know which users have approved or no, then I have shown it in reminder video where I query dataverse to know which users have not responded. Similar concept can be used to frame your scenario.
Thanks
Welcome
Hello Reza, very good content, I will subscribe and take your courses, I had a question that I am trying to integrate your guides and this permissions option would help me for my quote approval flow, what happens is that I want to send approval requests from 3 suppliers, I need the approver to also view the quote files from Power Apps, I am working with SharePoint document libraries to view it by integrating the view into Power Apps, would it be possible to do it with this method in the video or is it only for the SharePoint and list view?
Looking forward to having you join the courses.
The same permission settings will be respected by power apps as well and the feature is available for doc libraries also. Give it a shot.
@@RezaDorrani Thanks for your quick response, I've been testing it today, I've activated the approval column in sharepoint, but I can't find that column from power apps, that is, it doesn't detect me, it's as if it didn't exist. Is it something I'm doing wrong or is there another method to do it in Power Apps by restricting these permissions for that approval column? or would it be advisable to use approval from the sharepoint interface?
@j0hN13aL I'm not sure what exactly you are trying.
Probably best to post your query on forums in case someone has done something similar community.powerplatform.com/
Hi sir
I have to learn Power apps and Power Automate by your recorded videos
Which club should I buy?
GOLD is the training program
@RezaDorrani
I need to purchase the gold club training program every month right ?
@@shaikhrijwan9322 All memberships are monthly.
Channel membership details
thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=c5EBcvvn3Eg
Thank you for sharing just a modernised method of approval, I tried it but approval button is forwarded to automate page instead of being done inside the email body
Check documentation on supported outlook versions for actionable messaging in emails.
Thank you so much
Can You please post a video where you create a Power automate flow with the trigger "when an item is created or modified"
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hello Raza
When the approver recieve email for approval it say requested by Reza however the item was created by Sarah. Can you please explain.
Thank you!
Flow Owners connection is used for the approvals action. Best Practice: use a service account for approvals connection or use the requested by property in approvals action to define who the requestor is.
@RezaDorrani Thank you!!!
What happens to the approval flow if the approver just goes into sharepoint and approves an item from in the right click menu? Are they integrated and it cancels the automation flow or does the flow sit open until timeout and leave a broken approval request in the power automate pending approvals list?
The approval workflow via flow approvals would be pending. If response if taken by approver on SharePoint, you could check status of approvals in flow and send notifications email.
Hi Reza. On my List, the Approval Status (Content approval one) is automatically "Approved" instead of Pending. How do we change that to show Pending?
Not sure why it would auto-approve. Try following steps shown in the video again.
@@RezaDorrani I did. But still.
You can try downloading the solution and steps shared for silver and gold members
How to allow user to add notes after the item has been Approved? as the message "Applying changes will cancel your request". As I want my project to be Approved, but the user to add project status notes after the approval process?
Any change would trigger the content approval status to pending. I am not aware of any workarounds for that.
@@RezaDorrani ok thanks, do you think this might be achieved by having the approval at a document level rather than a list'?
@@chrisc.8862 content approval works the same regardless
Thanks
Welcome