I love searching for "How to... [something very specific]" and then found out you already made a video about it a year ago! Thank you for this great video.
Reza, you are the MAN!! I can't tell you how many times I've been pondering how to do something and then you post a video explaining it all. I have a deadline about 12 hours away and you just saved my butt!!! Thank you so much for what you do!
Hi from Thailand. Thank you so much for such a great video. Your explanation is everything. I've been started with a zero knowledge for Power Apps, Power Automate and Sharepoint. With your explanation I could go through each step so easily! Keep up an incredible work.
Finally deep linking , Reza you've never made deep linking video...great your channel is becoming one stop shop no need to look anywhere else ...Thank you
@@RezaDorrani Much preferable to take action in the powerapp itself/even for displaying much better , espeiavliy in our env ...could you pls include in future videos some role based views ? like the old info path section ...for eg , in my current req ...i got multiple approvers let's say i don't wanna the 1st approver/supervisor see/edit the 2nd approver's director's section . and vice versa ...i want to lock some fields in the respective of the level of approver , At the time of approving process : 1st approver - show him only his 3 fields/section 2nd approvers (group) -Show them the 1st section in addition to their 3 fields /their section 3rd approver - show him the first 2 section plus his approval fields . Finally 3 approval sections will be displayed to the audience with each 3 approver's disposition and their comments . only they can change/edit those fields /the section . But we want some key players to be able to edit the item itself NOT the approval section ..: thank you reza for being respondant to our questions
There is a lot of great information in this video we can use now. I like the "deep links" discussion to push the user right back to the area in the app where they need to take action. I'm going to integrate that in my apps. Thanks! Great video.
Thanks for teaching all this, I will always pray for your long life and progress, teaching all this for free and helping me do so many things for my project thanks 🎉❤
what an excellent video Reza!! all your videos are literally Gold Mine ..I do share your videos as a reference for others who want to learn on Power Platform in my workshops/trainings. Thank you so much for sharing excellent videos ..
Hi Reza, this is really helpful. what is the reason that all my URL of items are same from gallary? My deep linking has been working, with ID changed everytime generated from power automate emai, but since all URL are same, it does not land to item page. Please advise.
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
Hello Reza, thank you for the video!! Kindly review my questions below: -How do you disable the approver from editing the submitted form when they open the firm to review? -How do you create a *add form* within the submitted form, to enable the approver and the submitter add new form as many times as possible forms to create trail updates just like a CRM or emails trails.
For each of the data cards you do not want approver to edit, check if status is pending and user is approver, if yes then set card mode to view. A form control is only related to one data source. If you need to add more forms and relate then design would be very different from what is showcased in the video. I have done few videos on related lists and Dataverse based.
@@RezaDorrani How would the formula be? I tried to construct this but it does not work. The Displaymode formula for my datacard is: If(!IsBlank(LookUp(Database,Approver.Email = User().Email)),DisplayMode.View,DisplayMode.Edit)
Hi Reza, first thank you for this outstanding video. I duplicated your APP to create an approval APP for my company. Unfortunately, i get issues with creating the Flow. It stucks at the "Get Item" Level. Power Automate says it can't retrieve the ID item.. would you have some advice ?
I have not come across this issue hence not sure would the fix be. I would have to reproduce your issue to know more. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thanks. I did a video on responsive design where I shared the app (link in video description or pinned comment. Check th-cam.com/video/1o2L0DADzKQ/w-d-xo.html
Dorrani Sir, Thank you for the video. I have one question for you please. When i opened Power Automate(15:30 time stamp) , i do not have same fields. I noticed that under Get Items , i have Site address, List name and Limit Entries to Folder instead of ID. Any suggestions how to bring ID as one of the option
Great video Reza. One question at 21:20 if the email assigned to and user.email is not the same, What is the equivalent of print in other progarmming languages in power apps that I can use to print out an error
@RezaDorrani Thank you very much for your reply, much appreciated. So ive figured it out. I want to tell the user that they should use the email that the ticket is 'assigned to' if its not equal using Notify. But in OnStart instead of StartScreen since the former is an action the latter is a property right?
@@djnature1741 Not sure about this. I honestly don’t remember much of this video as it was done a while ago. You may want to get it a try and in case of issues try posting it on forums at powerusers.microsoft.com
Your tutorials are so easy to follow but yet powerful, thank you so much Reza! I have few questions, which you might be able to solve easily: 1) Could you inform, if it also works to put in a team mailbox as the approver (or multiple approvers as alternative)? 2) Is it possible to pull an Excel report for all tasks (regardless of status)? 3) Is it possible to add history to each task (e.g. sent for approval on 03.03.2021; approved on 06.03.2021?) If too complicated, please tell me - I will then try to find some additional training in this regard :)
1 - I don't think it works with team's mailbox. 2 - Possible. You could use flow to query Dataverse Tables for Approvals to get data. 3 - Possible. I have done videos on approval history. th-cam.com/video/lYE7NXTDPJY/w-d-xo.html
@@RezaDorrani for question 1, 16:11 you said you can make this dynamic, based on SharePoint group or ad group. could you point me to the right video you explaining how to do this? I am having a little bit of trouble trying a video of yours that I can use for 16:11. If you could explain that would be a big help.
I have the assigned to field. You can show that in the form. The approver can use that to reassign to another user. You can call the flow from Power Apps once approver reassigns & submits the form. Tracking status & comments - You can create an append comments technique in Power Apps. One of my old videos but still relevant th-cam.com/video/hzLEecSpmFo/w-d-xo.html
Amazing Video Reza... Can you tell me if the edit feature for the Approver works if the Approver and Submitter are the same person. I'm testing my app as the submitter and approver. I receive an email as the approver but when I click the link, I only have edit view. I cannot make updates to the form. Also, it's not taking me to the ticket... It's taking me to the home screen instead.
It should work if Approver and Submitter are the same person. I will have to look at your App in action to know more about your issue & provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hello Reza, thank you for all you do. I am having the same challenge. I noticed that Param(ID) is returning the ID with a quote. (10"). The quote i suppose is from the deep link on Power Automate. How can this be fixed. Thanks again.
Perfect demo, but I am little confused you took that approval action from email and you changed the status and submitted back, after that you went to teams and then again changed the status so, is it overriding the status???
The email has a link to the power app. User had option to take decision either from App or Teams. If decision is taken from Teams it will be reflected in the App. If decision is taken from App, it will not be reflected in Teams (adaptive cards to do not refresh on demand - this feature is coming).
Hi Reza, The videos are very knowledgeable. I am trying to build a similar form to capture project status. One of the requirement is that this form will need to be circulated to various people within the organisation. In order to achieve this, I have created a Sharepoint list which has all questions which needs to go in the project status form. Some of these are radio buttons, and when I open it in Power Apps, this changes to drop downs. Is there a workaround for this? Also, I have been able to populate my SP list based on what I fill in Power Apps form. But when i try to do deep linking, I can see that the URL has the correct ID, but the form when opened has no data populated. Is there something that I'm missing? I have set OnStart and StartScreen properties as mentioned in your tutorial. Sorry if this is too much of questions.
I will have to look at your App in action to provide guidance on your issues. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thanks for your work. I have a question for you, in my app, im using two screen the first one is where i upload the ticket (UploadTicket), and the second one is where i update the status of the ticket (UpdateTicket), if i wanna provide the link of the Ticket to the approver, where i have to set the ID parameter? Because you start the automate flow in OnSucces propriety of your Form, but i dont have the Form, i only have the Upload Button that take "Description", "Approver Email" and the "Attachment" and Run the flow that put that info in sharepoint library and send notification to the approver. Thanks in advance.
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
Thanks Reza, your videos are really amazing!! It would be really helpful if there a way to download the Helpdesk App template demonstrated in this video
Hi Reza, wonderful. Your tips are simply awesome. One question: Can I add an edit button and restart the workflow when it is closed? So when something is changed I get a new notification? The ID of the sharepoint list should remain the same. Kind regards
Reza, great tutorial! My Power Apps looks slightly different and I am stuck on how to add the Power Automate run function into the OnSuccess. Could you assist?
Hi Reza, I am Rehan from UK. You video is supper helpful. I have managed to create the app but on clicking "take action", I am landing to the submitted form page. Any Idea, what I have done wrong? Also the appearance of power app is changed in last two year, I couldn't find the top menu but managed to figure out the way around.
Thanks! 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 Excellent knowledge on your channel immediate sub, Thank you for sharing this videos, In this video 19:22 Lastsubmit is not working for me any suggestion?
It is also not working for me i have 3 screens "HomeScreen, DataScreen,TicketScreen" but when i click on "Take action" it just take me to my HomeScreen and the TicketScreen will not let me add data.
Hi Reza, great video and explanation. I got 2 questions hopefully you can guide me. 1) How to get the approval link to show in the pending dashboard? 2) How to direct user to pending dashboard in email via deep linking? My direction on this is to avoid sending too many email to user. Thus, I will be using reoccurrence flow send weekly to the user instead.
@@RezaDorrani Alright, Thanks. I have another question, Is there a way to change datacard display to edit according to user login when the form is in view mode?
@@angleslie9529 View mode form data cards cannot be made editable (as far as I know). You will need to set form mode to edit and then make data cards read only.
Hello Reza great video than you so much for all that you do on you tube, truly appreciate it, I cant wait to be a member of your channel. I have a question, how do I use the same logic if I want another person to update the record after the initial update has been done? Also I am using SQL as a data source and using patch to submit the form, how do I handle the LastSubmit part?
LastSubmit works with form control and any data source. Patch wont have last submit. You can set a variable when patching to get patch response. Another person info can be maintained in a separate column. Depends upon your scenario.
Hi Reza, thanks for your help! Though, on the send an email part i was not able to edit the code view and give the hyperlink. I guess there are differences in the versions. Could you help me fix this issue.
Most welcome! The video is still accurate and there are no known issues. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, Thanks for the helpful video. I was wondering how this would work if my PowerApps form is broken up across multiple pages. I ran into an error while trying the trigger the workflow on the select of the submit button. How can I fix this?
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@Reza, Great video. Thanks for the video. I am planning to direct the user to a specific screen through an email but when I am setting the parameter to the StartScreen, I am having an error. The "Assigned to" is a table and the "User().Email" is a text. How can I rectify that error.
Your assigned to column is multi select person type hence table. You are comparing it with a text value. It should throw the error :) Look to check if User().Email in Assigned to column value.
amazing reza thank you much for this video, suburb as usual! i liked the idea that in the save button, you called powerautomte from the button rather than using the "when item created or modified in SharePoint" trigger approach, this made me wonder why wont we use this every time? is there any limitation for leveraging PA calls from a button? is it recommended way to use for most cases ?
Glad you liked it! There is no limitation as such. Key differences between trigger flow from power apps vs run flow on item created is: 1 - When power apps calls flow, all flow actions will run under account of user who is running the App. For item created flow trigger, actions run under flow owner account. 2 - Power Apps calling flow - flow is triggered instantly. For item created flow trigger, it can take up to 2 mins for flow to trigger.
Thank you for this great video. I have a question.. am using approval flows to send MS Teams approval and email to the approver once a new request is created. Response from approver (Either in teams or outlook email) will update status in power apps. but what if user approves the request directly in power apps by updating a record.. will it update the Approvals response with same status in MS Teams? Please kindly advise. can we control the Teams approval from power apps? Thank you.
To update directly in power apps, you would need to change approval record details in Dataverse which is not a pattern I recommend. + it will make your power app a premium licenses app. I have not tried this so not sure. You could always try and see if it updates in teams. My guess is it won’t. Regards, Reza
Thanks, Reza! When you say in the end "sometimes Power Apps acts up"... what are the symptoms of this acting up? Which piece is not working or is there an error message?
I had this when i added the flow connection, couldnt get it to launch after if made changes to the data cards, i had to remove the connection to the flow, and add it back again. took me a while to figure out what was going wrong... thank god for the monitor function.
Dear Reza, many thanks for this. Absolutely brilliant! I have followed step by step instruction on this video., however I'm unable to connect my Power Automate flow to Power App. I dont get the drop down on the left life yours, I get a column on my left and nothing happens when I click. Thanks!
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
Reza what you are showing is really exciting and I'm trying to convince the boss we need to implement the powerfull functions that power apps, power automate and sharepoint gives. I'm not a coder, what skill sets should I be looking for to be able to do the code work you demonstrate. Sorry I am a low level nufty. Cheers Tim
Best part about power platform is that it is low code. Basic excel and PowerPoint skills are enough to get started. I would recommend starting form here: aka.ms/powerappsresources
Hi Reza, thanks for this video! Once the form is creeated, will I be able to send an email to the approvers directly from Power Apps using an Outlook365 connector and SendEmailV2 function? Rather than use Flow?
Hey Reza, great video, thanks! I have been working on a form app where on first page I have 2 combobox to fill in names, then that name goes to the form and fills in for Employee Name. That name is coming from a sql db that is connected with other data about the employee so I have them in the form to be auto filled but after i submit the form and get the deep link. The link shows the first first name on the list in sql db, it doesn't keep the name that i selected on the boxes. Any idea what I am doing wrong to get the first name on the list to appear? Thanks for your help!
I will have to look at your App in action to learn more about the exact formulas in play & provide guidance. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, your videos are valuable as always, I have some queries regarding 1-can the adaptive card be sent to email instead of the Microsoft team so the action will be handled through outlook! 2-let us say I have an approve button on the approval ticket screen, on the select property there is a huge code to be rune once I click approve can the adaptive card handle such a case! Thank you
1 - Yes. However, the process is very different. I have that as a video idea in my backlog. 2- All that code would have to be handled in flow once the adaptive card response is received.
I have a question please, How to only show specific tickets in the gallery based on their status? Similar to the buttons on the left in your video. Also, absolutely fantastic tutorial Reza. Thank you!!
Hi Reza - is it feasible for this workflow to be combined with the multiflow approvals in your other videos? Which part is the most important to change/adapt for this to work with multiple approvers? Also, the flow does not work for me if the Sharepoint approval list is selected as person (even tho it is not multi select), and only works if it's single line of text.
Idea of this video was custom approval forms and approval decisions directly within Power Apps. It does not use power automate approvals. If wanting to make this work with flow approvals, all decisions would need to be taken outside of App context + no option for custom approval forms as of today. As for your issue, I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you for sharing this amazing video. I have a question - Does the deep linking works if I clicked the link from my outlook mobile device including taking me directly to the application based on the specific record id?
Hi Reza, Great video. I will definitely be using adaptive cards. Quick question, were you able to set the "Assigned to" field to null? I tried to do this in the past but failed. I believe the only way to do this with using an http request?
Hey Reza, this was again another awesome and applicable illustration. I was able to put together 80% of this in my use case however the challenge I have is updating my SharePoint with the approval decision made by the approver in the App itself. I didn't use the Teams adaptive card option. When I click on save after the approver decision it creates a duplicate record in my SharePoint list. Also when I add the Get Manager connector in my flow many times I get a warning about the possibility of breaking the flow. Any advice would be greatly appreciated.
Depends on how you have updated the item. Patch function then you may have not referenced the existing item. Form control then may be your Item property is not set correctly. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com When you update a flow that is connected to power apps, you have to go back to power app and update the flow connection.
@@RezaDorrani is there a way to have on your Ticket Screen for example the ability to update a Collection and also use the varItem variable in the same Items property field of the table. In my case I have an Edit Form and a Gallery that I made into repeating table that support each other on the same screen. Basically the Form captures general info and the Gallery collects line item specifics about the request.
Great work Reza.! Quick question: How i can assign approval to multiple users or group listed in share point item (multiple people picker or single line text with list of multiple users). And would like to see who approved it and list of pending users on the adaptive card. .?
Hi Reza! I am watching your video and It's amazing. I want to know why you are using variables only to use one form in the Power Apps aplications. I'm intrigued because I want to know if you do it because it is the best way or if there is another reason behind it. Thanks you so much for your content.
Hi Reza, great video. Thank you for sharing. I followed all the steps but my challenge is approvers are directed to view mode instead of edit and check boxes are not cleared even when I am clearing the collection onvisible of the new form.
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
Reza my greatest teacher for power platform! Thanks for your sharing, a question about approval: I have over 50 Teams approval requests everyday and struggling on approve them one by one, any way in Power Automate / Power Apps can detect which one is processing and enable one-click approve action?
Thank you for your detailed steps. However, how do you set user access in the Sharepoint list? If we want users to only see the requests submitted on their own, the approver should see the requests only submitted to them.
You can do that in 2 ways. Create filters in power apps so users can only see items they have requested or an approver for. Or you could set item permissions in SharePoint (my recent videos shows this).
Hi Reza... Thanks for your knowledge. this view was very helpful to develop an application. I have a doubt it's possible to create a button on the PowerApps form to allow the user Approve or Reject if the current user logged it's the responsible to execute the action? The user wants to open the form a execute the action directly on the form not in Teams or Cards.
@@RezaDorrani I saw the video but it can not answer my doubt. This is my scenery, we have a power apps form with multiple information (fields) when the originator fill in all the required field, he presses the submit button, this action starts a Power Automate flow with multiple approvers. We used Cards to Approve or Reject because some approvers should incorporate additional information of the process. Some approvers wants to approve the pending task directly from teams (Cards functionality) but others wants to open the form and execute the action directly on the form. My doubt is, if the Power Automate flow is waiting for some action to continue (Teams provide this trigger) with the next approvers, how we develop an action or button to run this trigger from the form.
@@juancarloshidalgo8121 I will have to try out your scenario to provide guidance. I will recommend posting your use case with screenshots on the forums at powerusers.microsoft.com in case someone has done something similar
Hello Reza, as you might be aware that I am trying to build a multiple approver solution based on your various informative tutorials. I was wondering if you have any scenario where through adaptive card we can show approval decision status from multiple users?
I do not have a video reference on this scenario. My brain says it’s possible but something I would have to try out to know how. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@@MehediNahian did you find an answer to your question? I have this same scenario. I'm needing this to go to multiple people to approve in the Teams Power Automate Approval. If so, can you provide me a link?
I really like your fantastic video Reza! I have trouble with deep linking multiple approvers (Person or Groups in Sharepoint list) to a specific ticket, and the error shows that "These types can't be compared: Table, Text". And here is the code "If(!IsBlank(Param("ID")) && LookUp('Test list',ID=Value(Param("ID"))).'Product Reviewers'=User().Email,Form1,Home) " how can I fix it with correct syntax?
Hi Reza, great video. Thank you so much. I have a query, there are default save and cancel in the new item form. Is there any way to remove those because after setting the onsuccess property the form does not get submitted.
Hi Reza, thank you for the amazing video. I am working on a Power Platform system that doesn't allow Adaptive Cards. How can I mimic the adaptive card experience for an approval workflow (asking additional questions to multiple approvers throughout the workflow) in Power Apps or Power Automate?
@@RezaDorrani I only see the "Post card in a chat or channel" & "Reply with adaptive card in a channel", but not "Post adaptive card and wait for response". I assume this is because I am on a GOV instance of Power Platform. Any ideas on workarounds?
Another masterpiece. So much to unplug so have to watch again and try to replicate. Thanks for Sharing
Wow, Thank You!
I love searching for "How to... [something very specific]" and then found out you already made a video about it a year ago! Thank you for this great video.
Most welcome and so glad to hear the videos (even older ones) are useful
Reza, you are the MAN!! I can't tell you how many times I've been pondering how to do something and then you post a video explaining it all. I have a deadline about 12 hours away and you just saved my butt!!! Thank you so much for what you do!
You are most welcome!
APPRECIATE IT!!!
Hi from Thailand. Thank you so much for such a great video. Your explanation is everything. I've been started with a zero knowledge for Power Apps, Power Automate and Sharepoint. With your explanation I could go through each step so easily! Keep up an incredible work.
Wonderful! Thank You so much for watching & liking my videos 🙏
Finally deep linking , Reza you've never made deep linking video...great your channel is becoming one stop shop no need to look anywhere else ...Thank you
I will probably do a more detailed deep linking video in future.
Deep linking into Apps, Teams based Apps, Teams messages and more.
@@RezaDorrani PLEASE
@@RezaDorrani Much preferable to take action in the powerapp itself/even for displaying much better , espeiavliy in our env ...could you pls include in future videos some role based views ? like the old info path section ...for eg , in my current req ...i got multiple approvers let's say i don't wanna the 1st approver/supervisor see/edit the 2nd approver's director's section . and vice versa ...i want to lock some fields in the respective of the level of approver ,
At the time of approving process :
1st approver - show him only his 3 fields/section
2nd approvers (group) -Show them the 1st section in addition to their 3 fields /their section
3rd approver - show him the first 2 section plus his approval fields .
Finally 3 approval sections will be displayed to the audience with each 3 approver's disposition and their comments .
only they can change/edit those fields /the section .
But we want some key players to be able to edit the item itself NOT the approval section ..:
thank you reza for being respondant to our questions
@@yehunlavolontededieu322 My plan was to include some stuff around role based deep linking.
It very good sharing.
Thank you! Cheers!
So much dedication while explaining, feels like watching it again and again!! Crystal clear explanation!! Thank you very much sir!!
Most welcome and thanks so much for the appreciation
U r welcome sir 😊
This is very useful video. Something new i learnt today...Specially the Adaptive card one....Thanks.....Keep Sharing....
Glad to hear the feedback. Thank You for watching.
There is a lot of great information in this video we can use now. I like the "deep links" discussion to push the user right back to the area in the app where they need to take action. I'm going to integrate that in my apps. Thanks! Great video.
Glad it was helpful! Thank You for watching.
Awesome video. Idk why TH-cam didn't recommend me your video before. Thank you for sharing your valuable knowledge.
Thanks Pritam.
Helped alot. Thanks Buddy. You kept it simple and achieved the task complexity with simplicity.
Great to hear! Thanks for watching
Excellent video! Very clear instructions
Thank you!
Reza, i've learned so much from you and your content, thank you so much for being a great teacher!
My pleasure!
Thanks for teaching all this, I will always pray for your long life and progress, teaching all this for free and helping me do so many things for my project thanks 🎉❤
Thank You so much Maaz
what an excellent video Reza!! all your videos are literally Gold Mine ..I do share your videos as a reference for others who want to learn on Power Platform in my workshops/trainings. Thank you so much for sharing excellent videos ..
Awesome, thank you Aroh!
This is awesome Reza. Really help and intuitive.
Going to test this out tomorrow, specifically Adaptive cards. Great work mate.
Thank You. The Adaptive Cards component was enjoyable to build. I plan to do an introduction video series on it.
@@RezaDorrani that would be great. Thanks
Good..Nice Learning Videos.
Thanks Pannir
Brilliant, I can think of atleast 10 places to use this :)
Thanks Reza. Much appreciated.
Perfect!
Wow! Great tutorial video. Thank you for sharing, Reza!
Thank You for watching
Hi Reza, this is really helpful. what is the reason that all my URL of items are same from gallary? My deep linking has been working, with ID changed everytime generated from power automate emai, but since all URL are same, it does not land to item page. Please advise.
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
Thanls for sharing! Very informative!
Most welcome
Hello Reza, thank you for the video!!
Kindly review my questions below:
-How do you disable the approver from editing the submitted form when they open the firm to review?
-How do you create a *add form* within the submitted form, to enable the approver and the submitter add new form as many times as possible forms to create trail updates just like a CRM or emails trails.
For each of the data cards you do not want approver to edit, check if status is pending and user is approver, if yes then set card mode to view.
A form control is only related to one data source. If you need to add more forms and relate then design would be very different from what is showcased in the video.
I have done few videos on related lists and Dataverse based.
@@RezaDorrani How would the formula be? I tried to construct this but it does not work. The Displaymode formula for my datacard is: If(!IsBlank(LookUp(Database,Approver.Email = User().Email)),DisplayMode.View,DisplayMode.Edit)
Reza, you are outstanding, i have made money from customers watching your demo, I wish to work with you one day
👍
Reza , you are the man. Thank you very much for video.
Most welcome
Wow you are awesome thank you I managed to follow your video to create my version of this power app 😎🙌
Great 👍
Hi Reza, first thank you for this outstanding video. I duplicated your APP to create an approval APP for my company. Unfortunately, i get issues with creating the Flow. It stucks at the "Get Item" Level. Power Automate says it can't retrieve the ID item.. would you have some advice ?
I have not come across this issue hence not sure would the fix be. I would have to reproduce your issue to know more. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
This is a great build. Alot of great info!
Thanks
Thank you Reza. So much great content to learn in here.
Thanks so much for watching
Thank u Reza give ur most valuable time for this session , thanks lot
Thank You for watching
What a learning experience!!! Thank you so much..
Most welcome
Very very Useful
Great Job
Thanks a lot Man
Glad it was helpful!
Great work man. Thank you!
Most welcome
Wonderful piece of code. Keep up the good work mate and thanks for sharing...
Thank You!
I love the look and feel of this app! How did you get the awesome blue boxes in the Help Desk App screen?
Thanks.
I did a video on responsive design where I shared the app (link in video description or pinned comment. Check th-cam.com/video/1o2L0DADzKQ/w-d-xo.html
@@RezaDorraniThank you! 🎉
Thanks a lot, this really helpful for me 🎉❤
Most welcome
Awesome and brilliant 👍👍
Thank you! Cheers!
Dorrani Sir, Thank you for the video. I have one question for you please. When i opened Power Automate(15:30 time stamp) , i do not have same fields. I noticed that under Get Items , i have Site address, List name and Limit Entries to Folder instead of ID. Any suggestions how to bring ID as one of the option
You need to use "Get Item" and not "Get items"
@@RezaDorrani Thank you!!
Many Thanks To You😊! Great Video 🙌
Thank You
Reza, you are the best!!!!!!!!
Thank You!
Great video Reza. One question at 21:20 if the email assigned to and user.email is not the same,
What is the equivalent of print in other progarmming languages in power apps that I can use to print out an error
I responded to the print question in another comment
@RezaDorrani Thank you very much for your reply, much appreciated.
So ive figured it out. I want to tell the user that they should use the email that the ticket is 'assigned to' if its not equal using Notify.
But in OnStart instead of StartScreen since the former is an action the latter is a property right?
@@djnature1741 Not sure about this. I honestly don’t remember much of this video as it was done a while ago. You may want to get it a try and in case of issues try posting it on forums at powerusers.microsoft.com
Great one Reza :)
Thanks
Your tutorials are so easy to follow but yet powerful, thank you so much Reza! I have few questions, which you might be able to solve easily:
1) Could you inform, if it also works to put in a team mailbox as the approver (or multiple approvers as alternative)?
2) Is it possible to pull an Excel report for all tasks (regardless of status)?
3) Is it possible to add history to each task (e.g. sent for approval on 03.03.2021; approved on 06.03.2021?)
If too complicated, please tell me - I will then try to find some additional training in this regard :)
1 - I don't think it works with team's mailbox.
2 - Possible. You could use flow to query Dataverse Tables for Approvals to get data.
3 - Possible. I have done videos on approval history. th-cam.com/video/lYE7NXTDPJY/w-d-xo.html
@@RezaDorrani Awesome, thanks a lot Reza! :)
@@RezaDorrani for question 1, 16:11 you said you can make this dynamic, based on SharePoint group or ad group. could you point me to the right video you explaining how to do this? I am having a little bit of trouble trying a video of yours that I can use for 16:11. If you could explain that would be a big help.
@@davidcortes9326 I have done multiple videos on dynamic approvers. You can check my approvals playlist.
Thanks Reza!!
Is it possible to reassign task and track the approval status/comments in this approach?
I have the assigned to field. You can show that in the form. The approver can use that to reassign to another user.
You can call the flow from Power Apps once approver reassigns & submits the form.
Tracking status & comments - You can create an append comments technique in Power Apps. One of my old videos but still relevant th-cam.com/video/hzLEecSpmFo/w-d-xo.html
I have the same question. I'll study video.
Thank you very much Reza.👌
Always welcome
Notice that Reza did not "deep link" to the ID in PowerApps inside a Teams app. This was done to a common standard PowerApp.
Good observation:)
Amazing Video Reza... Can you tell me if the edit feature for the Approver works if the Approver and Submitter are the same person. I'm testing my app as the submitter and approver. I receive an email as the approver but when I click the link, I only have edit view. I cannot make updates to the form. Also, it's not taking me to the ticket... It's taking me to the home screen instead.
It should work if Approver and Submitter are the same person.
I will have to look at your App in action to know more about your issue & provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hello Reza, thank you for all you do. I am having the same challenge. I noticed that Param(ID) is returning the ID with a quote. (10"). The quote i suppose is from the deep link on Power Automate. How can this be fixed. Thanks again.
This is now fixed. I realized I missed the first quote in the deep link in Power Automate. Works like a charm now. Thanks Chief.
Amazing, thanks for sharing it.
Thanks for watching
I have a question, on @23:06 you added a ticket but the status was not updated there? what was the problem? and how did you set it?
Its been over a year since I made this video. I do not remember how the status gets updated. Ideally it should have set status when item was created.
Perfect demo, but I am little confused you took that approval action from email and you changed the status and submitted back, after that you went to teams and then again changed the status so, is it overriding the status???
The email has a link to the power app.
User had option to take decision either from App or Teams.
If decision is taken from Teams it will be reflected in the App.
If decision is taken from App, it will not be reflected in Teams (adaptive cards to do not refresh on demand - this feature is coming).
@@RezaDorrani oh Thanks ♥️.
Well I have to develop exactly like that
Hi Reza, The videos are very knowledgeable. I am trying to build a similar form to capture project status. One of the requirement is that this form will need to be circulated to various people within the organisation. In order to achieve this, I have created a Sharepoint list which has all questions which needs to go in the project status form. Some of these are radio buttons, and when I open it in Power Apps, this changes to drop downs. Is there a workaround for this?
Also, I have been able to populate my SP list based on what I fill in Power Apps form. But when i try to do deep linking, I can see that the URL has the correct ID, but the form when opened has no data populated. Is there something that I'm missing? I have set OnStart and StartScreen properties as mentioned in your tutorial.
Sorry if this is too much of questions.
I will have to look at your App in action to provide guidance on your issues. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you so much for your prompt response. I've got this now sorted.
Hi Reza, thanks for your work. I have a question for you, in my app, im using two screen the first one is where i upload the ticket (UploadTicket), and the second one is where i update the status of the ticket (UpdateTicket), if i wanna provide the link of the Ticket to the approver, where i have to set the ID parameter? Because you start the automate flow in OnSucces propriety of your Form, but i dont have the Form, i only have the Upload Button that take "Description", "Approver Email" and the "Attachment" and Run the flow that put that info in sharepoint library and send notification to the approver.
Thanks in advance.
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 .. thank you
Thanks for watching.
Good video, really helpful
if there any link to make the first page (the one with the status in left)?
Thank you
Welcome!
I have probably done a video on it but do not remember which.
Hi Reza thanks for sharing knowledge. Quick question can we use this form for more that 5000 item list ?
Yes, you can. As long as delegation is handled. Check my playlist on delegation.
It’s useful for me ... many thanks
👍
I will be shamelessly copying this, thank you!
Go for it. Thanks for trying it out :)
Thanks Reza, your videos are really amazing!! It would be really helpful if there a way to download the Helpdesk App template demonstrated in this video
Welcome!
I did this video a long while ago and no longer have access to that app.
Hi Reza,
wonderful. Your tips are simply awesome. One question: Can I add an edit button and restart the workflow when it is closed? So when something is changed I get a new notification? The ID of the sharepoint list should remain the same.
Kind regards
Yes, you can surely do that. Not something I have tried though :)
Reza, great tutorial! My Power Apps looks slightly different and I am stuck on how to add the Power Automate run function into the OnSuccess. Could you assist?
I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I am Rehan from UK. You video is supper helpful. I have managed to create the app but on clicking "take action", I am landing to the submitted form page. Any Idea, what I have done wrong? Also the appearance of power app is changed in last two year, I couldn't find the top menu but managed to figure out the way around.
Thanks!
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 Excellent knowledge on your channel immediate sub, Thank you for sharing this videos,
In this video 19:22 Lastsubmit is not working for me any suggestion?
Thanks for the sub!
LastSubmit is a form feature that returns last submitted item data. Not sure why it would not work for you.
It is also not working for me i have 3 screens "HomeScreen, DataScreen,TicketScreen" but when i click on "Take action" it just take me to my HomeScreen and the TicketScreen will not let me add data.
@@djboob66 I would recommend posting the issue on forums as I have not experienced the same.
powerusers.microsoft.com/
@user-yv3vr1nk8e If you have any luck with a fix can you post the answer here please .
Hi Reza, great video and explanation.
I got 2 questions hopefully you can guide me.
1) How to get the approval link to show in the pending dashboard?
2) How to direct user to pending dashboard in email via deep linking?
My direction on this is to avoid sending too many email to user. Thus, I will be using reoccurrence flow send weekly to the user instead.
1) th-cam.com/video/d4e1whKVJU4/w-d-xo.html
2) Deep linking is shown in this video itself.
@@RezaDorrani Alright, Thanks.
I have another question, Is there a way to change datacard display to edit according to user login when the form is in view mode?
@@angleslie9529 View mode form data cards cannot be made editable (as far as I know). You will need to set form mode to edit and then make data cards read only.
Excelent work! I try to adapt in my secnario and I cound't, this only works in premium licence?
There is no premium connector used. Not sure what other connectors you are using in your app.
Great tutorial!
Thank You
Hello Reza great video than you so much for all that you do on you tube, truly appreciate it, I cant wait to be a member of your channel. I have a question, how do I use the same logic if I want another person to update the record after the initial update has been done? Also I am using SQL as a data source and using patch to submit the form, how do I handle the LastSubmit part?
LastSubmit works with form control and any data source. Patch wont have last submit.
You can set a variable when patching to get patch response.
Another person info can be maintained in a separate column. Depends upon your scenario.
Hi Sir. @Reza do you have a video regarding the Form you use?
I have done multiple videos on form control.
Hi Reza, thanks for your help!
Though, on the send an email part i was not able to edit the code view and give the hyperlink. I guess there are differences in the versions. Could you help me fix this issue.
Most welcome!
The video is still accurate and there are no known issues.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thanks@@RezaDorrani, it was resolved. Switched to classic designer in the flow.
Hi Reza, Thanks for the helpful video. I was wondering how this would work if my PowerApps form is broken up across multiple pages. I ran into an error while trying the trigger the workflow on the select of the submit button. How can I fix this?
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
For context I use a patch function to submit my form to my data source
@@taniamathew9354 Flow can be called from any scenario. I would recommend posting your issue on forums.
@Reza, Great video. Thanks for the video. I am planning to direct the user to a specific screen through an email but when I am setting the parameter to the StartScreen, I am having an error. The "Assigned to" is a table and the "User().Email" is a text. How can I rectify that error.
Your assigned to column is multi select person type hence table. You are comparing it with a text value. It should throw the error :)
Look to check if User().Email in Assigned to column value.
amazing reza thank you much for this video, suburb as usual! i liked the idea that in the save button, you called powerautomte from the button rather than using the "when item created or modified in SharePoint" trigger approach, this made me wonder why wont we use this every time? is there any limitation for leveraging PA calls from a button? is it recommended way to use for most cases ?
Glad you liked it!
There is no limitation as such.
Key differences between trigger flow from power apps vs run flow on item created is:
1 - When power apps calls flow, all flow actions will run under account of user who is running the App.
For item created flow trigger, actions run under flow owner account.
2 - Power Apps calling flow - flow is triggered instantly.
For item created flow trigger, it can take up to 2 mins for flow to trigger.
@@RezaDorrani thanks reza this clear thank you !
Thank you for this great video. I have a question.. am using approval flows to send MS Teams approval and email to the approver once a new request is created. Response from approver (Either in teams or outlook email) will update status in power apps. but what if user approves the request directly in power apps by updating a record.. will it update the Approvals response with same status in MS Teams? Please kindly advise. can we control the Teams approval from power apps? Thank you.
To update directly in power apps, you would need to change approval record details in Dataverse which is not a pattern I recommend.
+ it will make your power app a premium licenses app.
I have not tried this so not sure. You could always try and see if it updates in teams. My guess is it won’t.
Regards,
Reza
@@RezaDorrani Thank you for ur reply.
Thanks, Reza! When you say in the end "sometimes Power Apps acts up"... what are the symptoms of this acting up? Which piece is not working or is there an error message?
If you add additional connectors in the flow and do not re-associate the flow in Power Apps, it throws an error of inconsistent schema.
I had this when i added the flow connection, couldnt get it to launch after if made changes to the data cards, i had to remove the connection to the flow, and add it back again. took me a while to figure out what was going wrong... thank god for the monitor function.
Thank you very much!
Most welcome!
Dear Reza, many thanks for this. Absolutely brilliant! I have followed step by step instruction on this video., however I'm unable to connect my Power Automate flow to Power App. I dont get the drop down on the left life yours, I get a column on my left and nothing happens when I click. Thanks!
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
Reza what you are showing is really exciting and I'm trying to convince the boss we need to implement the powerfull functions that power apps, power automate and sharepoint gives. I'm not a coder, what skill sets should I be looking for to be able to do the code work you demonstrate. Sorry I am a low level nufty. Cheers Tim
Best part about power platform is that it is low code. Basic excel and PowerPoint skills are enough to get started.
I would recommend starting form here: aka.ms/powerappsresources
Brilliant 👍
Thank You
Hi Reza, thanks for this video! Once the form is creeated, will I be able to send an email to the approvers directly from Power Apps using an Outlook365 connector and SendEmailV2 function? Rather than use Flow?
You could send email but here I am using adaptive cards to create an approval form for the user. We need flow for that.
Amazing once again
Thank you! Cheers!
Hey Reza, great video, thanks! I have been working on a form app where on first page I have 2 combobox to fill in names, then that name goes to the form and fills in for Employee Name. That name is coming from a sql db that is connected with other data about the employee so I have them in the form to be auto filled but after i submit the form and get the deep link. The link shows the first first name on the list in sql db, it doesn't keep the name that i selected on the boxes. Any idea what I am doing wrong to get the first name on the list to appear?
Thanks for your help!
I will have to look at your App in action to learn more about the exact formulas in play & provide guidance. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Hi Reza! Wondering if you plan to share this on your Git repos at some point. Thanks
I do not since this video was done a long time ago and I tend to reuse lists, flows etc. I no longer have the original version.
Hi Reza, your videos are valuable as always, I have some queries regarding
1-can the adaptive card be sent to email instead of the Microsoft team so the action will be handled through outlook!
2-let us say I have an approve button on the approval ticket screen, on the select property there is a huge code to be rune once I click approve
can the adaptive card handle such a case!
Thank you
1 - Yes.
However, the process is very different. I have that as a video idea in my backlog.
2- All that code would have to be handled in flow once the adaptive card response is received.
@@RezaDorrani Thank you for the reply , that what i expected
I have a question please,
How to only show specific tickets in the gallery based on their status? Similar to the buttons on the left in your video.
Also, absolutely fantastic tutorial Reza. Thank you!!
I have done multiple videos on gallery filtering.
Hi Raza...i wanna learn power apps from begging to end do u have any sequence of classes is there or kind of syllabus flows ?
Not yet. Im working on a training portal. Will take some time.
Check channel memberships. I have gone live with a training tier that you can sign up for now.
th-cam.com/users/rezadorranijoin
Hi Reza - is it feasible for this workflow to be combined with the multiflow approvals in your other videos? Which part is the most important to change/adapt for this to work with multiple approvers?
Also, the flow does not work for me if the Sharepoint approval list is selected as person (even tho it is not multi select), and only works if it's single line of text.
Idea of this video was custom approval forms and approval decisions directly within Power Apps. It does not use power automate approvals.
If wanting to make this work with flow approvals, all decisions would need to be taken outside of App context + no option for custom approval forms as of today.
As for your issue, I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you for sharing this amazing video. I have a question - Does the deep linking works if I clicked the link from my outlook mobile device including taking me directly to the application based on the specific record id?
Yes it does!
Hi Reza, Great video. I will definitely be using adaptive cards.
Quick question, were you able to set the "Assigned to" field to null? I tried to do this in the past but failed. I believe the only way to do this with using an http request?
Assigned to field of type text. I was able to set it to null using expression null.
Hey Reza, this was again another awesome and applicable illustration. I was able to put together 80% of this in my use case however the challenge I have is updating my SharePoint with the approval decision made by the approver in the App itself. I didn't use the Teams adaptive card option. When I click on save after the approver decision it creates a duplicate record in my SharePoint list. Also when I add the Get Manager connector in my flow many times I get a warning about the possibility of breaking the flow. Any advice would be greatly appreciated.
Depends on how you have updated the item. Patch function then you may have not referenced the existing item. Form control then may be your Item property is not set correctly. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
When you update a flow that is connected to power apps, you have to go back to power app and update the flow connection.
@@RezaDorrani is there a way to have on your Ticket Screen for example the ability to update a Collection and also use the varItem variable in the same Items property field of the table. In my case I have an Edit Form and a Gallery that I made into repeating table that support each other on the same screen. Basically the Form captures general info and the Gallery collects line item specifics about the request.
@@nohpetsrs I would say possible but something that I would have to try out and explore. Might have to use patch function to help.
Great work Reza.!
Quick question: How i can assign approval to multiple users or group listed in share point item (multiple people picker or single line text with list of multiple users).
And would like to see who approved it and list of pending users on the adaptive card. .?
I have done videos on assigning multiple approvers. Check my approvals playlist th-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
@@RezaDorrani thank you Reza. You are simply awesome bud.!
Hi Reza!
I am watching your video and It's amazing. I want to know why you are using variables only to use one form in the Power Apps aplications. I'm intrigued because I want to know if you do it because it is the best way or if there is another reason behind it. Thanks you so much for your content.
Reason is for deep linking to form + avoiding control dependency between screens (Watch th-cam.com/video/_2jDGqtqqi8/w-d-xo.html)
Hi Reza, great video. Thank you for sharing. I followed all the steps but my challenge is approvers are directed to view mode instead of edit and check boxes are not cleared even when I am clearing the collection onvisible of the new form.
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
Reza my greatest teacher for power platform! Thanks for your sharing, a question about approval: I have over 50 Teams approval requests everyday and struggling on approve them one by one, any way in Power Automate / Power Apps can detect which one is processing and enable one-click approve action?
Approval action currently only supports 1 by 1 approval.
Thank you for your detailed steps. However, how do you set user access in the Sharepoint list? If we want users to only see the requests submitted on their own, the approver should see the requests only submitted to them.
You can do that in 2 ways.
Create filters in power apps so users can only see items they have requested or an approver for.
Or you could set item permissions in SharePoint (my recent videos shows this).
Hey Reza, This is awesome. Something i was looking for. I was just wondering if you have any sample app available on git for this.
Thanks.
No sample app for this on GitHub.
@@RezaDorrani - Thank you so much for quick response ..
Hi Reza... Thanks for your knowledge. this view was very helpful to develop an application. I have a doubt it's possible to create a button on the PowerApps form to allow the user Approve or Reject if the current user logged it's the responsible to execute the action? The user wants to open the form a execute the action directly on the form not in Teams or Cards.
Its a part of the video itself. If user is the person who should execute the action the approval section in the form will light up for that user.
@@RezaDorrani I saw the video but it can not answer my doubt. This is my scenery, we have a power apps form with multiple information (fields) when the originator fill in all the required field, he presses the submit button, this action starts a Power Automate flow with multiple approvers. We used Cards to Approve or Reject because some approvers should incorporate additional information of the process. Some approvers wants to approve the pending task directly from teams (Cards functionality) but others wants to open the form and execute the action directly on the form. My doubt is, if the Power Automate flow is waiting for some action to continue (Teams provide this trigger) with the next approvers, how we develop an action or button to run this trigger from the form.
@@juancarloshidalgo8121 I will have to try out your scenario to provide guidance. I will recommend posting your use case with screenshots on the forums at powerusers.microsoft.com in case someone has done something similar
Hello Reza, as you might be aware that I am trying to build a multiple approver solution based on your various informative tutorials. I was wondering if you have any scenario where through adaptive card we can show approval decision status from multiple users?
I do not have a video reference on this scenario. My brain says it’s possible but something I would have to try out to know how. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani Thank you, I will check.
@@MehediNahian did you find an answer to your question? I have this same scenario. I'm needing this to go to multiple people to approve in the Teams Power Automate Approval. If so, can you provide me a link?
I really like your fantastic video Reza! I have trouble with deep linking multiple approvers (Person or Groups in Sharepoint list) to a specific ticket, and the error shows that "These types can't be compared: Table, Text". And here is the code "If(!IsBlank(Param("ID")) && LookUp('Test list',ID=Value(Param("ID"))).'Product Reviewers'=User().Email,Form1,Home) " how can I fix it with correct syntax?
You are looking in a multi select column. You would need to use the in function.
I have seen examples of this on forums powerusers.microsoft.com
@@RezaDorrani Thank you for your quick response！
I too have same error . Did you fix it. if yes please tell me how.
Hi Reza, great video. Thank you so much. I have a query, there are default save and cancel in the new item form. Is there any way to remove those because after setting the onsuccess property the form does not get submitted.
Seems you are using sharepoint list forms. I am not aware of an option to remove those.
Thanks a lot for the tutorial Reza!
I just got on problem, when receiving the email I only have the view mode so cant edit
You have view mode in email? I did not understand your question
Hi Reza, thank you for the amazing video. I am working on a Power Platform system that doesn't allow Adaptive Cards. How can I mimic the adaptive card experience for an approval workflow (asking additional questions to multiple approvers throughout the workflow) in Power Apps or Power Automate?
Approval flows also use adaptive cards so not sure how it is not allowed
@@RezaDorrani I only see the "Post card in a chat or channel" & "Reply with adaptive card in a channel", but not "Post adaptive card and wait for response". I assume this is because I am on a GOV instance of Power Platform. Any ideas on workarounds?
@@dannya.5812 Im not sure about GOV instance. I will recommend checking on forums powerusers.microsoft.com/
Absolute Amazing
👍