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
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 🎉❤
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.
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)
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 ..
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. ua-cam.com/video/lYE7NXTDPJY/v-deo.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.
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.
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
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
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
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.
Thanks. I did a video on responsive design where I shared the app (link in video description or pinned comment. Check ua-cam.com/video/1o2L0DADzKQ/v-deo.html
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
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?
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, 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!!
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 ua-cam.com/video/hzLEecSpmFo/v-deo.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
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?
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, 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
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
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).
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
At about 1900 in the video you add the flow in the onsuccess property but you can no longer do it this way it appears since there is no longer and action bar, however you can add the formula in and everything works as intended
Hi Reza, First of all, your videos are really informative. I actually learned PowerApps and Automate watching your video. Thanks alot The issue I am facing here is, I am not using a form but controls on the screen for some reason. These controls includes attachment control also. Using this approach, I am not able to bring the attachment from list item. however, When I select galley, I can access the attachments by Gallery.Attachments... . Any workaround?
Further Explanation: I am trying the same scenario as in the video. Opening powerapps item from email link. and I am not able to get the attachments for the item
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
Difficult to provide guidance on chat for specific issues. I will recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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
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
Hi, Firstly, thanks for such a helpful knowledge you shared. I am fresh in Power Apps. For learning purpose I want to process the Shipping Container Number. It is request to would you please check the images and guide me, how I will extract the Shipping container number from the images ? I will be very thankful to you
@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.
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).
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.
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
Thank you Reza. I am a power BI Developer and started learning Power apps. Your videos helps a lot to gain knowledge about features of power apps and its use cases with power automate. I tried creating the similar app but there is an issue. when approver clicks "Take action" on the email notification, it opens in view mode. event though I've updated the start screen and onstart functions. What could be the possible issues.
You’re most welcome! I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
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.
I love this, thanks so much. The only problem I have is when I need to edit the email; for some reason power automate cannot convert it back to HTML view without adding garbage and breaking the link :/
That is a known bug since a long time. An option would be to add a compose action before send email action. Plug your html in there and then use output if compose action in email body.
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.
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
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
Hi Reza, one question, I have worked with a similar app but it takes too long to load, what can i do in order to improve the performance? Great video as Always!!!! btw
Hi Reza, thanks much for creating such a useful content which gives a beginner like me a lot of confidence to do forms in Power Apps. I have tried in creating approval form in Power Apps. I can send an email to approvers but cannot open the specific form related to their department. Can you show me insight on how do I let the approvers to open the direct link of form in power Apps and submit their responses, here I have created multiple approval forms in specific to different departments. and parallelly everyone must approve. So in this scenario , I want all the approvers to open their respective form (ex, HR, Power, Signaling etc.)directly when click on link and update the field approve/ reject and submit .
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
I had faced some errors with the previous formula, but I was able to resolve them by using a new formula: Set(varFormMode;FormMode.View);;Set(varItem;ThisItem);;Navigate(Request) It worked for me, and I hope it helps you as well!
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?
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?
I would change the flow approval to include those 2 approvers either in same action or serially depending upon the use case. I have done several videos on approvals. Check ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
I would change the flow approval to include those 2 approvers either in same action or serially depending upon the use case. I have done several videos on approvals. Check ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
@@RezaDorrani I suppose it could work serially as well seeing as if one of the approvers were to reject it, the request would be declined. I'll give it a go.
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 Sir, I would say that I'm a fan of all of your video and I learned a lot. I made a sample power apps application and everything is fine however there is one thing I can't figure out on how to filter all the submitted tickets of those user's (ie. userA and userB) under me (ie. supervisorA) by the way I have person field(for user who submitted the ticket) in my Sharepoint lists. hope I did not confuse you with my question :) Thank you
I am confused :) 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
Thank you for your reply. I think what I'm trying to achieve is the Office365Users.DirectReporting... I want to filter out the user's ticket direct reporting to me.
Morning Reza Could you please share how you did the full UI/UX for this example. Because you didn’t show how you make it . I like the design of the ticket card and the dashboard that you can choose the pending ticket and so on . I hope you find time to show us how you did the full design of this dashboard
Video is focused on approval forms not on the design of home screen. The home screen was inspired from my video on responsive design. You can check that video ua-cam.com/video/1o2L0DADzKQ/v-deo.htmlsi=1Oy0SudCPTZ3rDZN
Very nicely explained. Can I set this up for multiple approves? Whoever picks up first can approve and then the approval is locked or freeze. ? I also want the ability for approved to update some fields along with approve/reject.
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.
This is great Reza, thank you! Could you please help me though. I have put "Set(varFormMode, FormMode.View); Set(varItem, ThisItem); Navigate(Request);" in the onSelect property of the arrow in the gallery on the Home screen. I named my other screen Request instead of Ticket. I have put "varItem" in the Item property of the form of the Request screen. I'm getting the error with the Item property formula "varItem = There is an error with this formula. Try revising the formula and running it again. Data Type: Record". I've cleared the history in my browser. I've disconnected and reconnected the datasource to the gallery. I've refreshed the app datasource and I get the same error. Could you help me?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello 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?
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.
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.
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 😊
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
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 UA-cam didn't recommend me your video before. Thank you for sharing your valuable knowledge.
Thanks Pritam.
Reza, you are outstanding, i have made money from customers watching your demo, I wish to work with you one day
👍
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)
It very good sharing.
Thank you! Cheers!
Reza, i've learned so much from you and your content, thank you so much for being a great teacher!
My pleasure!
Helped alot. Thanks Buddy. You kept it simple and achieved the task complexity with simplicity.
Great to hear! Thanks for watching
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!
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. ua-cam.com/video/lYE7NXTDPJY/v-deo.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.
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
Excellent video! Very clear instructions
Thank you!
Brilliant, I can think of atleast 10 places to use this :)
Thanks Reza. Much appreciated.
Perfect!
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:)
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) ua-cam.com/video/d4e1whKVJU4/v-deo.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.
Wow! Great tutorial video. Thank you for sharing, Reza!
Thank You for watching
Reza , you are the man. Thank you very much for video.
Most welcome
Thank u Reza give ur most valuable time for this session , thanks lot
Thank You for watching
Thank you Reza. So much great content to learn in here.
Thanks so much for watching
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
I will be shamelessly copying this, thank you!
Go for it. Thanks for trying it out :)
Wow you are awesome thank you I managed to follow your video to create my version of this power app 😎🙌
Great 👍
What a learning experience!!! Thank you so much..
Most welcome
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 :)
Wonderful piece of code. Keep up the good work mate and thanks for sharing...
Thank You!
Good..Nice Learning Videos.
Thanks Pannir
Thanls for sharing! Very informative!
Most welcome
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
This is a great build. Alot of great info!
Thanks
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 ua-cam.com/video/_2jDGqtqqi8/v-deo.html)
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 ua-cam.com/video/1o2L0DADzKQ/v-deo.html
@@RezaDorraniThank you! 🎉
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
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.
Very very Useful
Great Job
Thanks a lot Man
Glad it was helpful!
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, 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
Great one Reza :)
Thanks
Great work man. Thank you!
Most welcome
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.
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
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.
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 ua-cam.com/video/hzLEecSpmFo/v-deo.html
I have the same question. I'll study video.
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.
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
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!
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 ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
@@RezaDorrani thank you Reza. You are simply awesome bud.!
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
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
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
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.
Many Thanks To You😊! Great Video 🙌
Thank You
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.
At about 1900 in the video you add the flow in the onsuccess property but you can no longer do it this way it appears since there is no longer and action bar, however you can add the formula in and everything works as intended
I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani i meant the formula still works, just the action gui is no longer at the top
@@jl1399 ok
Hi Reza, First of all, your videos are really informative. I actually learned PowerApps and Automate watching your video. Thanks alot
The issue I am facing here is, I am not using a form but controls on the screen for some reason. These controls includes attachment control also. Using this approach, I am not able to bring the attachment from list item. however, When I select galley, I can access the attachments by Gallery.Attachments... . Any workaround?
Further Explanation: I am trying the same scenario as in the video. Opening powerapps item from email link. and I am not able to get the attachments for the item
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
Difficult to provide guidance on chat for specific issues. I will recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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
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.
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.
Hi, Firstly, thanks for such a helpful knowledge you shared. I am fresh in Power Apps. For learning purpose I want to process the Shipping Container Number.
It is request to would you please check the images and guide me, how I will extract the Shipping container number from the images ? I will be very thankful to you
Thanks for watching and liking the video.
Extracting images from documents. Check AI Builder playlist on my channel.
@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.
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).
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.
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
Thank you Reza. I am a power BI Developer and started learning Power apps. Your videos helps a lot to gain knowledge about features of power apps and its use cases with power automate. I tried creating the similar app but there is an issue. when approver clicks "Take action" on the email notification, it opens in view mode. event though I've updated the start screen and onstart functions. What could be the possible issues.
You’re most welcome!
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thanks a lot, this really helpful for me 🎉❤
Most welcome
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 !
Amazing, thanks for sharing it.
Thanks for watching
I love this, thanks so much. The only problem I have is when I need to edit the email; for some reason power automate cannot convert it back to HTML view without adding garbage and breaking the link :/
That is a known bug since a long time.
An option would be to add a compose action before send email action.
Plug your html in there and then use output if compose action in email body.
@@RezaDorrani good idea :)
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.
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.
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!!
Awesome and brilliant 👍👍
Thank you! Cheers!
Hi Reza, one question, I have worked with a similar app but it takes too long to load, what can i do in order to improve the performance? Great video as Always!!!! btw
Power Apps performance tips - ua-cam.com/video/_2jDGqtqqi8/v-deo.html
Thank you very much Reza.👌
Always welcome
It’s useful for me ... many thanks
👍
Hi Reza, thanks much for creating such a useful content which gives a beginner like me a lot of confidence to do forms in Power Apps.
I have tried in creating approval form in Power Apps. I can send an email to approvers but cannot open the specific form related to their department. Can you show me insight on how do I let the approvers to open the direct link of form in power Apps and submit their responses, here I have created multiple approval forms in specific to different departments. and parallelly everyone must approve. So in this scenario , I want all the approvers to open their respective form (ex, HR, Power, Signaling etc.)directly when click on link and update the field approve/ reject and submit .
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
@@RezaDorrani Sure, thank you for your quick response.
Reza, you are the best!!!!!!!!
Thank You!
GREAT Video .. thank you
Thanks for watching.
This is simply amazing!!
Just a question , I missed it probably
1) What are the formulas of the variables assigned varItem and varFormMode
All formulas should be in video. varItem is context of item to show in Form control and varFormMode is the Mode of the Form control.
I had faced some errors with the previous formula, but I was able to resolve them by using a new formula: Set(varFormMode;FormMode.View);;Set(varItem;ThisItem);;Navigate(Request) It worked for me, and I hope it helps you as well!
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.
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.
Hi Reza, thank you for this and great video as always. Quick question, what if there are two approvers for the request? What changes would you make?
I mean if there are two approvers who have to approve in parallel for the request to get approved
I would change the flow approval to include those 2 approvers either in same action or serially depending upon the use case.
I have done several videos on approvals. Check ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
I would change the flow approval to include those 2 approvers either in same action or serially depending upon the use case.
I have done several videos on approvals. Check ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
@@RezaDorrani Sweet as! I'll try that out. Love the content bro. Immensely helpful is an understatement.
@@RezaDorrani I suppose it could work serially as well seeing as if one of the approvers were to reject it, the request would be declined. I'll give it a go.
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
Amazing once again
Thank you! Cheers!
Hi Sir, I would say that I'm a fan of all of your video and I learned a lot. I made a sample power apps application and everything is fine however there is one thing I can't figure out on how to filter all the submitted tickets of those user's (ie. userA and userB) under me (ie. supervisorA) by the way I have person field(for user who submitted the ticket) in my Sharepoint lists. hope I did not confuse you with my question :) Thank you
I am confused :)
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
Thank you for your reply. I think what I'm trying to achieve is the Office365Users.DirectReporting... I want to filter out the user's ticket direct reporting to me.
@@felixmatusinio6438 Post on the forums and see what responses you get.
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 ..
Morning Reza
Could you please share how you did the full UI/UX for this example.
Because you didn’t show how you make it . I like the design of the ticket card and the dashboard that you can choose the pending ticket and so on . I hope you find time to show us how you did the full design of this dashboard
Video is focused on approval forms not on the design of home screen. The home screen was inspired from my video on responsive design. You can check that video ua-cam.com/video/1o2L0DADzKQ/v-deo.htmlsi=1Oy0SudCPTZ3rDZN
Very nicely explained.
Can I set this up for multiple approves? Whoever picks up first can approve and then the approval is locked or freeze. ? I also want the ability for approved to update some fields along with approve/reject.
Possible
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.
Hello Reza,
Thank you for this tutorial. Can you share the entire Video of this project. Thanks
The video is about approvals from apps. I do not have a complete tutorial video on the entire App.
This is great Reza, thank you! Could you please help me though. I have put "Set(varFormMode, FormMode.View); Set(varItem, ThisItem); Navigate(Request);" in the onSelect property of the arrow in the gallery on the Home screen. I named my other screen Request instead of Ticket. I have put "varItem" in the Item property of the form of the Request screen. I'm getting the error with the Item property formula "varItem = There is an error with this formula. Try revising the formula and running it again. Data Type: Record". I've cleared the history in my browser. I've disconnected and reconnected the datasource to the gallery. I've refreshed the app datasource and I get the same error. Could you help me?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello 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.