Answered

Using a Button to Update Choice Field

(0) Share

Report

Posted on by apirez

Hi All,

Im looking to create a button to change a field (DropDown) in my form "Status" from a default of "1-New"to "5-Cancelled". My SP list name is 'Project Close'. I tried to use the Patch function, but ThisItem does not show up after the data list name. Any help would be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @apirez ,

Please try below syntax:

Patch('Project Close', ThisItem, {'Status':{Value:"5-Cancelled"}})

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
apirez on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni please see the attached screenshot. I think the issue with with ThisItem. I couldnt get that to show up when I first tried this. Thanks

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @apirez ,

Where is the button, in or out of the form? I was assuming the button was lying with the dropdown in a same data card. What is the Item of the form? You can simply replace ThisItem with exactly what's in the Item of the form. The second parameter of Patch represents the record that needs to be updated.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
apirez on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni That seemed to work! Thank you! One more thing. I am trying to apply the same logic to two other forms and I cant seem to get syntax you provided to carry over, when I change the different attributes. I really appreciate your help!:

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @apirez ,

Try and use Gallery.Selected instead of ThisItem if you will always select items from the Gallery on the left.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
apirez on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni This still doesnt work for the other two screens. Im getting a message :This formula has side effects and cannot be evaluated" just on the other screens. when I go to test, the button doesnt activate like the one that currently works. I really do appreciate you help on this.

Here is my syntax:

Patch('New Project Request_1',Gallery2_1.Selected, {'Status:':{Value:"5-Cancelled"}})

Patch('CC Mapping', Gallery2.Selected, {Status:{Value:"5-Cancelled"}})

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @apirez ,

I am not able to reproduce this issue, nor to find any relevant information on the web. Maybe you should try and disambiguate on all the three Patch functions:

1. Set variables OnSelect of the respective Gallery:

Set(varProjectNew, ThisItem)
Set(varProjectClosed, ThisItem)
Set(varCCMapping,ThisItem)

2: Patch formulas:

Patch([@'New Project Request_1'], varProjectNew, {Status:{Value:"5-Cancelled"}})
Patch([@'CC Mapping'], varCCMapping, {Status:{Value:"5-Cancelled"}})
Patch([@'Project Close'], varProjectClose, {Status:{Value:"5-Cancelled"}})

Hope this works.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report
Copy link

Link copied!

Hi @apirez @v-jefferni ,
I had a requirement which was similar which was on click of a button the Choice value should be updated ("" {Blank} -> Not Started -> In-Progress -> Completed) so for that I have created a Choice column in my SharePoint list named Status. I have posted the detailed information on Forum could you guys please have a look at and help with it:
Query

Was this reply helpful? Yes No