Power Apps PATCH function Tutorial with Modern Controls
Vložit
- čas přidán 29. 07. 2024
- 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: czcams.com/users/rezadorranijoin
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 - Věda a technologie
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
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 🙏
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.
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!!!😂
Master class - I learn something new whenever I watch a Reza video. Thank you!
Glad to hear it!
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.
😍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
Have the same requirement and this video is a blessing! Thank you Reza!
You’re most welcome
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
Just another great video as always Reza! Nice seeing the new validation coding in action.
Thanks. The ValidationState is an awesome property
Didn't know about 'canvas' control, I'll try, looks amazing! Tx Reza.
Its a hidden gem
I swear you have video for everything. You're amazing 😍
Wow, thank you!
Muchísimas gracias Reza ! . Mondays like this are less Mondays
I agree 😉
Fantastic video! Thank you!
You're very welcome!
Awesome video again. Thank you Reza.
My pleasure!
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"?
@Reza, thank you so much as always great video again.
My pleasure!
Another great video. Thanks Reza!
Thanks for watching
This is awesomely great. Thanks Raza for this video.
Glad you liked it!
This is a excelent video Reza, thank you.
My pleasure!
Fantastic video, I've learn a lot from your videos!
Thanks Juan
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.
Thanks Reeza For Your Boosting videos
Glad you like them!
Reza, you make everything simple. Amazing technique to make applications responsive.. 🤩
Thank You so much
Great Video Reza. I was curious how patch new vs modify was setup and you nailed it. TY
Glad to hear that
Out-frigging-standing🔥😮
Thanks 👍
you're the best 👍
Thank You!!!
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
16:29 very cool, thanks Reza
Validations are awesome! My next video will show some more...
@Reza, cool explained!!. Very helpfull
Glad it was helpful!
Another BOOM !! 💥💥💥💥💥💥💥💥
Thanks
Great Content👍
Thank you
101k 👍. More power to you.
🎉
NICE I LIKE IT
👍
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!
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”
🙌🏻 🙌🏻 🙌🏻👏👏👏
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.
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.
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.
Liking the clothing style Reza
Thanks!
That was my birthday gift to myself:)
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! 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.
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.
czcams.com/video/fnKqUf69wEg/video.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
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.
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
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
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
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.
I didnt realize how cool the canvas control was
Me too
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.
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.
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!
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.
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)
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
czcams.com/video/eNhCQ7Y2x7o/video.htmlsi=tlP03iO-mXSd1gBa
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)
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.
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!
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! ))
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! 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.
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.
czcams.com/video/-xSjy_rwQF8/video.htmlsi=PyxB-YinnieioDMF
@@RezaDorrani I knew it. You just don't let us down. 😍
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!
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”
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
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
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
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. 💪
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
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.
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.
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
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/
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!
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.
Hi, is ist possibile to Patch Attachments ? THX
Patch does not support attachments
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
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.
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.
@@RezaDorrani , sure thank you. I will check it out, appreciate your answer!
⭐️⭐️⭐️⭐️⭐️
Thanks
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.
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 :)
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?
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.
The .value doesn't work at all
I have not experienced this issue
I wish I had Hadley Parker salary
Sorry but did not get the context
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