Another masterpiece. So much to unplug so have to watch again and try to replicate. Thanks for Sharing
@RezaDorrani3 жыл бұрын
Wow, Thank You!
@sialmiroma Жыл бұрын
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.
@RezaDorrani Жыл бұрын
Most welcome and so glad to hear the videos (even older ones) are useful
@shahzade2 жыл бұрын
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!
@RezaDorrani2 жыл бұрын
You are most welcome!
@singgihsatyahadi59222 жыл бұрын
APPRECIATE IT!!!
@sansaneec13233 жыл бұрын
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.
@RezaDorrani3 жыл бұрын
Wonderful! Thank You so much for watching & liking my videos 🙏
@yehunlavolontededieu3223 жыл бұрын
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
@RezaDorrani3 жыл бұрын
I will probably do a more detailed deep linking video in future. Deep linking into Apps, Teams based Apps, Teams messages and more.
@yehunlavolontededieu3223 жыл бұрын
@@RezaDorrani PLEASE
@yehunlavolontededieu3223 жыл бұрын
@@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
@RezaDorrani3 жыл бұрын
@@yehunlavolontededieu322 My plan was to include some stuff around role based deep linking.
@NandeeshHampiholi Жыл бұрын
So much dedication while explaining, feels like watching it again and again!! Crystal clear explanation!! Thank you very much sir!!
@RezaDorrani Жыл бұрын
Most welcome and thanks so much for the appreciation
@nuh_93 Жыл бұрын
U r welcome sir 😊
@geofffaulkner98323 жыл бұрын
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.
@RezaDorrani3 жыл бұрын
Glad it was helpful! Thank You for watching.
@pritampaul51152 жыл бұрын
Awesome video. Idk why KZbin didn't recommend me your video before. Thank you for sharing your valuable knowledge.
@RezaDorrani2 жыл бұрын
Thanks Pritam.
@LAXMIKANT19923 жыл бұрын
This is very useful video. Something new i learnt today...Specially the Adaptive card one....Thanks.....Keep Sharing....
@RezaDorrani3 жыл бұрын
Glad to hear the feedback. Thank You for watching.
@maazosmany1291 Жыл бұрын
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 🎉❤
@RezaDorrani Жыл бұрын
Thank You so much Maaz
@muhammadmuzammil6539 Жыл бұрын
Helped alot. Thanks Buddy. You kept it simple and achieved the task complexity with simplicity.
@RezaDorrani Жыл бұрын
Great to hear! Thanks for watching
@marka.5593 Жыл бұрын
Reza, i've learned so much from you and your content, thank you so much for being a great teacher!
@RezaDorrani Жыл бұрын
My pleasure!
@JH-tc3lu9 ай бұрын
Excellent video! Very clear instructions
@RezaDorrani9 ай бұрын
Thank you!
@ArohShukla3 жыл бұрын
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 ..
@RezaDorrani3 жыл бұрын
Awesome, thank you Aroh!
@kamozzi13 жыл бұрын
This is awesome Reza. Really help and intuitive. Going to test this out tomorrow, specifically Adaptive cards. Great work mate.
@RezaDorrani3 жыл бұрын
Thank You. The Adaptive Cards component was enjoyable to build. I plan to do an introduction video series on it.
@kamozzi13 жыл бұрын
@@RezaDorrani that would be great. Thanks
@SHAli14743 жыл бұрын
Brilliant, I can think of atleast 10 places to use this :) Thanks Reza. Much appreciated.
@RezaDorrani3 жыл бұрын
Perfect!
@imotumbokanaka41572 жыл бұрын
Reza, you are outstanding, i have made money from customers watching your demo, I wish to work with you one day
@RezaDorrani2 жыл бұрын
👍
@minstreltokunbo3 жыл бұрын
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.
@RezaDorrani3 жыл бұрын
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.
@tomanforever2 жыл бұрын
@@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)
@i3oomiizz3 жыл бұрын
Wow! Great tutorial video. Thank you for sharing, Reza!
@RezaDorrani3 жыл бұрын
Thank You for watching
@69629432 жыл бұрын
Wow you are awesome thank you I managed to follow your video to create my version of this power app 😎🙌
@RezaDorrani2 жыл бұрын
Great 👍
@tonberryking33682 жыл бұрын
Thank you Reza. So much great content to learn in here.
@RezaDorrani2 жыл бұрын
Thanks so much for watching
@ajit3823 жыл бұрын
Thank u Reza give ur most valuable time for this session , thanks lot
@RezaDorrani3 жыл бұрын
Thank You for watching
@mightyflagelot9816 Жыл бұрын
Thanls for sharing! Very informative!
@RezaDorrani Жыл бұрын
Most welcome
@muralitk3 жыл бұрын
Wonderful piece of code. Keep up the good work mate and thanks for sharing...
@RezaDorrani3 жыл бұрын
Thank You!
@yeskumar782 жыл бұрын
What a learning experience!!! Thank you so much..
@RezaDorrani2 жыл бұрын
Most welcome
@fovalere Жыл бұрын
Reza , you are the man. Thank you very much for video.
@RezaDorrani Жыл бұрын
Most welcome
@johnjanis7143 жыл бұрын
This is a great build. Alot of great info!
@RezaDorrani3 жыл бұрын
Thanks
@MEPsideofBIM Жыл бұрын
Great work man. Thank you!
@RezaDorrani Жыл бұрын
Most welcome
@chamreth3 жыл бұрын
It very good sharing.
@RezaDorrani3 жыл бұрын
Thank you! Cheers!
@JohnHall3 жыл бұрын
Notice that Reza did not "deep link" to the ID in PowerApps inside a Teams app. This was done to a common standard PowerApp.
@RezaDorrani3 жыл бұрын
Good observation:)
@pofaelamir12 жыл бұрын
Very very Useful Great Job Thanks a lot Man
@RezaDorrani2 жыл бұрын
Glad it was helpful!
@corywarshaw41003 жыл бұрын
I will be shamelessly copying this, thank you!
@RezaDorrani3 жыл бұрын
Go for it. Thanks for trying it out :)
@yiqihong9288 Жыл бұрын
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.
@RezaDorrani Жыл бұрын
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
@s.b.90373 жыл бұрын
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 :)
@RezaDorrani3 жыл бұрын
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. kzbin.info/www/bejne/ooqoaIGOiamDgLs
@s.b.90373 жыл бұрын
@@RezaDorrani Awesome, thanks a lot Reza! :)
@davidcortes93262 жыл бұрын
@@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.
@RezaDorrani2 жыл бұрын
@@davidcortes9326 I have done multiple videos on dynamic approvers. You can check my approvals playlist.
@ramya_rajagopal2 жыл бұрын
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!
@RezaDorrani2 жыл бұрын
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
@madhurishirsat93033 жыл бұрын
Many Thanks To You😊! Great Video 🙌
@RezaDorrani3 жыл бұрын
Thank You
@abeerasad35962 жыл бұрын
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
@RezaDorrani2 жыл бұрын
You need to use "Get Item" and not "Get items"
@abeerasad35962 жыл бұрын
@@RezaDorrani Thank you!!
@oliviermeere7996 Жыл бұрын
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 ?
@RezaDorrani Жыл бұрын
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
@kanchanverma-or7ie9 ай бұрын
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
@RezaDorrani9 ай бұрын
Welcome! I did this video a long while ago and no longer have access to that app.
@angleslie95292 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
1) kzbin.info/www/bejne/mmXIYqqegLt9i5Y 2) Deep linking is shown in this video itself.
@angleslie95292 жыл бұрын
@@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?
@RezaDorrani2 жыл бұрын
@@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.
@pannirselvam96612 жыл бұрын
Good..Nice Learning Videos.
@RezaDorrani2 жыл бұрын
Thanks Pannir
@wemersonlopes2039 Жыл бұрын
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
@RezaDorrani Жыл бұрын
You have view mode in email? I did not understand your question
@vipulkoul60373 жыл бұрын
Great one Reza :)
@RezaDorrani3 жыл бұрын
Thanks
@chgopinath23713 жыл бұрын
Awesome and brilliant 👍👍
@RezaDorrani3 жыл бұрын
Thank you! Cheers!
@aghi_raharjo9 ай бұрын
Good video, really helpful if there any link to make the first page (the one with the status in left)? Thank you
@RezaDorrani9 ай бұрын
Welcome! I have probably done a video on it but do not remember which.
@matheusbarbosa7452 жыл бұрын
Reza, you are the best!!!!!!!!
@RezaDorrani2 жыл бұрын
Thank You!
@leankassio6713 жыл бұрын
Amazing, thanks for sharing it.
@RezaDorrani3 жыл бұрын
Thanks for watching
@jl1399 Жыл бұрын
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
@RezaDorrani Жыл бұрын
I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@jl1399 Жыл бұрын
@@RezaDorrani i meant the formula still works, just the action gui is no longer at the top
@RezaDorrani Жыл бұрын
@@jl1399 ok
@the_power_ride Жыл бұрын
Thanks a lot, this really helpful for me 🎉❤
@RezaDorrani Жыл бұрын
Most welcome
@mtamitolanga2 жыл бұрын
Thank you very much Reza.👌
@RezaDorrani2 жыл бұрын
Always welcome
@rajasekar50693 жыл бұрын
It’s useful for me ... many thanks
@RezaDorrani3 жыл бұрын
👍
@djnature1741 Жыл бұрын
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 Жыл бұрын
I responded to the print question in another comment
@djnature1741 Жыл бұрын
@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?
@RezaDorrani Жыл бұрын
@@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
@Empriction2 жыл бұрын
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!!
@RezaDorrani2 жыл бұрын
I have done multiple videos on gallery filtering.
@terrymaster5412 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
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
@aaron2884 Жыл бұрын
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?
@RezaDorrani Жыл бұрын
I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@pennaiahnagarajappa56393 жыл бұрын
GREAT Video .. thank you
@RezaDorrani3 жыл бұрын
Thanks for watching.
@ffhunter9269 Жыл бұрын
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?
@RezaDorrani Жыл бұрын
Approval action currently only supports 1 by 1 approval.
@CreditCurrys Жыл бұрын
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.
@RezaDorrani Жыл бұрын
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
@slobby1bjovi Жыл бұрын
I love the look and feel of this app! How did you get the awesome blue boxes in the Help Desk App screen?
@RezaDorrani Жыл бұрын
Thanks. I did a video on responsive design where I shared the app (link in video description or pinned comment. Check kzbin.info/www/bejne/Z6CVfWN6dqmtgbM
@slobby1bjovi Жыл бұрын
@@RezaDorraniThank you! 🎉
@malte2271996 Жыл бұрын
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
@RezaDorrani Жыл бұрын
Yes, you can surely do that. Not something I have tried though :)
@goncalosilva759810 ай бұрын
Excelent work! I try to adapt in my secnario and I cound't, this only works in premium licence?
@RezaDorrani10 ай бұрын
There is no premium connector used. Not sure what other connectors you are using in your app.
@DineshKumar-fm5mo6 ай бұрын
@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.
@RezaDorrani6 ай бұрын
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.
@ak4indd3 жыл бұрын
Thanks Reza!! Is it possible to reassign task and track the approval status/comments in this approach?
@RezaDorrani3 жыл бұрын
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 kzbin.info/www/bejne/nquvdpiZiNWgfNE
@vladimirpeshkov48463 жыл бұрын
I have the same question. I'll study video.
@rahulmenon9164 Жыл бұрын
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.
@RezaDorrani Жыл бұрын
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
@rahulmenon9164 Жыл бұрын
Thanks@@RezaDorrani, it was resolved. Switched to classic designer in the flow.
@victor42773 жыл бұрын
Amazing once again
@RezaDorrani3 жыл бұрын
Thank you! Cheers!
@timlong89873 жыл бұрын
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
@RezaDorrani3 жыл бұрын
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
@vladimirpeshkov48463 жыл бұрын
Great tutorial!
@RezaDorrani3 жыл бұрын
Thank You
@PavanChowdary-v2z10 ай бұрын
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?
@RezaDorrani10 ай бұрын
Thanks for the sub! LastSubmit is a form feature that returns last submitted item data. Not sure why it would not work for you.
@djboob6610 ай бұрын
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.
@RezaDorrani10 ай бұрын
@@djboob66 I would recommend posting the issue on forums as I have not experienced the same. powerusers.microsoft.com/
@djboob6610 ай бұрын
@user-yv3vr1nk8e If you have any luck with a fix can you post the answer here please .
@giammarcogaudini68172 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
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
@fadiahdab3 жыл бұрын
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
@RezaDorrani3 жыл бұрын
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.
@fadiahdab3 жыл бұрын
@@RezaDorrani Thank you for the reply , that what i expected
@shreyasgoyal65995 ай бұрын
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.
@RezaDorrani5 ай бұрын
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
@josuecarlocontrerassulca74492 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
Reason is for deep linking to form + avoiding control dependency between screens (Watch kzbin.info/www/bejne/lWPNdXqnqdakn5o)
@taniamathew9354 Жыл бұрын
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?
@RezaDorrani Жыл бұрын
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
@taniamathew9354 Жыл бұрын
For context I use a patch function to submit my form to my data source
@RezaDorrani Жыл бұрын
@@taniamathew9354 Flow can be called from any scenario. I would recommend posting your issue on forums.
@xoliswamazomba8011 ай бұрын
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?
@RezaDorrani11 ай бұрын
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.
@faharalzadjali5606 Жыл бұрын
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
@RezaDorrani Жыл бұрын
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 kzbin.info/www/bejne/Z6CVfWN6dqmtgbMsi=1Oy0SudCPTZ3rDZN
@charlene34902 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
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).
@terabyte65852 жыл бұрын
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?
@RezaDorrani2 жыл бұрын
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.
@737cl92 жыл бұрын
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. .?
@RezaDorrani2 жыл бұрын
I have done videos on assigning multiple approvers. Check my approvals playlist kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
@737cl92 жыл бұрын
@@RezaDorrani thank you Reza. You are simply awesome bud.!
@hiteshjal1437 ай бұрын
@Reza Dorrani :- do you hv full video for this form??? The First page (Home screen) you created of status for that there is no information
@RezaDorrani7 ай бұрын
Not for this one specifically but I have done many videos on gallery designs.
@longyefang5046 Жыл бұрын
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?
@RezaDorrani Жыл бұрын
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
@longyefang5046 Жыл бұрын
@@RezaDorrani Thank you for your quick response!
@TanuviShetty7 ай бұрын
I too have same error . Did you fix it. if yes please tell me how.
@mustafahussainmohsin3202 жыл бұрын
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???
@RezaDorrani2 жыл бұрын
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).
@mustafahussainmohsin3202 жыл бұрын
@@RezaDorrani oh Thanks ♥️. Well I have to develop exactly like that
@swathivepuri77972 жыл бұрын
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 .
@RezaDorrani2 жыл бұрын
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
@swathivepuri77972 жыл бұрын
@@RezaDorrani Sure, thank you for your quick response.
@spchannel49672 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
Thanks. No sample app for this on GitHub.
@spchannel49672 жыл бұрын
@@RezaDorrani - Thank you so much for quick response ..
@ankitpandey75333 жыл бұрын
Hi Reza thanks for sharing knowledge. Quick question can we use this form for more that 5000 item list ?
@RezaDorrani3 жыл бұрын
Yes, you can. As long as delegation is handled. Check my playlist on delegation.
@krisperkreme6021 Жыл бұрын
Thank you very much!
@RezaDorrani Жыл бұрын
Most welcome!
@felixmatusinio64382 жыл бұрын
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
@RezaDorrani2 жыл бұрын
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
@felixmatusinio64382 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
@@felixmatusinio6438 Post on the forums and see what responses you get.
@tylerlarson14362 жыл бұрын
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!
@RezaDorrani2 жыл бұрын
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
@aminahamilton17902 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
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
@harriedblues83232 жыл бұрын
@@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.
@harriedblues83232 жыл бұрын
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.
@dreamsmol23622 жыл бұрын
Hello Reza, Thank you for this tutorial. Can you share the entire Video of this project. Thanks
@RezaDorrani2 жыл бұрын
The video is about approvals from apps. I do not have a complete tutorial video on the entire App.
@rajeevchatterjee73853 жыл бұрын
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
@RezaDorrani3 жыл бұрын
Thanks for watching and liking the video. Extracting images from documents. Check AI Builder playlist on my channel.
@ankitamohapatra9nov5 ай бұрын
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.
@RezaDorrani5 ай бұрын
Seems you are using sharepoint list forms. I am not aware of an option to remove those.
@jenniferwoo40342 жыл бұрын
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 :/
@RezaDorrani2 жыл бұрын
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.
@jenniferwoo40342 жыл бұрын
@@RezaDorrani good idea :)
@earlgarnethechico78772 жыл бұрын
Hi Sir. @Reza do you have a video regarding the Form you use?
@RezaDorrani2 жыл бұрын
I have done multiple videos on form control.
@WaliSayed Жыл бұрын
Hi Reza, thanks a lot for the useful video. However, this is good if there is one level of approval but I have a multi-level approval to be done within the Power Apps form. In the first step, line manager approves the request, after that review will be done by the reviewer, and the final approval is done by the country director. I can manage this by creating multiple flows for different buttons. However, your insight will be appreciated.
@RezaDorrani Жыл бұрын
Possible for sure but I do not have a video reference on it and would have to try it out to provide guidance. I recommend posting your query on forums in case someone has done something similar powerusers.microsoft.com
@WaliSayed Жыл бұрын
@@RezaDorrani Thank you Reza jan
@waqasidris48912 жыл бұрын
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?
@waqasidris48912 жыл бұрын
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
@RezaDorrani2 жыл бұрын
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
@RezaDorrani2 жыл бұрын
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
@shauntan83922 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
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
@marounsader3183 жыл бұрын
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 ?
@RezaDorrani3 жыл бұрын
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.
@marounsader3183 жыл бұрын
@@RezaDorrani thanks reza this clear thank you !
@radhikaM914 Жыл бұрын
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.
@RezaDorrani Жыл бұрын
Possible
@julien89793 жыл бұрын
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?
@RezaDorrani3 жыл бұрын
Yes it does!
@benyaminkubwimana2 жыл бұрын
Hi Reza! Wondering if you plan to share this on your Git repos at some point. Thanks
@RezaDorrani2 жыл бұрын
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.