Unanswered

Submit button to change values in Sharepoint list

(0) Share

Report

Posted on by Nedelcho

Hello, I'm fairly new to PowerApps.

I'm attempting to create a simple app that will take values from a Sharepoint list and allow me to change the values in power apps.

So far, so good. When I select a value from the drop down menu, my values from the table appear in the text fields.

I want when I change the values in Powerapps and press the submit button, the values in the Sharepoint list to change.

I've included images of the table and the app.

Test table.png

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

fratrucc 81 on at

Like (0)

Report

What i said was probably wrong and seems that i can't delete the comment

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @Nedelcho ,

I am assuming here your issue is with the drop-down not saving. I will also assume that the Items of your drop-down are

YourListName.Title

Your issue here is that you are not using a Form and do not have the ID of the record to be updated, so I will assume that Title has unique values - to update

With( { wID: LookUp( YourSPListName, Title = Org.Selected.Title ).ID }, Patch( YourSPListName, {ID: wID}, { Title: Org.Selected.Title, Value1: value1_bx.Text, Value2: value2_bx.Text } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

Nedelcho 11 on at

Like (0)

Report
Hi @WarrenBelz ,

Thank you for your response.
The dropdown is as you guessed " Items=YourListName.Title"
Because the title column in Sharepoint does not have unique values, I have added the ID column to my SP list.

And as for your solution, I tried this:
With( { wID: LookUp( Test, Title = Org.Selected.Title ).ID }, Patch( Test, {ID: wID}, { Title: Org.Selected.Title, value1:: value1_bx.Text, value2: value2_bx.Text } ) )

And received the following error:

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
@Nedelcho ,

You have two colons after value1:: - the code I provided is valid syntax.

You however still have an issue identifying the correct record as you are not using a Form with the ID in it. One way would be to change the Drop-down to a Combo Box and have the Items as simply the list (Test), then display the Title in it (you will get duplicates here, but the is no way around that) and then

Patch( Test, {ID: Org.Selected.ID}, { Title: Org.Selected.Title, Value1: value1_bx.Text, Value2: value2_bx.Text } )

A better way is to use a Form and simply submit it.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No