Power Apps PATCH function Tutorial with Modern Controls

Подписаться 130 тыс.

Просмотров 55 тыс.

50% 1

In this step-by-step Power Apps tutorial, you'll learn how to work with the Patch function. Discover how to leverage the power of Patch in Power Apps, enabling you to seamlessly insert or update records in your data source. We'll take Patch to the next level by integrating it with modern controls to add or update data in a SharePoint List.
Learn how to use the Patch function to effortlessly add and modify items in a SharePoint List while performing validations along the way. This involves utilizing the new ValidationState property of Modern controls. Video will show how to set values for various types of SharePoint columns, such as Text, Number, Choice, and Multi-select Lookups.
Video will also demonstrate how to enhance the user experience for your Canvas Power Apps by making your Patch Form Screen Responsive. This involves incorporating a scrollable Canvas control within a Responsive container.
Power Apps Modern controls are a game-changer, reducing the number of controls used in your apps, offering easy configuration, boosting performance, and speeding up app development.
⬇️ Download the Power App showcased in the video:
Exclusive for Channel Members (Silver 🥈 & Gold 🥇 Club)
Find the download link in the Community Tab for Members
To become a member, click here: ru-vid.comjoin
Power Apps for Beginners
• Power Apps for Beginners
PowerApps Patch Function
• Power Apps Patch Function
Power Apps Modern Controls and Themes
• Modern controls and th...
#PowerApps #PowerPlatform #SharePoint #Patch
Table of Contents:
00:00 - Introduction to PATCH function in PowerApps with Modern Controls
00:44 - Scenario in video related to Patch function & modern controls
02:27 - Build your own Form Screen using Modern Controls
08:24 - Set Default values for Modern Controls
11:38 - Patch function usage
16:28 - Validations before Patching using Modern Controls
21:53 - Make PATCH Form screen Responsive
24:40 - READY to subscribe to Reza Dorrani’s channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani

Наука

Опубликовано:

20 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 231

@dougydoe 8 месяцев назад

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. 🤣🤣🤣

@RezaDorrani 8 месяцев назад

Awesome 👏 Thank You so much for the amazing feedback. Let the “Reza Environment” keep growing 😊

@dougydoe 8 месяцев назад

@@RezaDorrani Yep, it keeps growing weekly. 😀

@greg2kdotcom 8 месяцев назад

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 👏👏👏

@AhmedBalfaqih 8 дней назад

What I love about your tutorials is that they become a reference on how to use Power Apps correctly and smartly. Thank you.

@RezaDorrani 8 дней назад

So happy to hear that! Thanks so much for watching

@DuncanCunningham 8 месяцев назад

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.

@RezaDorrani 8 месяцев назад

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.

@shanf1862 8 месяцев назад

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 ❤️

@RezaDorrani 8 месяцев назад

You're so welcome!

@GustavoRoyetRojas 8 месяцев назад

A Reza video always comes at a perfect time!!!😂

@kevinjoseph9023 8 месяцев назад

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!

@RezaDorrani 8 месяцев назад

Thank You so much for the feedback and all the good wishes 🙏

8 месяцев назад

😍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.

@RezaDorrani 8 месяцев назад

Boom! Thank You so much

@michaelbrians338 4 месяца назад

Master class - I learn something new whenever I watch a Reza video. Thank you!

@RezaDorrani 4 месяца назад

Glad to hear it!

@btoz6237 8 месяцев назад

Just another great video as always Reza! Nice seeing the new validation coding in action.

@RezaDorrani 8 месяцев назад

Thanks. The ValidationState is an awesome property

@chaitanyaturankar9512 8 месяцев назад

Have the same requirement and this video is a blessing! Thank you Reza!

@RezaDorrani 8 месяцев назад

You’re most welcome

@DirkManes 4 месяца назад

This is exactly the video I needed. Reza, you are the rock star of power apps.

@RezaDorrani 4 месяца назад

Thanks for the compliment

@AMindGame 5 месяцев назад

I swear you have video for everything. You're amazing 😍

@RezaDorrani 5 месяцев назад

Wow, thank you!

@patoquiroz9627 5 месяцев назад

I´m a newbie, this video is gold for me. Greetings from Chile.

