Creating an Edit Form and Fixing Defaults in Power Apps
Vložit
- čas přidán 25. 07. 2024
- Creating an editable form in Power Apps starts with inserting a new Form control, typically choosing an Edit form based on the desired functionality. Next, you connect the form to a data source, such as SharePoint, which allows the form to fetch and submit data. You can customize the form fields to match the data structure of your source, adding or removing fields as necessary and configuring their properties to control user input. Finally, implement buttons for actions like 'Submit' or 'Cancel', which can trigger Power Apps formulas to save the changes to the data source or discard them, enhancing the form's interactivity and usability.
Part 1: • Creating a Power App f...
Part 2: • Creating an Edit Form ...
Part 3: • Convert Default Form t...
Part 4: • Making Containers work...
Part 5: • Wait! Solve Delegation...
Chapters:
0:00 Introduction
0:43 Lets get started
3:05 Fixing Delegation Warning using Collections
7:00 A New Screen for Locations
11:50 Changing a Text to a Dropdown
14:10 All fields in SharePoint Single Line Text
15:30 Highlighting Selected in a Gallery
16:50 Creating a stoplight in a Gallery
20:20 Making a form Editable
22:10 DefaulSelectedItems for a Combobox
23:30 Default for a Dropdown - Věda a technologie
Hi Everyone, I have moved my recording area to a new room and the sound was a little off because the room was so empty! Working on it, sound issues should be fixed by next week!
Thanks for this video, Andrew. Your training style is so easy to follow along with.
Appreciate it so much! Thank you Wendy!
Cool. Can't wait to see how you fix the 2k delegation thing.
Check out the newest video, we crush delegation 😆czcams.com/video/sVJPqC6h5-o/video.html
hi thank you for you video. When i am using combobox to enter data, column of table which is used Combobox is showing me unknown code. How i fix it?
Great videos @andrewhess123. How do you add multiple selections? I want the combo box to have only a limited number of choices, but when I cannot figure out what the update properties are.
@14:36 I guess I did a mistake by creating sharepoint lists with all sorts of column types and my patch function is not working properly. For the same topic I have a question: Which data type should I use for foreign keys from other sharepoint lists? Or which data types should I use in juction tables to solve many to many relationships?
Hi Murat, it is still possible to do it with different data types, but it may just become more difficult to maintain in the future. Sometimes I might prefer a choice field instead of a single line text. This part is just preference. And maybe even a Power BI/Data Scientist may disagree with my preference.
But the data type for foreign keys from other sharepoint lists should probably most likely be a number type, and you could match that up with the SharePoint ID. Many to Many relationships gets much more difficult because SharePoint is not really a relational database.
I will designing more and more and we may go to Dataverse for Teams or even Dataverse/SQL for real relational databases.
I was literally just going nuts trying to fix defaults in Forms... Ha
Perfect, my new video on Monday goes over it even more!
Help!! Hi Andrew, I’ve been watching some of your videos but I still haven’t managed to fix my issue! I think I’m very lost.. basically I’m Trying to capture some information in a power app and then using a flow, translate this information into a Microsoft word template. I just can’t seem to link it all together, I have the relevant combo boxes in the power app and also the developer text boxes within the word doc. I have also created a flow but can’t seem to trigger it, I have a submit button at the end of the power app, is there a way to connect this button to the flow? I can’t seem to get the code correct in the formula bar. Any help is appreciated 😊 thanks
Hi Matt, so in order to trigger your flow in Power Apps you need to call on your Flow. czcams.com/video/Z6ecHW51U5k/video.htmlsi=r9jP5Iy--lz9WLzE&t=337
You can see in this link where I call the flow, in this video the flow is called FavoriteForPowerApps, then you do .Run with the parameters between the ().
Let me know if that helps? But that whole video uses the new Power Apps V2 trigger in Power Automate to start the flow in Power Apps 😀
@@andrewhess123 thanks! I have the flow working now, however I’m struggling with my combo boxes and Drop down boxes. In your video you have the selected.value option, I don’t? Any ideas on why?
@@matthewshimmin764 Theres a few reasons to why, it could be the difference between modern or classic, or the difference between dropdowns or comboboxes. But if you convert it to a variable and pass it you should be able to get it. Also, it could be more and more complex like if you have a multi-select.
@@andrewhess123 hi Andrew, how does one convert it to a variable? My formula box looks like this at the moment:
‘test’.run(FullName2.value, FullName1.value, DropdownCanvas1. ? )