PowerApps form button, which changes column field value

(0) Share

Report

Posted on by Karol

102

Dear Users,

I'm new to PowerApps, I would like to ask you about one thing:

I have a list with column Status (Choice)

Choices:

Confirmed

In approval (default value)

Rejected

Cancelled

I would like to make a "Cancel" button in form and if user click it, the record in
Status column will be updated from for example Confirmed to Cancelled.

Thank you in advance for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Karol Set the default property of the dropdown to a variable like, varStatus.

Then in the OnSelect of the Cancel button set the value of the variable varStatus to the one you want (e.g. Cancelled).

Was this reply helpful? Yes No
Karol 102 on at

Like (0)

Report
Copy link

Link copied!

Dear @CNT ,

Thank you very much. Could you provide me little more information how to do that step-by-step?
Firstly, should I create a variable varStatus just by writing in Default dropdown varStatus (in that case I got an error) and then in the OnSelect Button should I Set(varStatus, "Cancelled")?

@Edit

I just found out that my field is not a drop box, it is a combo box

Thank you in advance.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Karol As it is a ComboBox, set the DefaultSelectedItems property to varStatus. In the OnSelect of the Cancel button use this formula,

Set(varStatus, Filter(Choices(ypurSPListName.Status), Value="Cancelled"))

Was this reply helpful? Yes No
Karol 102 on at

Like (0)

Report
Copy link

Link copied!

Thank you @CNT it worked!

Last quick question (I promise):
Is it possible, that this button will be "clickable" not only in "Edit" mode, but in "View" mode too?

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Karol By default buttons are clickable in the view mode also. In my example below, I have a button that says, "Click me" which displays a message "You clicked me!" when clicked.

Was this reply helpful? Yes No
Karol 102 on at

Like (0)

Report
Copy link

Link copied!

Dear @CNT ,

Yes, it's working, I don't know why it was not working earlier. Thank you very much for your help, I really appreciate it 🙂

Greetings from Poland! I started learning PowerApps so I'll ask sometimes in topics here 😄 Thank you!

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Karol Great news! Just @mention me.

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

Like (0)

Report
Copy link

Link copied!

Is it possible to do this but without the choice field being visible on the form itself, i.e. the button changes the value upon clicking?

Was this reply helpful? Yes No