@RezaDorrani 5 месяцев назад

Thanks

@masuto74 8 месяцев назад

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.

@RezaDorrani 8 месяцев назад

Glad I could help! My last 4-5 videos are all around modern controls.

@GustavoRoyetRojas 8 месяцев назад

Didn't know about 'canvas' control, I'll try, looks amazing! Tx Reza.

@RezaDorrani 8 месяцев назад

Its a hidden gem

@oluwatobipaul6171 8 месяцев назад

Awesome video again. Thank you Reza.

@RezaDorrani 8 месяцев назад

My pleasure!

@juancarlosvallecillo4533 4 месяца назад

Fantastic video, I've learn a lot from your videos!

@RezaDorrani 4 месяца назад

Thanks Juan

@atehaa 6 месяцев назад

Another great video. Thanks Reza!

@RezaDorrani 6 месяцев назад

Thanks for watching

@MichaelDeBlasis1369 Месяц назад

Great Video Reza. I was curious how patch new vs modify was setup and you nailed it. TY

@RezaDorrani Месяц назад

Glad to hear that

@RodCMz 4 месяца назад

This is a excelent video Reza, thank you.

@RezaDorrani 4 месяца назад

My pleasure!

@zhisonghuo 5 месяцев назад

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.

@zhisonghuo 4 месяца назад

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"?

@olisaemekaaghabuilo8688 8 месяцев назад

This is awesomely great. Thanks Raza for this video.

@RezaDorrani 8 месяцев назад

Glad you liked it!

@michaelcollett7284 4 месяца назад

Fantastic video! Thank you!

@RezaDorrani 4 месяца назад

You're very welcome!

@tejuk6657 2 месяца назад

Reza, you make everything simple. Amazing technique to make applications responsive.. 🤩

@RezaDorrani 2 месяца назад

Thank You so much

@gilbertpradier 8 месяцев назад

@Reza, thank you so much as always great video again.

@RezaDorrani 8 месяцев назад

My pleasure!

@andrewburns9817 4 дня назад

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.

@RezaDorrani 4 дня назад

Most welcome! Im not aware of that change. Preview features can always have challenges.

@raslaankhan5146 8 месяцев назад

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. 👍

@RezaDorrani 8 месяцев назад

ValidationState is a modern control feature!

@kamalakarreddyuppala3772 8 месяцев назад

Thanks Reeza For Your Boosting videos

@RezaDorrani 8 месяцев назад

Glad you like them!

@javiergamella7646 7 месяцев назад

@Reza, cool explained!!. Very helpfull

@RezaDorrani 7 месяцев назад

Glad it was helpful!

@glennbullion9069 8 месяцев назад

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.

@RezaDorrani 8 месяцев назад

Glad it was helpful! There are more good things coming with respect to responsive design. Lets wait for the future to unravel

@Jaisreeradhekrishna 8 месяцев назад

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

@RezaDorrani 8 месяцев назад

I have done 3-4 videos on graph api and then sharepoint search api. I would recommend checking those.

@raulcsg 8 месяцев назад

Muchísimas gracias Reza ! . Mondays like this are less Mondays

@RezaDorrani 8 месяцев назад

I agree 😉

@jonathangaw2061 8 месяцев назад

you're the best 👍

@RezaDorrani 8 месяцев назад

Thank You!!!

@madhupsharma1300 2 месяца назад

Great Content👍

@RezaDorrani 2 месяца назад

Thank you

@phoenixsands 8 месяцев назад

Hey Reza! Great video once again! Do you by chance have a guide on the card style gallery in this video?

@RezaDorrani 8 месяцев назад

I have done multiple videos on it. Search for “reza power apps gallery designs”

@JPPVCC 8 месяцев назад

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!

@RezaDorrani 8 месяцев назад

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.

@theintjengineer 8 месяцев назад

Out-frigging-standing🔥😮

@RezaDorrani 8 месяцев назад

Thanks 👍

@user-xq5vk8nw7p 7 месяцев назад

Great video! Is there a way to automatically scroll to the top of the canvas control when you select a record?

@RezaDorrani 7 месяцев назад

Thanks! Im not aware of a way to do that.

@jameshart9519 Месяц назад

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.

@RezaDorrani Месяц назад

