Unanswered

Change a combo box value by clicking a button

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I'm making a form for contract management in PowerApps.

I have an edit form with only one list, called 'Contracts'. When the user adds a new contract using the form, he can input various information such as 'Amount', 'Customer', 'Date', 'Status', etc. Once submitted the form, the contract information will be added in the list 'Contracts'.

Admin users can access to an Approval Section, where they can approve the contracts which status is "Waiting for Approval" by clicking a button.

Can anyone point me out a solution in order to change the contract 'Status' in the combo box and in the list from "Waiting for Approval" to "Approved" by clicking this button?

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

WiZey 3,023 Moderator on at

Like (0)

Report
Hello @Anonymous ,

You can use "Patch()" to change the value of an existing record.

Patch( source, existingRecord, {choiceColumn:{Value:newValue}} )

source is the name of your SharePoint list
existingRecord is the record you want to change (use "LookUp()" or any other method to retrieve the full record you want to change)
choiceColumn is your "status" column you want to change. As it is a choice-type column, its new value must be referred as a record « {Value : newValue} »

Hope this was helpful to you.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello, thank you for your reply! The solution you pointed me out makes a lot of sense, but I'm getting an error in this part of the code:
{choiceColumn:{Value:newValue}}
I put 'Status' as 'Value' and I don't know what I can insert as 'choiceColumn'

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report
Hello,

choiceColumn is the name of the column you want to give a new value. Assuming it is a choice-type column, it's value must be a record like « {Value : newValue} ».
Value is the property name of the choiceColumn you want to update. This is the default name from SharePoint, you don't have to change it.
newValue is the new value you want to update your column with. To change the value to "Approved", just tap "Approved" instead of newValue.

{Status:{Value:"Approved"}}

By the way, I assumed "Status" was a choice-type column, but if it turns out your "Status" is a text-type then you can simply use this:

{Status:"Approved"}

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi, I tried to do it:

{Status:{Status:"Approved"}}

but it appeared this kind of error:

Invalid argument type. Expecting a record value, but from a different schema.
Missing column. Your formula is missing a column 'Value' with a type of 'Text'.

Thank you in advance

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (1)

Report
Hi @Anonymous ,

I agree with what @WiZey said, the formula provided by @WiZey should work.

I see that you seem to be stuck, but I didn't want to plagiarize the answer, so I made a slightly more detailed test for your reference.

1. Here is my SharePoint List.

2. Here is my App.

I added a Button Control to the Data Card corresponding to the Status column.

Combo Box(Choice Column)-->DisplayMode:

DisplayMode.Disabled

Button-->Visible:

If(User().Email=Admin's Email,true,false)

Button-->OnSelect:

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

Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No