Update a sharepoint list

(0) Share

Report

Posted on by nshaw75

438

Following on from my previous post I am having difficulty updating my sharepoint list when I use an Icon as a button.

I have added an icon into my gallery which, when pressed, will change the status of my permit to closed. The formula I have used, and doesn't work is " Update('Permit Tracker',Status,Value="Completed") ". The status is in the form of a choice column (Closed,Open, Planned)

Thanks in advance for helping out a noob 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Gochix 1,935 Moderator on at

Like (1)

Report
Update('Permit Tracker',ThisItem,{Status:{Value: "Closed"}})

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

Hi @Gochix thanks for your help, it is much closer than I managed to get. When I test the update fails and returns an Error - Network error when using Update function:Field "ID" is required.

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (1)

Report

Can you show us a screenshot of your gallery + button. The formula I provided is expecting that you have a button for each row in the gallery.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

The 'Button' is actually an icon inside the gallery as in this tree view .

Was this reply helpful? Yes No
Verified answer

Gochix 1,935 Moderator on at

Like (1)

Report
Then you can try it using UpdateIf:

UpdateIf('Permit Tracker',ID = ThisItem.ID,{Status:{Value: "Closed"}})

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
nshaw75 438 on at

Like (1)

Report

@Gochix Fantastic thank you very much, It's worked a treat 😊

Was this reply helpful? Yes No