@@RezaDorrani It's a standard part of my natural ways of working and a best practice for all Citizen Developers and those interested in learning from the very Best ! Thanks for all that you do for this community!
@Reza, That trick with toggling to Horizontal Layout and back to Vertical Layout to highlight all of the Key and Value controls in the form was a slick trick. Definitely sharing that with my team.
Another great video with some good tips and tricks especially the selection of multiple datacards at a go. I usually create forms from scratch but good to pick up these tips from using the form control. Thanks for sharing.
Great video reza. Love the way you stacked this on the modern table controls. Very elegant. A suggestion for a new video if you'd consider would be to show some power automate with proper on-error general handling for catch-alls as opposed to individual error handling on each connector step. So frustrating making complex flows resilient. Have never found a great solution for this in power apps. Would love to see how you'd approach this. Also, are you planning to go to the Microsoft power platform conference coming up? If you're doing any sessions, I'd love to be there and thank you in person for the years of help .
Very happy to hear the feedback on this video. Power Platform Conference - powerplatformconf.com/?gad_source=1&gbraid=0AAAAADJS6fYvYffVM9ITE7lIpMHbs9gwn&gclid=CjwKCAjw_Na1BhAlEiwAM-dm7DevWhHmEWVMgZ8Iibvd94MOGBcWCzOHI12XLvjgbQB6IM397BWzNBoC6oQQAvD_BwE#!/session/Best%20Practices%20in%20Building%20Power%20Automate%20Cloud%20Flows/6963 Flow error handling for each step would not be a good option. Looking into using app insights for cloud flows. There you can scale and track each step of flow and also send custom alerts.
Sir, You're Looking Too good in this Beard Look - I learned a lot from your videos and I am getting a good freelancing works, thanks for your knowledge sharing 😊😊
Most welcome! I have no plans for a video on the topic you mentioned. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
I design my forms by hand using Patch statement and individual form fields, which makes designing responsiveness much more difficult. Would it be possible to get a video on how to do some of these responsiveness tricks using manual form controls?
I make videos when I receive multiple requests on a topic. Every 6-8 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Amazing video!! While practicing, I inserted a form inside the vertical container, but when a scroll bar appears, then all the controls inside the form(label, text input...) are getting blurred. Same for gallery as well. Can you please help me with this..?
My next video shows generating pdf from form and sends it out as email attachment. Link here th-cam.com/video/PlBPCi4yXVs/w-d-xo.htmlsi=2_vO7pBnGDnWcI9d
Hey Reza, thank you very much for the tutorial. Unfortunately, I still have the problem that the people picker in my table only shows numbers instead of names. In other words, the same problem as with the combo box. In a previous video you showed a small workaround that works wonderfully with combo boxes (exchange modern to classic), which I unfortunately cannot use in a table? Is there perhaps already a trick here that works? Thx for time and effort
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
Hey Reza, thank you very much for your video! I do learn a lot . Just a question on duplicating/copying a record. Let’s say we want to create new record by selecting the existing record and then duplicate it in form as a edit mode, then I could change some fields and submit it . Hereby, submission should be a new record not edit it. That will save much time from re-fill a lot of fields. Could you please make a video on how to make it 😅,thank you
Its definitely possible but not something I have tried. I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Sir Reza, I tried to do this responsive form but why is it sometimes the record in the table is not updating when I click the submit button? My data is connected thru excel.
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
Awesome content as always! Having issues with multi line text fields with modern forms, cursor placement goes whack when you try to edit the fields mid sentance or add words in the middle. Otherwise I love the new form experience
hi Reza, how are you doing? is there any possibility that you would do a video explaining how to make an application to evaluate employees? like performance evaluation. thanks! :)
Im doing great! Currently, no plans for any video on that topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Reza, so if I want to make a form app from a SharePoint list that will show up when users click "New" or "Add new list item" directly from the list, this will never be fully responsive? Because I notice when I make the app in that way, it does not have the turn off "scale to fit" option.
Hi Reza, may I know how do you clear the selected row in the Sharepoint list? Because currently when I click Cancel it will still select the same row and keep navigate back to the Form page everytime I click Cancel. This thing only happening on Sharepoint list page, other pages no problem
I simply reset the form from what I remember. I dont remember running into any issues with it. Video description has details on how to download the solution showcased in video (members only)
@@RezaDorrani It’s okay, I just found out that I need to use Refresh(Datasource). Last time, I only used Back(), and nothing happened. However, with the latest PowerApps update, it keeps triggering OnSelect even when I use Back().
This is awesome!! I have a quick question. I noticed that the new form in "view" status is displaying date values in the data card even when there are no values present. Furthermore, when I change the status to "edit," the data card shows the date values as blank. What could be causing this?
Hi Reza. Thank you for all your videos, it's an awesome work and it help us a lot :-) I have one question : Let's imagine that I fill out a long form for a person chosen from the table screen, that I save it but that I realize that I made the wrong selection in the table. I would like to reopen this recording and automatically delete all recorded variables via a new button on the form screen but I cannot... I tried with Reset, Set, Remove but impossible...Thank you. Best Regards
Recorded variables or recorded values in form? Form data is saved in data source. Once submitted, data gets written to data source. A reset within power apps won't help. You would need version control in your data source
Hey Reza, you always publish helpful content which I always refer to create flow. I have been trying to create a flow for 14 days now but still cannot figure it out. I am trying to create an approval request to delete files in OneDrive for business. The idea is to send the request with an attachement of the file, have the approved review it, if approved the file goes to the recycle bin; if rejected it stays to its original location.
Thanks! I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi reza, I tried modern editform thanks to your video. However, I encounter a weird behavior. I have multiple combo box. One of them is master on the other, it means that, is value selected is YES in the master, other datacards that contain combo box are visible, else not visible. It works well BUT, at the first launch of the app, sub combo box are empty, I need to get out of the editform, go back in there, and now, sub combobox have their value. Why making them not visible by default prevent them from having their value by default ? Thanks
I have created a CANVAS app with all the required fields, once this powerapps form is completed, output goes to sharepoint list coz I have set up set up a powerautomate flow too. 2 questions? 1. Once user click submit request. I want user to get , for example, "Request no. is 12345" is generated, how to achieve this? 2. how to integrate this flow with my powerapp ? thank you for your help !
1 - Check for LastSubmit property of form control. It will give you all details of last submitted form by user in current app context. 2 - I have a playlist on flows integration with apps. I will recommend checking that.
@reza, Any comments to what seems to be a bug when using “Set(varRecord,Table.Selected)”, and then varRecord as the Form item, - in return to the screen, you cannot seem to select the same record that is already set the varRecord. I tend to use this to pass other items forward. Any thoughts?
@@RezaDorrani in return to the screen to with the table control, typically with traditional gallery where the vaRecord is “Set(varRecord,ThisItem)” I don’t see this same behavior - for Set(varRecord,Table.Selected) it’s almost as if when you return after completing actions with form that there is no reset of the what items / row record is currently selected. That behavior typically is not the same with galleries / form relationships etc.
I have also had delayed updating of the table when saving forms, I have tried the varReset to false / varReset to true - but the delay to which the table record shows the update is much slower then a gallery for now.
Hi Reza, I want to make a form which will have 4 questions, Sales Rep, Customer name, startdate, end date. There are 30 users in Sales rep and on each user's behalf there will be their customers, the condition is, if Sales Rep A login then he should only see Sales rep A and his customers but not the rest, if Sales Rep B logins then the same shows. Is this possible,. User form should be as per Sales Rep. Pls support on this
I do not have a video reference on the mentioned scenario and would have to try it out to know the options. My videos are the only references I have. I do not offer support on specific use cases. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
I wrote that the width of the normal container should decrease as the screen decreases by using if condition, and it worked, but using to verticall, horizontal container when I use that not worked
Depends upon settings of horizontal and vertical container. Regular container simply has height, width, x and y. Responsive containers have a lot more properties that need to be adjusted.
hy reza hope you are doinig well i want to ask something i have a list in which i have 3 approver minimum approver is 1 and maximum 1 and 2 or 1 and 2 and 3 i watch your video in which you also get response link in power app i want to make a flow in which i can add these seq of approver and also get responce link how can do this if you suggest me something its realy help of me Thanks in advance❤❤
Hey, I have done many approval based videos, including recent ones from power apps. Some have used approval action and some have not. Not sure which one you are relating to.
Hey Reza, you always publish helpful content which I always refer to create flow. I have been trying to create a flow for 14 days now but still cannot figure it out. I am trying to create an approval request to delete files in OneDrive for business. The idea is to send the request with an attachement of the file, have the approved review it, if approved the file goes to the recycle bin; if rejected it stays to its original location.
Thanks Mariam! I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Every day we progress better and better with your great video and explanation.....thank you Reza
Glad to hear that!
Thanks so much for watching and learning from my videos.
@@RezaDorrani It's a standard part of my natural ways of working and a best practice for all Citizen Developers and those interested in learning from the very Best ! Thanks for all that you do for this community!
@Reza, That trick with toggling to Horizontal Layout and back to Vertical Layout to highlight all of the Key and Value controls in the form was a slick trick. Definitely sharing that with my team.
Glad you liked it!
Another fantastic group of tutorials that I will use this week for another app, thanks, Reza!
Great to hear!
Cool. Reza did it again. Thank you sir.
Awesome video, came here for responsive design and learned some other tricks as well. Thank you so much
Great to hear!
Another great video with some good tips and tricks especially the selection of multiple datacards at a go. I usually create forms from scratch but good to pick up these tips from using the form control. Thanks for sharing.
Thanks so much Doug
Excellent video Reza!!
Thank you!
Wonderful explanation.. gonna be very much useful for us
Glad to hear that
As always simply brilliant.
Thank you.
Thanks again!
Great Content as usual. Cheers maye 🙏🏽
Glad you enjoyed it
Great reminder Reza, thank you
Thanks for watching
Thanks Reza, Always new tricks 😊
You’re most welcome
Hello Reza, always a good time to follow your tutorial…; I remember the time of your tuto: How to build grid table based on galleries !! Thank you
You are most welcome!
Thank you Reza
Welcome
Great video reza. Love the way you stacked this on the modern table controls. Very elegant.
A suggestion for a new video if you'd consider would be to show some power automate with proper on-error general handling for catch-alls as opposed to individual error handling on each connector step. So frustrating making complex flows resilient. Have never found a great solution for this in power apps. Would love to see how you'd approach this.
Also, are you planning to go to the Microsoft power platform conference coming up? If you're doing any sessions, I'd love to be there and thank you in person for the years of help .
Very happy to hear the feedback on this video.
Power Platform Conference - powerplatformconf.com/?gad_source=1&gbraid=0AAAAADJS6fYvYffVM9ITE7lIpMHbs9gwn&gclid=CjwKCAjw_Na1BhAlEiwAM-dm7DevWhHmEWVMgZ8Iibvd94MOGBcWCzOHI12XLvjgbQB6IM397BWzNBoC6oQQAvD_BwE#!/session/Best%20Practices%20in%20Building%20Power%20Automate%20Cloud%20Flows/6963
Flow error handling for each step would not be a good option. Looking into using app insights for cloud flows. There you can scale and track each step of flow and also send custom alerts.
Sir, You're Looking Too good in this Beard Look - I learned a lot from your videos and I am getting a good freelancing works, thanks for your knowledge sharing 😊😊
Hey, thanks so much! Had a long week, hence did not shave :)
Informative session.... Thank you Reja.😊😊 Expect more videos on aproval flows for sending adaptive cards to all the users at a time...not sequential
Most welcome!
I have no plans for a video on the topic you mentioned.
Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Your videos are big help man! Do you have a video when you create your home screen (Employee Record)?
th-cam.com/video/CVmjxMp79W0/w-d-xo.htmlsi=di8APPsxBpWq6G3m
I design my forms by hand using Patch statement and individual form fields, which makes designing responsiveness much more difficult. Would it be possible to get a video on how to do some of these responsiveness tricks using manual form controls?
I make videos when I receive multiple requests on a topic. Every 6-8 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
@@RezaDorrani Got it, will do.
Amazing video!!
While practicing, I inserted a form inside the vertical container, but when a scroll bar appears, then all the controls inside the form(label, text input...) are getting blurred. Same for gallery as well.
Can you please help me with this..?
I believe that blur is only in designer. Not when app is published and run.
@@RezaDorrani Thanks for the response Reza. I will check that
@Reza, Sir do you have a video that the form will be sent to outlook when you click the 'button'?
My next video shows generating pdf from form and sends it out as email attachment.
Link here th-cam.com/video/PlBPCi4yXVs/w-d-xo.htmlsi=2_vO7pBnGDnWcI9d
Hey Reza, thank you very much for the tutorial. Unfortunately, I still have the problem that the people picker in my table only shows numbers instead of names. In other words, the same problem as with the combo box. In a previous video you showed a small workaround that works wonderfully with combo boxes (exchange modern to classic), which I unfortunately cannot use in a table? Is there perhaps already a trick here that works?
Thx for time and effort
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
@@RezaDorrani Thank you for the quick response. I will try that and gladly report back the result :)
Nice video Reza! Can we do this in Responsive App too?
The video showcase is for a responsive app.
Maybe, I did not understand your question.
Hey Reza, thank you very much for your video! I do learn a lot . Just a question on duplicating/copying a record. Let’s say we want to create new record by selecting the existing record and then duplicate it in form as a edit mode, then I could change some fields and submit it . Hereby, submission should be a new record not edit it. That will save much time from re-fill a lot of fields. Could you please make a video on how to make it 😅,thank you
Its definitely possible but not something I have tried.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Sir Reza, I tried to do this responsive form but why is it sometimes the record in the table is not updating when I click the submit button? My data is connected thru excel.
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
Awesome content as always! Having issues with multi line text fields with modern forms, cursor placement goes whack when you try to edit the fields mid sentance or add words in the middle. Otherwise I love the new form experience
I believe that is an ongoing bug with the multi text control for modern
hi Reza, how are you doing? is there any possibility that you would do a video explaining how to make an application to evaluate employees? like performance evaluation. thanks! :)
Im doing great!
Currently, no plans for any video on that topic.
Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Reza, so if I want to make a form app from a SharePoint list that will show up when users click "New" or "Add new list item" directly from the list, this will never be fully responsive? Because I notice when I make the app in that way, it does not have the turn off "scale to fit" option.
SharePoint list form based Apps are NOT responsive by design.
@@RezaDorrani Thank you so much for your quick response!
Hi Reza... one question - I'm still confused between FormMode.Edit and EditForm(form1)... what's the difference?
Formmode.edit is an enum.
Editform() is a function that changes mode of the form to edit.
Hi Reza, may I know how do you clear the selected row in the Sharepoint list? Because currently when I click Cancel it will still select the same row and keep navigate back to the Form page everytime I click Cancel. This thing only happening on Sharepoint list page, other pages no problem
I simply reset the form from what I remember. I dont remember running into any issues with it.
Video description has details on how to download the solution showcased in video (members only)
@@RezaDorrani It’s okay, I just found out that I need to use Refresh(Datasource). Last time, I only used Back(), and nothing happened. However, with the latest PowerApps update, it keeps triggering OnSelect even when I use Back().
This is awesome!! I have a quick question. I noticed that the new form in "view" status is displaying date values in the data card even when there are no values present. Furthermore, when I change the status to "edit," the data card shows the date values as blank. What could be causing this?
Did you notice this in my App? I dont remember running into any issues with it.
@@RezaDorrani No sorry for the confusion this is for another form.
I have not experienced the mentioned issue, hence not sure. I would recommend posting your issue on forums at powerusers.microsoft.com/
Hi Reza. Thank you for all your videos, it's an awesome work and it help us a lot :-)
I have one question :
Let's imagine that I fill out a long form for a person chosen from the table screen, that I save it but that I realize that I made the wrong selection in the table. I would like to reopen this recording and automatically delete all recorded variables via a new button on the form screen but I cannot... I tried with Reset, Set, Remove but impossible...Thank you. Best Regards
Recorded variables or recorded values in form?
Form data is saved in data source. Once submitted, data gets written to data source. A reset within power apps won't help. You would need version control in your data source
@@RezaDorrani Recorded values in form. It's OK, I made it with "Patch" 🙂
Hey Reza, you always publish helpful content which I always refer to create flow. I have been trying to create a flow for 14 days now but still cannot figure it out. I am trying to create an approval request to delete files in OneDrive for business. The idea is to send the request with an attachement of the file, have the approved review it, if approved the file goes to the recycle bin; if rejected it stays to its original location.
Thanks!
I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi reza, I tried modern editform thanks to your video. However, I encounter a weird behavior. I have multiple combo box. One of them is master on the other, it means that, is value selected is YES in the master, other datacards that contain combo box are visible, else not visible.
It works well BUT, at the first launch of the app, sub combo box are empty, I need to get out of the editform, go back in there, and now, sub combobox have their value. Why making them not visible by default prevent them from having their value by default ? Thanks
Might very well be a bug. Not something I have experienced though.
Thx
Welcome
Under observer name why does it show INJECTO instead of the choice of names? Thank u for this helpful video.
What time in video was it shown?
I have created a CANVAS app with all the required fields, once this powerapps form is completed, output goes to sharepoint list coz I have set up set up a powerautomate flow too. 2 questions?
1. Once user click submit request. I want user to get , for example, "Request no. is 12345" is generated, how to achieve this?
2. how to integrate this flow with my powerapp ?
thank you for your help !
1 - Check for LastSubmit property of form control. It will give you all details of last submitted form by user in current app context.
2 - I have a playlist on flows integration with apps. I will recommend checking that.
@reza, Any comments to what seems to be a bug when using “Set(varRecord,Table.Selected)”, and then varRecord as the Form item, - in return to the screen, you cannot seem to select the same record that is already set the varRecord. I tend to use this to pass other items forward. Any thoughts?
On return to which screen?
@@RezaDorrani in return to the screen to with the table control, typically with traditional gallery where the vaRecord is “Set(varRecord,ThisItem)” I don’t see this same behavior - for Set(varRecord,Table.Selected) it’s almost as if when you return after completing actions with form that there is no reset of the what items / row record is currently selected. That behavior typically is not the same with galleries / form relationships etc.
I have also had delayed updating of the table when saving forms, I have tried the varReset to false / varReset to true - but the delay to which the table record shows the update is much slower then a gallery for now.
@@steviesimsii Ya, I believe thats a bug for now
@@RezaDorrani Ok - that is good to know. Thanks!
Is there a way to export these tables to Excel?
Similar to gallery - th-cam.com/video/UZdngrwWsqA/w-d-xo.html
Hello Reza, Can you please also make video on interactive Model Dirven app please?
Not sure what interactive means?
@@RezaDorrani Interactive means, can we have option to add these kind of features to the model driven apps as well?
@@rahulnalawade4017 Model driven apps are already responsive by design.
Hi Reza, I want to make a form which will have 4 questions, Sales Rep, Customer name, startdate, end date. There are 30 users in Sales rep and on each user's behalf there will be their customers, the condition is, if Sales Rep A login then he should only see Sales rep A and his customers but not the rest, if Sales Rep B logins then the same shows. Is this possible,. User form should be as per Sales Rep. Pls support on this
I do not have a video reference on the mentioned scenario and would have to try it out to know the options. My videos are the only references I have. I do not offer support on specific use cases. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
I wrote that the width of the normal container should decrease as the screen decreases by using if condition, and it worked, but using to verticall, horizontal container when I use that not worked
Depends upon settings of horizontal and vertical container. Regular container simply has height, width, x and y.
Responsive containers have a lot more properties that need to be adjusted.
@@RezaDorrani thank you
I tried to follow this video... But form validations are not working... Can someone please guide...
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
hy reza hope you are doinig well i want to ask something i have a list in which i have 3 approver minimum approver is 1 and maximum 1 and 2 or 1 and 2 and 3 i watch your video in which you also get response link in power app i want to make a flow in which i can add these seq of approver and also get responce link how can do this if you suggest me something its realy help of me
Thanks in advance❤❤
Hey, I have done many approval based videos, including recent ones from power apps. Some have used approval action and some have not. Not sure which one you are relating to.
MR.Reza looks little different
Ya, tried a different look
I like your normal face over the AI face on the thumbnail, but I guess it could be more catchy as a thumbnail.
As long as the video content is good, nothing else matters.
Hey Reza, you always publish helpful content which I always refer to create flow. I have been trying to create a flow for 14 days now but still cannot figure it out. I am trying to create an approval request to delete files in OneDrive for business. The idea is to send the request with an attachement of the file, have the approved review it, if approved the file goes to the recycle bin; if rejected it stays to its original location.
Thanks Mariam!
I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani thank you. I appreciate the help. I will check it out.