Certain modern controls are in preview. It might be a bug.

@slarti4242 8 месяцев назад

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 8 месяцев назад

A new spin button control just released. Ideal for numeric scenarios.

@slarti4242 8 месяцев назад

@@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

@RezaDorrani 8 месяцев назад

@@slarti4242 I did not try only guessed. Plz note - modern controls are preview. So we will need to wait.

@hamidaahmed4869 5 месяцев назад

NICE I LIKE IT

@RezaDorrani 5 месяцев назад

👍

@raslaankhan5146 8 месяцев назад

101k 👍. More power to you.

@RezaDorrani 8 месяцев назад

🎉

@kyleegray1652 Месяц назад

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?

@RezaDorrani Месяц назад

The reason I did not show is because currently modern combo box does not support it.

@kyleegray1652 Месяц назад

Thank you so much!

@user-ju8hf2qd2w 8 месяцев назад

Amazing video - Reza can you explain please why Patch is performed in Set formula. Is it some Set/Patch trick?

@RezaDorrani 8 месяцев назад

Set variable value will contain details about the patch result. You can get details about the newly patched item.

@user-ed9nr2wx7k 6 месяцев назад

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?

@RezaDorrani 6 месяцев назад

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

@rajeshr9176 8 месяцев назад

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

@RezaDorrani 8 месяцев назад

Enable modern controls ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-eNhCQ7Y2x7o.htmlsi=tlP03iO-mXSd1gBa

@MichaelDeBlasis1369 3 месяца назад

How is that department home screen in this video setup? Is that 2 galleries nested? Looks great! Thanks again. Always helpful

@RezaDorrani 3 месяца назад

Thats a single screen. Gallery with tab control as filter. I have done videos on it.

@MichaelDeBlasis1369 3 месяца назад

@@RezaDorraniI just signed up for silver to check it out. TY so much for doing all this for all of us.

@RezaDorrani 3 месяца назад

@@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

@MichaelDeBlasis1369 3 месяца назад

@@RezaDorraniI gotcha. I totally got it figured out. Looks like you adjust the wrap count to make it look that way. Cheers!

@ronbakker1300 8 месяцев назад

16:29 very cool, thanks Reza

@RezaDorrani 8 месяцев назад

Validations are awesome! My next video will show some more...

@spen2431 8 месяцев назад

Another BOOM !! 💥💥💥💥💥💥💥💥

@RezaDorrani 8 месяцев назад

Thanks

@Aristotin 5 месяцев назад

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.

@RezaDorrani 5 месяцев назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fnKqUf69wEg.htmlsi=5SgSNVyhfEiKdCcb

@Aristotin 5 месяцев назад

@@RezaDorrani Excellent! Thank you so much!

@user-ei4tk8gf7m 8 месяцев назад

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

@RezaDorrani 8 месяцев назад

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

@hasanahmad 8 месяцев назад

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?

@RezaDorrani 8 месяцев назад

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.

@user-gb9fn7cn9h 4 месяца назад

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!

@RezaDorrani 4 месяца назад

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.

@HinaGeo 3 месяца назад

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 3 месяца назад

Combination of form and Patch? Why not use one or the other?

@HinaGeo 3 месяца назад

@@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.

@HinaGeo 3 месяца назад

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?

@RezaDorrani 3 месяца назад

@@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/

@zulnordin8041 8 месяцев назад

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. 😊

@RezaDorrani 8 месяцев назад

There are pcf controls available for drag and drop. It could be used to expand on one of my videos. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--xSjy_rwQF8.htmlsi=PyxB-YinnieioDMF

@zulnordin8041 8 месяцев назад

@@RezaDorrani I knew it. You just don't let us down. 😍

@bernarat 8 месяцев назад

Great video. How about people picker? Single or multiple selection

@RezaDorrani 8 месяцев назад

Modern controls do not work well with people pickers. Use the classic control and patch that.

@RyanSmith-mh1lj 8 месяцев назад

Hi Reza, great video!! Just one question, @21:02, I am having an error when I add "btnSubmitClicked", is this button name? Thank you.

@RezaDorrani 8 месяцев назад

btnSubmitClicked is name of variable Video description has link to download entire app (members only - check video description for details)

