I am trying to create an inventory sheet. 1st screen allows them to pick where they are doing the invenotry. 2nd screen show the items in a list format (gallery) and a quantitiy field for them to fill out. I can't seem to get the quantity field to be updatable in that list format. Does anyone have any suggestions and if so any sample code? I am new to this applicaiton.
Hi
What's your datasource? I would download f.i. SiteInspection demo app, and learn from that. If you give some more input (screen shots etc), it would be easier to give you a direction and/or solutions to this... 🙂
HI
Are you using EditForm? If yes, then there should be a field to fill in.
If you are using normal TextInput, then you shall use
- Patch(TableX, Defaults(TableX), {FieldTitle: TextInput.Text,...}) - for New Records or
- Patch(TableX, ContextVariable, {as above"), where ContextVariable is brought over from previous screen which you may write lie this:
- OnSelect (of any gallery items) = Navigate(Screen1, Fade, {EditX: ThisItem}), whre EditX is any name assigned as a ContextVariabe.
Hope this helps.
I have managed to do what you need, the juice is in the last three steps.
Say your data source is Test_transactions which has three colums:
Create a new blank app
Rename the first screen Locations and create a second screen and rename it Inventory_edit
Connect your data source, it should be automatically called Test_transactions
Here are the essential steps with the screen Locations
Here are the essential steps with the screen Inventory_edit
This lacks the check if TextInput1 is numerical (if it isn't then the record will not be updated, assuming Inventory_quantity is of numerical type, but no error will be thrown) and if any other errors in connection happen etc. but you can add those as described in other posts and articles.
Please let me know if this works and if so please mark as answer.
See screenshots below...
PS hpkeong's answer also works, but it requires the opening of each item in an edit form. As of today it does not seem that you can add edit forms as elements of a gallery
OMGosh I am sooo excited - I can' wait to try this out!!!!
Unfortunately I just finished volunteering at a Red Crosss shelter all night and will have to work on this later tonight..... this is sooo cool
Thank you sooo much. I will report back when done tomorrow.
I finally go to stop and read and If I undertand the comments right they still have to click on each one. Is that correct?
Im still trying to do this but I am very VERY GREEN and its taking me along time
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
206 | |
97 | |
60 | |
51 | |
45 |
User | Count |
---|---|
257 | |
158 | |
85 | |
79 | |
58 |