Unanswered

How to update a choice field in a list of Sharepoint using a button from PowerApp

(0) Share

Report

Posted on by gonzalomd

Hello community!

At this moment, I am developing an application where I store information in a SharePoint list. I need to create a button which when clicked will update the status of that "Request" to "Cancelled" only if this status is "Pending" as long as it is different from "In Progress", "Done", "Rejected" and "Cancelled".
Is it possible to do this? I want to exclude the delete process request, only update the status to cancelled.

Button to cancel request:

List:

Thanks to all!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
you collect all the choices you have selected into a collection, in a value column, then will update it liek this

Patch(ParkingMasterGarages,GarageFocus.Selected,{Area:choiceroundup})

in example above, Area is my choice column in sharepoint, and choiceroundup is my collection in powerapps that has my choice selections

Was this reply helpful? Yes No
gonzalomd 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry but I cant update the conditions, the button have the property OnSelect and Patch(Testing,DataCardValue13.Selected,{'Status request':'Cancelled'})
Testing is the List
DataCardValue13 is the field of Status
'Status request' is the name of column of choice in Lists and Cancelled is the name into the List for Cancelled tickets
Any idea? thnks

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
in my example

{Area:choiceroundup}

is a collection, so sends it to sharepoint in proper format for a choice column. if manually typing out I think its gonna be somehting like

{Area:{Value:'Canceled'}}

I never do it manually and don't have powerapps pulled up to test the syntax at the moment. You could also just put

ClearCollect(dataset, {Value:'Cancelled'}); Patch(Testing,DataCardValue13.Selected,{'Status request':dataset})

a clearcollect before it to make sure your info is in right format for passing to a choice column (choice column is a little table/collection of info with the property of value)

Was this reply helpful? Yes No