@23mylifeis 8 месяцев назад

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 8 месяцев назад

Multiplexing -> All users will need a license if using Dataverse even if loading it via collection.

@23mylifeis 8 месяцев назад

@@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.

@RezaDorrani 8 месяцев назад

@@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

@23mylifeis 8 месяцев назад

@@RezaDorrani Thank you for your time! ))

@PsYc87 7 месяцев назад

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 7 месяцев назад

After patch call the suvmitform function. I have not tried this scenario though.

@PsYc87 7 месяцев назад

@@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.

@RezaDorrani 7 месяцев назад

@@PsYc87 I have not run into any issues with it so not sure. No plans for a video on this topic.

@davidoddy4668 4 месяца назад

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?

@RezaDorrani 4 месяца назад

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.

@gianmarcomilia7661 8 месяцев назад

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?

@RezaDorrani 8 месяцев назад

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

@user-sm7kr8ok2m 5 месяцев назад

Hi Reza, rather than showing all Choices, is there a way to filter choices(e.g, only show skills meeting certain condition)

@RezaDorrani 5 месяцев назад

How would you define criteria? Choices only returns the values as an array. You would need to hardcode logic in app.

@user-wm1bg5xi3q 6 месяцев назад

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?

@RezaDorrani 6 месяцев назад

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)

@s961201 6 месяцев назад

🙌🏻 🙌🏻 🙌🏻👏👏👏

@jorgewilliam9622 Месяц назад

Hi, thanks for the content, a debt, my app was not responsive, was there an update or am I making something wrong?

@RezaDorrani Месяц назад

Video is on patch function. Responsive design is separate. Check my playlist on that.

@AjayKumar-qn3nx Месяц назад

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

@RezaDorrani Месяц назад

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

@studie75 8 месяцев назад

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 ??

@RezaDorrani 8 месяцев назад

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)

@studie75 8 месяцев назад

@@RezaDorrani Thank you for your prompt response. Your content is excellent. I am very thankful for your resource

@hereskieu1 8 месяцев назад

Thank you for a great video Reza! Could you also show us on how to create deep link for this patched form? TIA

@RezaDorrani 8 месяцев назад

I have done a video on deep linking. Similar concept can be applied here.

@hereskieu1 8 месяцев назад

Can I have a link to that video please? Thanks

@RezaDorrani 8 месяцев назад

@@hereskieu1 youtube search “reza deep linking”

@DAXifiedSatish 8 месяцев назад

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

@RezaDorrani 8 месяцев назад

Currently, no option

@kurdishkurd6259 8 месяцев назад

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.

@RezaDorrani 8 месяцев назад

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.

@MrinalMehra 8 месяцев назад

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.

@RezaDorrani 8 месяцев назад

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

@mgallagherco 8 месяцев назад

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.

@RezaDorrani 8 месяцев назад

No. The current best option is as shown in video.

@mohemmadriyazkalva3197 8 месяцев назад

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?

@RezaDorrani 8 месяцев назад

I did not get it from SharePoint, I added the logic in Power App itself. Hardcoded formula!

@mohemmadriyazkalva3197 8 месяцев назад

@@RezaDorrani Thanks for replying so quickly. I appreciate your efforts as a consumer of your videos. Keep going ahead. 💪

@Soulebi03 6 месяцев назад

finally found validations using patch

@Soulebi03 6 месяцев назад

