Patching/updating text input control to SharePoint list column

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

Hello,

I have built this PowerApp below which is using tabs to navigate between different form items based on their Visible values...

Due to the design nature, I have not inserted a SharePoint form into the app but am pointing the items value of the drop-down boxes to eg. Choices('Uniform order form'.MensPoloShirt) - where 'Uniform order form' is the name of the SharePoint list (uniformorderform).

I was wondering, how do I point the Quantity text boxes to the SharePoint list so that entered quantity values are added to the list item? An example column name would be 'MensPoloShirtQty'. Id like to get this sorted before I add any more controls for when the next tab is selected.

I've not built any apps where the fields are not within an 'Edit form' control.

For the record, the fields above are inside a container.

Thanks.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@sudosaurus
If you can still access the primary key (unique ID) of each Record somehow, such as through Parent (with Parent being either the Gallery or Form), use this for Default property of the Quantity control, (let's say it's a Text Input control for now)
//pseudocode LookUp(DataSource,PrimaryKey=Parent.ThisItem.PrimaryKey).Quantity
The above must be adjusted with appropriate names of your DataSource, PrimaryKey (unique ID) column, and name of the Quantity column
If it's a SharePoint List, use ID as the Primary Key
//pseudocode LookUp(DataSource,ID=Parent.ThisItem.ID).Quantity

See if it helps @sudosaurus
sudosaurus 1,599 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@poweractivate

Just for reference, I have the form at towards the top of the app where I have the Title(Name), Supervisor/Manager and Created(Date) columns.

I then have custom fields in a container so that I can create the 3 column layout.

I'm just thinking, can I have two SharePoint forms for the same list on the same screen? (would it be easier than patching)
As then I probably could use plain text for the product names and have the fields appear in the form next to them?
Similar to this:
Then I'm assuming if I have a submit button at the bottom of the screen with the OnSelect property set to:
SubmitForm(SharePointForm); Set(varFormMode,"Saved");

Thoughts?
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@sudosaurus

If it is easier for you, this could work - however, it would be required to have both forms Submit on the click of a button. This would mean that two forms are being submitted, which in most cases, I would not recommend, and the Patch would be preferred. However if it works for you, and if it's easier, then you could try it the way you would like.

One thing that comes to mind is I could imagine if multiple users were doing it at the same time, if one happened to do it while one of the Forms was still submitting but the instant before the other Form was done submitting, it feels like there could be some issue or race condition. So if it's possible, it is better if it's one submission, so the Patch might be better. However, you could try to get it working with your way first and see if it's better and easier for you.
sudosaurus 1,599 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@poweractivate

This is where I've got to with my Patch code:

Patch('Uniform order form', Defaults('Uniform order form'),{Title:User().FullName,SupMan: {Claims: Concatenate( "i:0#.f|membership|", User().Email // Person email ), Department: "", DisplayName: User().FullName, Email: User().Email, // Person email JobTitle: "", Picture: "" } } )

I need to add in some choice values - which I know you can use
{Value: "choice value"}
If one of my choice columns has 10 choices, do I need to specify each individual one? (*note this is not a multi-select choice column).

Also I am not sure of the correct syntax for a Yes/No (true/false) column.

Any tips would be appreciated.