Update a sharepoint list

(0) Share

Report

Posted on by nshaw75

440

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)

Sort by

Gochix 1,937 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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 440 on at

Like
a
(0)

Report
Copy link

Link copied!

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,937 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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 440 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Gochix 1,937 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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 440 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No