oh its using modern :( :( and not using forms : (

@RezaDorrani 6 месяцев назад

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.

@tluu8501 8 месяцев назад

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?

@RezaDorrani 8 месяцев назад

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

@sitecraft_ro 8 месяцев назад

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 8 месяцев назад

rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/

@sitecraft_ro 8 месяцев назад

@@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.

@terri78 2 месяца назад

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?

@RezaDorrani 2 месяца назад

You would need to reset them using the standard Reset function

@terri78 2 месяца назад

@@RezaDorrani Thank you!

@mad056 8 месяцев назад

Liking the clothing style Reza

@RezaDorrani 8 месяцев назад

Thanks! That was my birthday gift to myself:)

@raslaankhan5146 8 месяцев назад

Is there a preference as to where we should use Form control or individual controls like this application??

@RezaDorrani 8 месяцев назад

Its a choice. Whaver works best for you.

@mkavo 8 месяцев назад

@@RezaDorrani if you need to allow attachments then I guess you still need form control or could use a mix?

@RezaDorrani 8 месяцев назад

@@mkavo You would need to use a flow as Patch does not support attachments.

@ethanhudson3407 8 месяцев назад

I didnt realize how cool the canvas control was

@RezaDorrani 8 месяцев назад

Me too

@kevinnguyen3635 8 месяцев назад

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 :(

@RezaDorrani 8 месяцев назад

Might have to be a bug

@UBOTSYT 8 месяцев назад

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 😅

@RezaDorrani 8 месяцев назад

Probably possible but not something that I have done

@UBOTSYT 8 месяцев назад

@@RezaDorraniRoger that!

@user-kx5pp7lq4h 5 месяцев назад

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.

@RezaDorrani 5 месяцев назад

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

@myshare4435 8 месяцев назад

Hi Reza, nice video but I m having couple of issues, 1. @21:16, some reason Age column is not validating 2. date column is also, not validating, not sure what I am doing wrong? Where you have created btnSubmitClicked variable? its giving me error as well, appreciate if you assist, thank you.

@RezaDorrani 8 месяцев назад

Video description has link to download entire app (members only - check description for details) I have not come across any issues so not sure whats the cause for your issues.

@myshare4435 8 месяцев назад

@@RezaDorrani , sure thank you. I will check it out, appreciate your answer!

@ichdu1283 8 месяцев назад

Hi, is ist possibile to Patch Attachments ? THX

@RezaDorrani 8 месяцев назад

Patch does not support attachments

@glennbullion9069 8 месяцев назад

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")

@RezaDorrani 8 месяцев назад

There is a bug where it still shows the outline but if you submit it will go through.

@glennbullion9069 8 месяцев назад

@@RezaDorrani Ah of course there is. :) Thanks much.

@RezaDorrani 8 месяцев назад

@@glennbullion9069 Most of the Modern controls are in preview.

@glennbullion9069 8 месяцев назад

@@RezaDorrani I know, but I can't help but use them. They're shiny.

@RezaDorrani 8 месяцев назад

@@glennbullion9069 Then you need to accept that there will be a few challenges along the way :)

@user-gp3ze8mb8k 5 месяцев назад

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

@RezaDorrani 5 месяцев назад

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

@GustavoRoyetRojas 8 месяцев назад

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.

@GustavoRoyetRojas 8 месяцев назад

I mean customization could be done just on the 'Visible' or 'DisplayMode' property of the Submit button.

@RezaDorrani 8 месяцев назад

Does it not have a visible property?

@mikah4051 8 месяцев назад

⭐️⭐️⭐️⭐️⭐️

@RezaDorrani 8 месяцев назад

Thanks

@ET-zf9qs 13 дней назад

Hi Reza, would you be so kind to reshare the link to this sample app please? Thank you.

@RezaDorrani 13 дней назад

You will need to make the request on the secure link for this video which was shared on Community Tab.

@ET-zf9qs 13 дней назад

@@RezaDorrani OK, will do, thank you very much.

@kamalakarreddyuppala3772 6 месяцев назад

can you explain home screen modern controls

@RezaDorrani 6 месяцев назад

I have done many videos on modern controls that are all in a playlist.

@kamalakarreddyuppala3772 6 месяцев назад

@@RezaDorrani actually iam strugling to add home screen in this video type can you suggest any step by step link

@RezaDorrani 6 месяцев назад

@@kamalakarreddyuppala3772 I have done it in other videos just that I dont remember which.

@kamalakarreddyuppala3772 6 месяцев назад

this video only

@RezaDorrani 6 месяцев назад

@@kamalakarreddyuppala3772 this video only has 1 video. I have done other videos where I have built a similar home page.

@lydiasusanna7309 4 месяца назад

The .value doesn't work at all

@RezaDorrani 4 месяца назад

I have not experienced this issue

@MrKhulaid 8 месяцев назад

I wish I had Hadley Parker salary

@RezaDorrani 8 месяцев назад

Sorry but did not get the context

@user-sm7kr8ok2m 5 месяцев назад

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.

@RezaDorrani 5 месяцев назад

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