Update a choice field on button click

(0) Share

Report

Posted on by PedroFernandes

122

Hello

I'm building a leave request app, and in the manager page I have a gallery that displays all the pending requests. In my datatable, I have a choice field with the options "Pending", "Approved" and "Rejected". Each time a user makes a request, that field is always set on the "Pending option".

As seen on the image, each request has a green and a red button, for approval and rejection. What I want is to change the option of the selected entry on button click: green for "Approved", red for "Rejected".

I also could make a singular "Approved" and "Rejected" button (avoiding overcrowding of screen space), but it needs to change only the selected entry.

I've tried different formulas and searching possible solutions for hours, to no avail.

Anyone can nudge me on the right direction? Am I missing something obvious?

Thank you in advance.

Categories:

Building Power Apps

All responses (5)

Answers (2)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PedroFernandes,

Do you want to update the choice field clicking on the button?

Could you please tell me that if this is a Gallery where you want to click the button to update choice field?

The screenshot makes me confused that how you configure your data.

If you have a gallery and want to update the choice field once click the button within each section, please try as below.

Set the OnSelect property of the Approve button as below:

Patch(DataSource,ThisItem,{ChoiceField:{Value:"Approved"}})

Set the OnSelect property of the Reject button as below:

Patch(DataSource,ThisItem,{ChoiceField:{Value:"Rejected"}})
PedroFernandes 122 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-qiaqi-msft

What I want to do is exactly what you suggested (sorry if I wasn't clear enough).
Adapting your code to my existing data it should be like this:
Patch(Pedidos_Ferias, ThisItem, {Estado:{Value:"Approved"}})
Here, "Pedidos_Ferias" is the datasource and "Estado" is the field containing the choices for "Pending", "Approved" and "Rejected".

However, this formula shows the following error: "The type of this argument 'cr22e_estado' does not match the expected type 'OptionSetValue'. Found type 'Record'".
I'm currently trying to solve this. Any insight on how to do it? Thank you for your help.
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@PedroFernandes Try this (Replace OptionSetName with the actual name),
Patch(Pedidos_Ferias, ThisItem, {Estado:'OptionSetName'.Approved})
Verified answer

PedroFernandes 122 on at

Like
a
(0)

Report
Copy link

Link copied!
@CNT
Thank you. With your help and some trial and error I got the solution. The working code is the following:
Patch(Pedidos_Ferias, ThisItem, {Estado: 'Estado (Pedidos_Ferias)'.Aprovado})

Thank you all for your help
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
My use is similar to this but in my case I want to set the Choice column using a single button (not 2 different buttons). I have a status column in my SharePoint list which has 3 values Not-Started (Default), In-Progress, Completed.
Example:
If a user clicks on the button should change in a sequence like:
On 1st click: Not-Started
On 2nd click: Status: In-Progress
On 3rd Click: Status: Completed
So for that I have created a button which looks like Text in my screen and added a Labe beside to show the value after every click the value should be reflected in the textlabel and also saved in the sharePoint list.

(The highlighted part is the button used to change the choice column)
I have posted the query o0n the forum so if you guys: @v-qiaqi-msft , @PedroFernandes and @CNT can have a look at it would be helpful
Query

Regards,
Sidhant