Another blockbuster of a video. Using the Canvas control and its Datacards to convert an app to responsive is huge. It will reduce the amount of nested containers we need to create responsive apps. This is so cool and really appreciate your commitment to release new nuggets in your videos. Thank you so much for sharing again. Greatly appreciated. Downloading and adding it to my "Reza Environment" in my Tenant. 🤣🤣🤣
Agreed, I never thought of such a quick and easy way to make it responsive. Here I was thinking how he was going to use containers and breakpoints and stuff, but no, a template and the clipboard. Brilliant 👏👏👏
Thank you for constantly improving your skills and demonstrating new power apps features in these regular videos. We need these because repetitive lessons help us noobs learn from you. Some might say “this is the same as a previous video” but each release shows us new techniques and best practices that are difficult to gather from watching multiple videos. Your videos cover the basics over and over and include all the skills to produce professional simple solutions using the current features PowerApps have on offer.
Thank You for sharing this amazing feedback. Every video I make will have something new to offer as I do my homework on what I had shown earlier :) This video is packed with new stuff (validationstate, canvas control etc) + includes a mix of basic patch content.
I really like your kit mate… I also like the fact that you read all of your comments. This is just a comment giving you your flowers because you deserve them. I love your style of communication. Your work is always on point. You are an excellent instructor. Congratulations on setting up this membership structure and excellent business model for you … Keep winning Reza keep winning!
This video came at the perfect time!! I was just playing around with editable forms and referring to all I learned from you last time, and now this upgrades a lot for me! Thank you so much ❤️
😍ValidationState, I feel like I just foreseen this video coming. Thanks Reza. DataCards from Canvas control vs. Responsive Containers... Again I learn some new every time I watch your videos. Appreciate your time and effort you put to make those happen. 200k subscribers will land sooner than you think. Keep up.
Hi Reza, Can I ask a question about the DatePicker mordern control? Can we customize the display format of the control? Currently it is shown like "Wed, Sep 21, 2016", can we change it to display like "9/21/2016"?
I think a video just on this canvas control and really how to use it would be helpful. :) My mind blew up when I saw that in this video. As much as I've tried to make all my apps responsive on any device, it really is ultimately so much work, and I end up just designing for a desktop instead.
Thank you Reza! I would like to know how did you add a "All" selection and make it default to the Dapartment filter tab control, the Department choice column does not have a All option, you must added to the UI somehow.
Hi Reza, thanks for this video sharing. It works amazing. But I have the scrollable form (I have more than 100 questions in a form), and every time when I want to do a patch for a single question, the form will bring me back to the top of the screen. How do I solve that?
Most welcome! I have not tried with a scrollable form so not sure how to achieve that. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hey Reza, is there any way we can search people in new modern Form people picker. It gives only a list. No search option. I have to take classic people pickers in modern form
Love your videos Reza! I note that you do not show us how to create a people picker using the combo box. I have tried to do this using the modern controls and come into issues with the Fields not populating for a person. Any ideas on how I can resolve this?
Reza, as always, your videos are amazing. Thanks for sharing. BTW, I noticed this morning that the DelayedOutput property on the modern textbox control changed to TriggerOutput. For the validation state, I was comparing two strings, an initial text value (variable) and the Value property of the textbox. My TriggerOutput default value was "FocusOut" Every once and a while, the textbox value property didn't appear to contain the updated value I had typed after I clicked Submit. If I clicked Submit again, validation was true (had the correct value). I Changed the TriggerOutput to Delayed and now my results for validation check seem consistent. I know these controls are in preview, and we are on our own, but that threw me for a loop.
In the gallery control you added the color bar according to the department choice column format. How do we get the choice column color formatting information from SharePoint?
@@MichaelDeBlasis1369 There is a lot going on in community tab for members. Search for download link posted for this video there. If link expired, post a message on that community post and Il share an updated link
How did you get the Homescreen configured with the tiles on the Home screen setup with the Department navigation at the top and the +New setup etc? I managed to setup the 'Employee Info' screen' with your guidance, but all of a sudden you jumped to the Home screen which was pre-setup. How can I reproduce the Home Screen? I am missing a lot of info (Setup of maincontainer, HeaderContainer, and contents etc. which you seemed to have skipped in this video. I would love to learn how you did this ??
I have done many videos on gallery designs and filtering etc. Home screen is inspired from those videos. Video description has link to download entire app (members only - check description for details)
Hello Reza, I need your help. I have to create a Form which allow the user to enter a kind of table, something like a ordering some items, so he has to be able to insert as many as items he wants, any of your videos can guide thru this ?
Reza - can't express my gratitude. I've always wanted such a skill and never thought it attainable. I have one favor to ask - can you please add the version number to these videos? Exactly following your directions does not always create the same results. It would be great to start with a minimum number of variables. Again SO MANY THANKS!
Most welcome! I have done over 240+ videos so numbering them is not an option. Also, changing video titles and/or descriptions affects the search relevancy.
PowerApp beginner here: one thing that is generally bothering me is the copy-and-paste-hell i have to go through if I want change the behaviour or check the state of multiple elements. E.g. for checking all mandatory fields, is there a way to collect/ group them and do an If-check for all of them at once?
With the patch function and navigate. Am i correct in thinking that the Onsuccess option is only possible for a form? If there is a issue with connectivity and the patch fails, the user navigates to the on success screen anyway? Or do built in error functions within a IF statement cover when patch fails to update?
Hello Reza! I've got a Power App, where I'm using Patch function to copy data from one Sharepoint list to an another filtered by a date which is given by the user. Most Times I had to patch 100-400 rows, which takes 3-5 minutes - I'm using ForAll - based on the data size. Since the Power Apps runs these functions asynchronously I cannot catch when the run of the function is ended. Is there a way to catch when the ForAll loop is done with the patching? It is essential that the user cannot use the App until the patch is done, so I can use e.g. an indeterminated progress bar to prevent user action... Top of the cake that if the solution also works in case of RemoveIf function when I remove these lots of rows from the original Sharepoint list... Thanks!
I suggest using collection technique to patch all data at once rather than using a for loop. 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
For the department column. I have it as a single line of text. And I have another sharepoint list for departments. In my scenario i connected the modern control items to the sharepoint list. It saves the value fine but when I edit, the drop down is blank. Do you know if this is just a bug?
No, there is no such known bug. It’s probably something to do with how you have set it up. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, it works even with dataverse table? In my scenario i have datasouce from dataverse and innthe gallery "thisitem" didn't work well, expecially with choices column. Can you make a video to explain?
Yes, works with Dataverse as well. I may have done this in some video but do not remember which. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I tried the Modern Form with tabs and dropdown/combobox modern control. It seems that we can't set DefaultValue to ddl/combobox modern control within hidden datacard. At the first load of the form, the hidden ddl/combobox are blank :(. I have to make them visible first by changing the selected tab, and then the ddl and ccb are loaded with the good default value :(
Broo I wanted to ask if its possible to upload attachments to folder in a Document Library using powerapps and if so can we also create a column inside the folder via powerapps 😅
Thank you Reza, I am having a little different case - I don't want to use gallery, instead i want to just patch and allow edits with controls of sharepoint list - Please assist in such case. bascially a patch button that saves and allows edit/update to your sharepoint list directly
I do not have a video reference on that scenario. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Straight to the point, very nice once again! I really like the modern controls, but I haven't found a way to open a numeric virtual keyboard when using a modern text innput on mobile. Like when setting the VirrtualKeyboardMode in a classic text input. Is there any way?
@@RezaDorrani Nice! Just tried to to put it in a gallery but it doesn't seem to remember the value if you enter it with a keyboard. It does if you use the spinner. Will have to have a closer look. Thanks! Edit: ...and even that doesn't bring up the numeric keyboard on mobile
Hi Reza I have built many flows for my SharePoint Lists using your tutorial. Thanks for the good videos. Since today morning, I am unable to see the flows for my SharePoint List when i try to run a flow for a selected item in a list. The Flows are present in the Flow Library under Power Automate but cannot be seen under Automate -> in SharePoint Lists. Can you please help.
Hi Mrinal, I have not experienced the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thank you Reza for a new video, My power apps do not have a validationState, I know ValidationState is a modern control feature, how can I enable in my power apps
Hi Reza, when I try to update my sharepoint document library item's lookup property using the below Powerfx formula, error message is shown saying "Expecting a Record value, but of a different schema" and "Missing column, your formula is missing a column "Id" with a type number". Can you please help me understand why it's now working? Powerfx formula: Patch(Invoices, Gallery1.Selected, {'Vendor Bank Account': Dropdown1.Selected}) Gallery1 is a gallery of items from the "Invoices" Document library in Sharepoint and "Dropdown1"'s items come from another sharepoint list "Bank Accounts" is the sharepoint list that the lookup column "Vendor Bank Account" is trying to refer to.
I have not come across this issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, I got into huge confusion now.. If we have responsive templates as how you easily you added all controls in that trmplate then why do we have to use responsive formulas? like in what cases these templates are NOT useful?
Hi again Reza, another great video. When using a patch function, can you also use this along with a SubmitForm function? I have used some dropdown boxes using the patch functions as shown above which worked but on the same screen I also have a form which I want to submit as well. Is this possible?
@@RezaDorrani Thanks Reza, doesn't seem to work. I'll keep researching into it. If not may have to change the screen to have one or the other. If you do find a solution it would be a great video.
Hello, trying to understand this patch function you use. If i want to automatically update a field that is for example the email of the user logged into powerapps and i want to send that specific email to a Person column in SP, is it done also via Patch? or should i use something else? I have the field that picks up the user email with Disabled and default set to User().Email. Thanks. Overall this patch function will save me to use 2 forms to submit tickets via Power Apps.
@@RezaDorrani Bookmarked, other question, when it try adding the dropdown like you did in the video i don't get the values in power apps, is an empty list. L.E. Changed authoring version, now is live, thanks.
Hi Reza, amazing video and it helps me alot, thank you, and i have doubt on "convert text into currency formate based on region in power apps" , can you explain us about this covertion, i'll appreciate you great support
Most welcome! I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I'm implementing the validation states in the video, but it seems ValidationState for a modern date picker doesn't work (although I see you using it). Here is my code to check if modern date picker is blank. Am I missing something simple? It does work, but when I fill in a date, the Validation State doesn't return to "None". If(IsBlank(Self.SelectedDate) && varSaveClicked, "Error", "None")
My patch function is throwing me this error "The specified column is generated by the server and cant be specified" and its not updating the value. can you please check
I have not come across this issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thank you Reza, I notice using Modern Controls, if I use a form and use a People/Group field from sharepoint, it shows the options as numbers instead of people in Classic Controls. Have you experienced that?
Yes, if you see my last 4-5 videos on modern controls. I do mention it. In fact, I did a specific video on people picker as well where I deep dived into that topic.
I make videos when I receive multiple requests on a topic. Every quarter 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.
Is there a simpler way to reset modern controls? I know you've done it through variables, and the main reason I prefer the form is for a quicker way to reset the controls.
Not sure if you have a drag and drop app that is used for prioritising work, projects etc. That would be cool if you have found a way to do that Reza. I am sure if there is a way to do it, you would one of the first. Keeping my fingers crossed. 😊
There are pcf controls available for drag and drop. It could be used to expand on one of my videos. ruclips.net/video/-xSjy_rwQF8/видео.htmlsi=PyxB-YinnieioDMF
Thank you so mch for the great video. Your videos are at the top. I have one clarification question here please. Can we use patch function on a new record form on which all fields/controls are bind but one field is unbond (Suppose Free text box) and using patch function to set unbound control value to one of the field upon saving? Appreciate your thoughts please.
@@RezaDorrani Thank you for the reply. I am basically customizing list form instead of canvas app and new form will be created from within the list. if you please have any video on patching complete record and displaying a record in view mode when clicked on a list item then that would of great of you.
Below is the code i just came to know: SubmitForm(yourfrom);/*Step1:submit your form*/ Patch(yourdatasource, First(Sort(yourdatasource,Modified,Descending)),/*Step2:Find the record that has just been updated and update it with the Patch function*/ {Column1:"xxx",Column2:"XXX"} ) the problem with above code would be if 2 users added new record exactly at the same time and perhaps we can apply created by along with the sort?
@@HinaGeo Difficult for me to know about this by reading formulas in comments here + I do not have any bandwidth to look at this. Best to post your query/issue on forums powerusers.microsoft.com/
Hello, welcome to memberships! Here are all the details thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=c5EBcvvn3Eg
@@RezaDorrani Tank you Reza I am very new at power apps and already became a gold member, some how I couldn't find the app in the video there is one but it seem old version
@@ferhatyildiz4298 You can post a comment on any of the secured posts in community tab where links are shared. Mention about this video, and I will share the link
Hi Reza! Perfect as always. Thank you 🙃 Can you make a video of this scenario? Main source of DataVerse, but not directly accessible by other users (no license). Only the developer of the program has a license. (How to set the data source of a form to a collection?) How to use a Collection-based source for Forms Apps (when users don't have direct access to DataVerse). To record and update data from the form in DataVerse, use Power Automate (child and parent flows) which will be launched from PowerApps, data is transferred from PowerApps in JSON format and using Power Automate is recorded and updated in the main DataVerse source. How, using Power Automate, you can write JSON data received from PowerApps to the DataVerse source if there are choice, lookup fields. Sorry for my bad English. Thank you for your work and education 🤗
@@RezaDorrani Understand =) Maybe then in this part of the question? How to record and update data transmitted from PowerApps in JSON format (entered manually in text fields) using Power Automate to the DataVerse source, especially in the choice and lookup fields.
@@23mylifeis Even that is considered multiplexing. There is no way around hacking licensing. And how to do this via flows, I have not tried it so not sure
Can't find a good guide on how to patch ALL fields of some records. Example: I have a SP list database and a collection of items from that SP list that have to be edited. I want to make a patch that edit those elements (all they're fields without having to write every single one in the patch function)
Hi Reza! Love your videos, they are bomb as always. I have several interesting questions: 1) why in this case Patch(SpList; Defaults(SpList), { Title: txtTitle.Text}) one record (row) is created in the list, and in this case Patch(SpList, Defaults(SpList), { Title: txtTitle.Text}) - two (and one is empty)? The difference is only in ; after SpList. 2) My SP list has image-type column. Why in this case Patch(SpList, Defaults(SpList), { Title: txtTitle.Text, Image: Image.Image}) patch funktion works(although in the list, two records/rows are created again, one of which is blank), and in this case Patch(SpList; Defaults(SpList), { Title: txtTitle.Text, Image: Image.Image}) i am getting an error in the formula "The function Patch has some invalid arguments. The type of this argument Image does not match the expected type Record. Found type Image". Given a simple task, I cannot solve it 😀 I either get a lot of empty rows in the SP list, or I can't patch image-type column. How should i do it right? Many thanks in advance for your answers!
Im not sure why would you use ; It should be a , at least as per what I used in video. I have done video on image column and patch - you can check that.
I use submitform when I use Form control and use Patch when I use controls. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar to your use case.
If modern control have the 'Visible' property available, it is easier to implement a solution that handle all the constraints through this property. This prevents users to submit incomplete data and reduces time and efforts via less controls customization.
Hi Reza, when I try to update my sharepoint document library item's lookup property using the below Powerfx formula, error message is shown saying "Expecting a Record value, but of a different schema" and "Missing column, your formula is missing a column "Id" with a type number". Can you please help me understand why it's not working? Powerfx formula: Patch(Invoices, Gallery1.Selected, {'Vendor Bank Account': Dropdown1.Selected}) Gallery1 is a gallery of items from the "Invoices" Document library in Sharepoint and "Dropdown1"'s items come from another sharepoint list "Bank Accounts" is the sharepoint list that the lookup column "Vendor Bank Account" is trying to refer to.
I have not come across this issue and hence not sure what the cause could be. Debugging here on youtube comments is not an option. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Another blockbuster of a video. Using the Canvas control and its Datacards to convert an app to responsive is huge. It will reduce the amount of nested containers we need to create responsive apps. This is so cool and really appreciate your commitment to release new nuggets in your videos. Thank you so much for sharing again. Greatly appreciated. Downloading and adding it to my "Reza Environment" in my Tenant. 🤣🤣🤣
Awesome 👏
Thank You so much for the amazing feedback.
Let the “Reza Environment” keep growing 😊
@@RezaDorrani Yep, it keeps growing weekly. 😀
Agreed, I never thought of such a quick and easy way to make it responsive. Here I was thinking how he was going to use containers and breakpoints and stuff, but no, a template and the clipboard. Brilliant 👏👏👏
What I love about your tutorials is that they become a reference on how to use Power Apps correctly and smartly. Thank you.
So happy to hear that! Thanks so much for watching
Master class - I learn something new whenever I watch a Reza video. Thank you!
Glad to hear it!
Thank you for constantly improving your skills and demonstrating new power apps features in these regular videos. We need these because repetitive lessons help us noobs learn from you. Some might say “this is the same as a previous video” but each release shows us new techniques and best practices that are difficult to gather from watching multiple videos. Your videos cover the basics over and over and include all the skills to produce professional simple solutions using the current features PowerApps have on offer.
Thank You for sharing this amazing feedback.
Every video I make will have something new to offer as I do my homework on what I had shown earlier :)
This video is packed with new stuff (validationstate, canvas control etc) + includes a mix of basic patch content.
I really like your kit mate… I also like the fact that you read all of your comments. This is just a comment giving you your flowers because you deserve them. I love your style of communication. Your work is always on point. You are an excellent instructor. Congratulations on setting up this membership structure and excellent business model for you … Keep winning Reza keep winning!
Thank You so much for the feedback and all the good wishes 🙏
Modern Control looks cute, but I was in despair because I didn't know how to use it. I enjoy using it after watching this video.
thank you.
Glad I could help! My last 4-5 videos are all around modern controls.
And the learning continues... With Reza... Thanks for this great video👍
Thanks for watching!
This video came at the perfect time!! I was just playing around with editable forms and referring to all I learned from you last time, and now this upgrades a lot for me! Thank you so much ❤️
You're so welcome!
A Reza video always comes at a perfect time!!!😂
I´m a newbie, this video is gold for me.
Greetings from Chile.
Thanks
This is exactly the video I needed. Reza, you are the rock star of power apps.
Thanks for the compliment
😍ValidationState, I feel like I just foreseen this video coming. Thanks Reza. DataCards from Canvas control vs. Responsive Containers... Again I learn some new every time I watch your videos. Appreciate your time and effort you put to make those happen. 200k subscribers will land sooner than you think. Keep up.
Boom! Thank You so much
I swear you have video for everything. You're amazing 😍
Wow, thank you!
Fantastic video, I've learn a lot from your videos!
Thanks Juan
Didn't know about 'canvas' control, I'll try, looks amazing! Tx Reza.
Its a hidden gem
Reza, you make everything simple. Amazing technique to make applications responsive.. 🤩
Thank You so much
Have the same requirement and this video is a blessing! Thank you Reza!
You’re most welcome
Just another great video as always Reza! Nice seeing the new validation coding in action.
Thanks. The ValidationState is an awesome property
This is a excelent video Reza, thank you.
My pleasure!
Awesome video again. Thank you Reza.
My pleasure!
This is awesomely great. Thanks Raza for this video.
Glad you liked it!
Another great video. Thanks Reza!
Thanks for watching
Thank you Reza. And I use loom to record each tips of your video (each is a very short clip), as my knowledge quick reference.
Hi Reza, Can I ask a question about the DatePicker mordern control? Can we customize the display format of the control? Currently it is shown like "Wed, Sep 21, 2016", can we change it to display like "9/21/2016"?
I think a video just on this canvas control and really how to use it would be helpful. :) My mind blew up when I saw that in this video. As much as I've tried to make all my apps responsive on any device, it really is ultimately so much work, and I end up just designing for a desktop instead.
Glad it was helpful!
There are more good things coming with respect to responsive design. Lets wait for the future to unravel
Muchísimas gracias Reza ! . Mondays like this are less Mondays
I agree 😉
Fantastic video! Thank you!
You're very welcome!
Thanks Reeza For Your Boosting videos
Glad you like them!
Hi Reza, great video!! Just one question, @21:02, I am having an error when I add "btnSubmitClicked", is this button name? Thank you.
btnSubmitClicked is name of variable
Video description has link to download entire app (members only - check video description for details)
you're the best 👍
Thank You!!!
Great Video Reza. I was curious how patch new vs modify was setup and you nailed it. TY
Glad to hear that
Another great video Reza. Annoyingly I cannot get the red validation box around the modern date picker. Its the only one where I cant get it to work.
Certain modern controls are in preview. It might be a bug.
Great video! Is there a way to automatically scroll to the top of the canvas control when you select a record?
Thanks!
Im not aware of a way to do that.
Out-frigging-standing🔥😮
Thanks 👍
@Reza, thank you so much as always great video again.
My pleasure!
Thank you Reza! I would like to know how did you add a "All" selection and make it default to the Dapartment filter tab control, the Department choice column does not have a All option, you must added to the UI somehow.
ruclips.net/video/fnKqUf69wEg/видео.htmlsi=5SgSNVyhfEiKdCcb
@@RezaDorrani Excellent! Thank you so much!
Hi Reza, thanks for this video sharing. It works amazing. But I have the scrollable form (I have more than 100 questions in a form), and every time when I want to do a patch for a single question, the form will bring me back to the top of the screen. How do I solve that?
Most welcome!
I have not tried with a scrollable form so not sure how to achieve that. I recommend checking or posting your query on forums in case someone has done something similar
powerusers.microsoft.com
Hey Reza, is there any way we can search people in new modern Form people picker. It gives only a list. No search option. I have to take classic people pickers in modern form
Currently, no option
Hey Reza! Great video once again! Do you by chance have a guide on the card style gallery in this video?
I have done multiple videos on it.
Search for “reza power apps gallery designs”
Love your videos Reza! I note that you do not show us how to create a people picker using the combo box. I have tried to do this using the modern controls and come into issues with the Fields not populating for a person. Any ideas on how I can resolve this?
The reason I did not show is because currently modern combo box does not support it.
Thank you so much!
Reza, as always, your videos are amazing. Thanks for sharing. BTW, I noticed this morning that the DelayedOutput property on the modern textbox control changed to TriggerOutput. For the validation state, I was comparing two strings, an initial text value (variable) and the Value property of the textbox. My TriggerOutput default value was "FocusOut" Every once and a while, the textbox value property didn't appear to contain the updated value I had typed after I clicked Submit. If I clicked Submit again, validation was true (had the correct value). I Changed the TriggerOutput to Delayed and now my results for validation check seem consistent. I know these controls are in preview, and we are on our own, but that threw me for a loop.
Most welcome!
Im not aware of that change. Preview features can always have challenges.
In the gallery control you added the color bar according to the department choice column format. How do we get the choice column color formatting information from SharePoint?
I did not get it from SharePoint, I added the logic in Power App itself. Hardcoded formula!
@@RezaDorrani Thanks for replying so quickly. I appreciate your efforts as a consumer of your videos. Keep going ahead. 💪
How is that department home screen in this video setup? Is that 2 galleries nested? Looks great! Thanks again. Always helpful
Thats a single screen.
Gallery with tab control as filter.
I have done videos on it.
@@RezaDorraniI just signed up for silver to check it out. TY so much for doing all this for all of us.
@@MichaelDeBlasis1369 There is a lot going on in community tab for members. Search for download link posted for this video there.
If link expired, post a message on that community post and Il share an updated link
@@RezaDorraniI gotcha. I totally got it figured out. Looks like you adjust the wrap count to make it look that way. Cheers!
How did you get the Homescreen configured with the tiles on the Home screen setup with the Department navigation at the top and the +New setup etc? I managed to setup the 'Employee Info' screen' with your guidance, but all of a sudden you jumped to the Home screen which was pre-setup. How can I reproduce the Home Screen? I am missing a lot of info (Setup of maincontainer, HeaderContainer, and contents etc. which you seemed to have skipped in this video. I would love to learn how you did this ??
I have done many videos on gallery designs and filtering etc. Home screen is inspired from those videos.
Video description has link to download entire app (members only - check description for details)
@@RezaDorrani Thank you for your prompt response. Your content is excellent. I am very thankful for your resource
Hi Reza, As usual the tutoring is spot on. Can you please make a video on how to handle SharePoint search within text without delegation warning
I have done 3-4 videos on graph api and then sharepoint search api. I would recommend checking those.
Thank you Reza for a new video😊. Validation state is going to be very helpful. Was it not available for Classic controls? I guess not. 👍
ValidationState is a modern control feature!
Great Content👍
Thank you
Hello Reza, I need your help. I have to create a Form which allow the user to enter a kind of table, something like a ordering some items, so he has to be able to insert as many as items he wants, any of your videos can guide thru this ?
I don’t have a specific video on this, but may be my grid based videos may help.
Check playlist on editable grid on my channel.
Hi Reza, rather than showing all Choices, is there a way to filter choices(e.g, only show skills meeting certain condition)
How would you define criteria? Choices only returns the values as an array. You would need to hardcode logic in app.
Reza - can't express my gratitude. I've always wanted such a skill and never thought it attainable. I have one favor to ask - can you please add the version number to these videos? Exactly following your directions does not always create the same results. It would be great to start with a minimum number of variables. Again SO MANY THANKS!
Most welcome!
I have done over 240+ videos so numbering them is not an option. Also, changing video titles and/or descriptions affects the search relevancy.
PowerApp beginner here: one thing that is generally bothering me is the copy-and-paste-hell i have to go through if I want change the behaviour or check the state of multiple elements. E.g. for checking all mandatory fields, is there a way to collect/ group them and do an If-check for all of them at once?
Not a technique I am aware of for individual controls. If using form control then there is a way (covered that in my form control videos)
With the patch function and navigate. Am i correct in thinking that the Onsuccess option is only possible for a form? If there is a issue with connectivity and the patch fails, the user navigates to the on success screen anyway? Or do built in error functions within a IF statement cover when patch fails to update?
With Patch, you would need to do error handling. You can store result of Patch in a variable, check if error or not and accordingly navigate user.
Hi Reza, wondering how to reset a modern drop down control, we don't seem to have the same varReset we could set on the classic?
You would need to reset them using the standard Reset function
@@RezaDorrani Thank you!
Is there a preference as to where we should use Form control or individual controls like this application??
Its a choice. Whaver works best for you.
@@RezaDorrani if you need to allow attachments then I guess you still need form control or could use a mix?
@@mkavo You would need to use a flow as Patch does not support attachments.
16:29 very cool, thanks Reza
Validations are awesome! My next video will show some more...
Hello Reza!
I've got a Power App, where I'm using Patch function to copy data from one Sharepoint list to an another filtered by a date which is given by the user.
Most Times I had to patch 100-400 rows, which takes 3-5 minutes - I'm using ForAll - based on the data size. Since the Power Apps runs these functions asynchronously I cannot catch when the run of the function is ended.
Is there a way to catch when the ForAll loop is done with the patching? It is essential that the user cannot use the App until the patch is done, so I can use e.g. an indeterminated progress bar to prevent user action...
Top of the cake that if the solution also works in case of RemoveIf function when I remove these lots of rows from the original Sharepoint list...
Thanks!
I suggest using collection technique to patch all data at once rather than using a for loop.
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
@Reza, cool explained!!. Very helpfull
Glad it was helpful!
Hi, thanks for the content, a debt, my app was not responsive, was there an update or am I making something wrong?
Video is on patch function.
Responsive design is separate. Check my playlist on that.
For the department column. I have it as a single line of text. And I have another sharepoint list for departments. In my scenario i connected the modern control items to the sharepoint list. It saves the value fine but when I edit, the drop down is blank. Do you know if this is just a bug?
No, there is no such known bug. It’s probably something to do with how you have set it up.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, it works even with dataverse table?
In my scenario i have datasouce from dataverse and innthe gallery "thisitem" didn't work well, expecially with choices column.
Can you make a video to explain?
Yes, works with Dataverse as well.
I may have done this in some video but do not remember which.
I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I tried the Modern Form with tabs and dropdown/combobox modern control.
It seems that we can't set DefaultValue to ddl/combobox modern control within hidden datacard. At the first load of the form, the hidden ddl/combobox are blank :(. I have to make them visible first by changing the selected tab, and then the ddl and ccb are loaded with the good default value :(
Might have to be a bug
Thank you for a great video Reza! Could you also show us on how to create deep link for this patched form? TIA
I have done a video on deep linking. Similar concept can be applied here.
Can I have a link to that video please? Thanks
@@hereskieu1 youtube search “reza deep linking”
Broo I wanted to ask if its possible to upload attachments to folder in a Document Library using powerapps and if so can we also create a column inside the folder via powerapps 😅
Probably possible but not something that I have done
@@RezaDorraniRoger that!
Thank you Reza,
I am having a little different case - I don't want to use gallery, instead i want to just patch and allow edits with controls of sharepoint list - Please assist in such case.
bascially a patch button that saves and allows edit/update to your sharepoint list directly
I do not have a video reference on that scenario. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Straight to the point, very nice once again! I really like the modern controls, but I haven't found a way to open a numeric virtual keyboard when using a modern text innput on mobile. Like when setting the VirrtualKeyboardMode in a classic text input. Is there any way?
A new spin button control just released. Ideal for numeric scenarios.
@@RezaDorrani Nice! Just tried to to put it in a gallery but it doesn't seem to remember the value if you enter it with a keyboard. It does if you use the spinner. Will have to have a closer look. Thanks!
Edit: ...and even that doesn't bring up the numeric keyboard on mobile
@@slarti4242 I did not try only guessed. Plz note - modern controls are preview. So we will need to wait.
Amazing video - Reza can you explain please why Patch is performed in Set formula. Is it some Set/Patch trick?
Set variable value will contain details about the patch result. You can get details about the newly patched item.
Hi Reza
I have built many flows for my SharePoint Lists using your tutorial. Thanks for the good videos. Since today morning, I am unable to see the flows for my SharePoint List when i try to run a flow for a selected item in a list. The Flows are present in the Flow Library under Power Automate but cannot be seen under Automate -> in SharePoint Lists. Can you please help.
Hi Mrinal,
I have not experienced the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thank you Reza for a new video, My power apps do not have a validationState, I know ValidationState is a modern control feature, how can I enable in my power apps
Enable modern controls
ruclips.net/video/eNhCQ7Y2x7o/видео.htmlsi=tlP03iO-mXSd1gBa
Hi Reza, when I try to update my sharepoint document library item's lookup property using the below Powerfx formula, error message is shown saying "Expecting a Record value, but of a different schema" and "Missing column, your formula is missing a column "Id" with a type number". Can you please help me understand why it's now working?
Powerfx formula:
Patch(Invoices, Gallery1.Selected, {'Vendor Bank Account': Dropdown1.Selected})
Gallery1 is a gallery of items from the "Invoices" Document library in Sharepoint and "Dropdown1"'s items come from another sharepoint list "Bank Accounts" is the sharepoint list that the lookup column "Vendor Bank Account" is trying to refer to.
I have not come across this issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza,
I got into huge confusion now..
If we have responsive templates as how you easily you added all controls in that trmplate then why do we have to use responsive formulas? like in what cases these templates are NOT useful?
I use responsive templates all the time. No need to write responsive formulas.
Hi again Reza, another great video. When using a patch function, can you also use this along with a SubmitForm function?
I have used some dropdown boxes using the patch functions as shown above which worked but on the same screen I also have a form which I want to submit as well.
Is this possible?
After patch call the suvmitform function.
I have not tried this scenario though.
@@RezaDorrani Thanks Reza, doesn't seem to work. I'll keep researching into it. If not may have to change the screen to have one or the other. If you do find a solution it would be a great video.
@@PsYc87 I have not run into any issues with it so not sure. No plans for a video on this topic.
Hello, trying to understand this patch function you use. If i want to automatically update a field that is for example the email of the user logged into powerapps and i want to send that specific email to a Person column in SP, is it done also via Patch? or should i use something else? I have the field that picks up the user email with Disabled and default set to User().Email. Thanks.
Overall this patch function will save me to use 2 forms to submit tickets via Power Apps.
rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
@@RezaDorrani Bookmarked, other question, when it try adding the dropdown like you did in the video i don't get the values in power apps, is an empty list. L.E. Changed authoring version, now is live, thanks.
Hi Reza, amazing video and it helps me alot, thank you, and i have doubt on "convert text into currency formate based on region in power apps" , can you explain us about this covertion, i'll appreciate you great support
Most welcome!
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I'm implementing the validation states in the video, but it seems ValidationState for a modern date picker doesn't work (although I see you using it).
Here is my code to check if modern date picker is blank. Am I missing something simple? It does work, but when I fill in a date, the Validation State doesn't return to "None".
If(IsBlank(Self.SelectedDate) && varSaveClicked, "Error", "None")
There is a bug where it still shows the outline but if you submit it will go through.
@@RezaDorrani Ah of course there is. :) Thanks much.
@@glennbullion9069 Most of the Modern controls are in preview.
@@RezaDorrani I know, but I can't help but use them. They're shiny.
@@glennbullion9069 Then you need to accept that there will be a few challenges along the way :)
My patch function is throwing me this error "The specified column is generated by the server and cant be specified" and its not updating the value. can you please check
I have not come across this issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Another BOOM !! 💥💥💥💥💥💥💥💥
Thanks
101k 👍. More power to you.
🎉
Thank you Reza, I notice using Modern Controls, if I use a form and use a People/Group field from sharepoint, it shows the options as numbers instead of people in Classic Controls. Have you experienced that?
Yes, if you see my last 4-5 videos on modern controls. I do mention it.
In fact, I did a specific video on people picker as well where I deep dived into that topic.
Great video. How about people picker? Single or multiple selection
Modern controls do not work well with people pickers. Use the classic control and patch that.
Hello Reza, can you make a video to show us how to print invoice with multiple pages and header and footer like in access database, thanks.
I make videos when I receive multiple requests on a topic. Every quarter 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.
Is there a simpler way to reset modern controls? I know you've done it through variables, and the main reason I prefer the form is for a quicker way to reset the controls.
No. The current best option is as shown in video.
Not sure if you have a drag and drop app that is used for prioritising work, projects etc. That would be cool if you have found a way to do that Reza. I am sure if there is a way to do it, you would one of the first. Keeping my fingers crossed. 😊
There are pcf controls available for drag and drop. It could be used to expand on one of my videos.
ruclips.net/video/-xSjy_rwQF8/видео.htmlsi=PyxB-YinnieioDMF
@@RezaDorrani I knew it. You just don't let us down. 😍
Thank you so mch for the great video. Your videos are at the top. I have one clarification question here please. Can we use patch function on a new record form on which all fields/controls are bind but one field is unbond (Suppose Free text box) and using patch function to set unbound control value to one of the field upon saving? Appreciate your thoughts please.
Combination of form and Patch? Why not use one or the other?
@@RezaDorrani Thank you for the reply. I am basically customizing list form instead of canvas app and new form will be created from within the list. if you please have any video on patching complete record and displaying a record in view mode when clicked on a list item then that would of great of you.
Below is the code i just came to know:
SubmitForm(yourfrom);/*Step1:submit your form*/
Patch(yourdatasource,
First(Sort(yourdatasource,Modified,Descending)),/*Step2:Find the record that has just been updated and update it with the Patch function*/
{Column1:"xxx",Column2:"XXX"}
)
the problem with above code would be if 2 users added new record exactly at the same time and perhaps we can apply created by along with the sort?
@@HinaGeo Difficult for me to know about this by reading formulas in comments here + I do not have any bandwidth to look at this. Best to post your query/issue on forums powerusers.microsoft.com/
Hi Reza Thanks for this amazing tutorial, I have become a member and pls let me know how can i download the app, thank you...
Hello, welcome to memberships!
Here are all the details thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=c5EBcvvn3Eg
@@RezaDorrani Tank you Reza I am very new at power apps and already became a gold member, some how I couldn't find the app in the video there is one but it seem old version
@@ferhatyildiz4298 You can post a comment on any of the secured posts in community tab where links are shared. Mention about this video, and I will share the link
Hi Reza, would you be so kind to reshare the link to this sample app please? Thank you.
You will need to make the request on the secure link for this video which was shared on Community Tab.
@@RezaDorrani OK, will do, thank you very much.
Hi Reza! Perfect as always. Thank you 🙃
Can you make a video of this scenario? Main source of DataVerse, but not directly accessible by other users (no license). Only the developer of the program has a license.
(How to set the data source of a form to a collection?)
How to use a Collection-based source for Forms Apps (when users don't have direct access to DataVerse). To record and update data from the form in DataVerse, use Power Automate (child and parent flows) which will be launched from PowerApps, data is transferred from PowerApps in JSON format and using Power Automate is recorded and updated in the main DataVerse source.
How, using Power Automate, you can write JSON data received from PowerApps to the DataVerse source if there are choice, lookup fields.
Sorry for my bad English. Thank you for your work and education 🤗
Multiplexing -> All users will need a license if using Dataverse even if loading it via collection.
@@RezaDorrani Understand =)
Maybe then in this part of the question?
How to record and update data transmitted from PowerApps in JSON format (entered manually in text fields) using Power Automate to the DataVerse source, especially in the choice and lookup fields.
@@23mylifeis Even that is considered multiplexing. There is no way around hacking licensing.
And how to do this via flows, I have not tried it so not sure
@@RezaDorrani Thank you for your time! ))
Sir i don't know about your share point list?
Video description has link to download entire solution (members only - check description for details)
Can't find a good guide on how to patch ALL fields of some records. Example: I have a SP list database and a collection of items from that SP list that have to be edited. I want to make a patch that edit those elements (all they're fields without having to write every single one in the patch function)
ruclips.net/video/Tviar3UFFLo/видео.htmlsi=4c9AxN9A0jDGlcy2
Hi Reza! Love your videos, they are bomb as always. I have several interesting questions:
1) why in this case Patch(SpList; Defaults(SpList), { Title: txtTitle.Text}) one record (row) is created in the list, and in this case Patch(SpList, Defaults(SpList), { Title: txtTitle.Text}) - two (and one is empty)? The difference is only in ; after SpList.
2) My SP list has image-type column. Why in this case Patch(SpList, Defaults(SpList), { Title: txtTitle.Text, Image: Image.Image}) patch funktion works(although in the list, two records/rows are created again, one of which is blank), and in this case Patch(SpList; Defaults(SpList), { Title: txtTitle.Text, Image: Image.Image}) i am getting an error in the formula "The function Patch has some invalid arguments. The type of this argument Image does not match the expected type Record. Found type Image".
Given a simple task, I cannot solve it 😀 I either get a lot of empty rows in the SP list, or I can't patch image-type column. How should i do it right? Many thanks in advance for your answers!
Im not sure why would you use ;
It should be a , at least as per what I used in video.
I have done video on image column and patch - you can check that.
Hi, is ist possibile to Patch Attachments ? THX
Patch does not support attachments
NICE I LIKE IT
👍
can you explain home screen modern controls
I have done many videos on modern controls that are all in a playlist.
@@RezaDorrani actually iam strugling to add home screen in this video type can you suggest any step by step link
@@kamalakarreddyuppala3772 I have done it in other videos just that I dont remember which.
this video only
@@kamalakarreddyuppala3772 this video only has 1 video. I have done other videos where I have built a similar home page.
I didnt realize how cool the canvas control was
Me too
finally found validations using patch
oh its using modern :( :(
and not using forms : (
I use submitform when I use Form control and use Patch when I use controls.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar to your use case.
🙌🏻 🙌🏻 🙌🏻👏👏👏
Liking the clothing style Reza
Thanks!
That was my birthday gift to myself:)
If modern control have the 'Visible' property available, it is easier to implement a solution that handle all the constraints through this property. This prevents users to submit incomplete data and reduces time and efforts via less controls customization.
I mean customization could be done just on the 'Visible' or 'DisplayMode' property of the Submit button.
Does it not have a visible property?
The .value doesn't work at all
I have not experienced this issue
⭐️⭐️⭐️⭐️⭐️
Thanks
I wish I had Hadley Parker salary
Sorry but did not get the context
Fc
?
Hi Reza, when I try to update my sharepoint document library item's lookup property using the below Powerfx formula, error message is shown saying "Expecting a Record value, but of a different schema" and "Missing column, your formula is missing a column "Id" with a type number". Can you please help me understand why it's not working?
Powerfx formula:
Patch(Invoices, Gallery1.Selected, {'Vendor Bank Account': Dropdown1.Selected})
Gallery1 is a gallery of items from the "Invoices" Document library in Sharepoint and "Dropdown1"'s items come from another sharepoint list "Bank Accounts" is the sharepoint list that the lookup column "Vendor Bank Account" is trying to refer to.
I have not come across this issue and hence not sure what the cause could be.
Debugging here on youtube comments is not an option.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com