Update a sharepoint list

(0) Share

Report

Posted on by nshaw75

375

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 🙂

All responses (6)

Answers (1)

nshaw75 375 on at

Like (1)

Report

Re: Update a sharepoint list

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

Gochix 1,933 Super User 2025 Season 1 on at

Like (1)

Report
Re: Update a sharepoint list

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!
nshaw75 375 on at

Like (0)

Report

Re: Update a sharepoint list

The 'Button' is actually an icon inside the gallery as in this tree view .
Gochix 1,933 Super User 2025 Season 1 on at

Like (1)

Report

Re: Update a sharepoint list

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!
nshaw75 375 on at

Like (0)

Report

Re: Update a sharepoint list

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.
Gochix 1,933 Super User 2025 Season 1 on at

Like (1)

Report
Re: Update a sharepoint list

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!