Unanswered

Update drop-down when button pushed

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I've been searching this topic for hours but cannot find a specific use case that's working for me.

I have a PowerApps form that writes to a SharePoint list. There is a specific drop-down that writes to a choice column in the list. I want to maintain it as a drop-down, but under certain circumstances "automate" changing the value.

So the choice column (in SharePoint) is called "Status." The drop-down in PowerApps is called "Status_Combo."

The choice column has three choices: New, In process and Resolved. I already have the DefaultSelectedItems as New so that on creation of a new entry it populates it with that selection. Everything is working fine up to this point.

What I want to add is a pushbutton that, when pressed, does several things (such as incrementing the number in another column), but I also want it to look at the choice column and IF the current value is "New" change it to "In process." I already have the increment part working, but I've tried various combinations of the Patch function for the choice column, but I never see the value update.

Categories:

Building Power Apps

All responses (19)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Daryl_K

You would use a variable to do it.

In the control that sets the new form mode, NewForm(Form1); UpdateContext({var:"New"})

In the button: Switch(var,"New", UpdateContext({var:"In Process"}),

"In Process", UpdateContext({var:"Resolved"})

In the defaultselectedItems of the combobox: var
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Can I create the variable as part of the pushbutton also?

If not, is there a "create" event that is spart of the form? I am using the standard "New" button in a SharePoint list to create a new instance of the form.

P.S> I should add this is my very first Power App, so I am as "noob" as is possible. 🙂
Tufel_Sayed 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Daryl_K

I think there is an issue with your patch function.
Make sure you are patching the choice value to SharePoint List as per the below format.
Patch(
YourDataSourceName,
LookUp(
YourDataSourceName,
ID = RecordID
),
{
YourChoiceColumnName: {
Value: "NewValue"

}
}
)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hmm, I don't get any errors entering this correctly, but it doesn't do anything when I press the button.
Tufel_Sayed 34 on at

Like
a
(0)

Report
Copy link

Link copied!

@Daryl_K

I have put that code for your reference you can change your column name and list name according to your list and column names. You only have to check whether the patch function of yours is of that format or not. If it not in that format then you can change and try to patch.

Can you share Screenshot of Patch Function?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply. My current obstacle is the "ID" number. I assume this is the ID (row #) in the list (i.e. 0001, 0002) but the only way I know to get the right one is to use the ID field in Power Apps. Doing so this field displays the number correctly, but in your example it gives an error "Incompatible types for comparison. These types can't be compared: Number, Control." I assume this is because the DataCard here is a control type, but I cannot hard code a number here, so I must be doing something wrong.

This is what it looks like, with ID# being the DataCard that reads the SharePoint list ID.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

OK, I figured out the two dumb mistakes I was making: on was how to get the value on the control, the other was that I accidentally entered "list name" where it should have been "column name." I fixed both of those and now PA is happy (no errors) but when I press the button it just clears the drop down instead of putting in the desired value.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

OK, I figured out the issue here: the code you provided IS working (once I corrected my mistakes). It does in fact change the column value if I watch it within SharePoint. My confusion is that I don't see that change reflecting in the PowerApps control...it remains blank.

Maybe I should I be changing the control instead of the actual column value?
Tufel_Sayed 34 on at

Like
a
(0)

Report
Copy link

Link copied!

@Daryl_K

As you mentioned that the column value is changed but the power apps control value does not change. So my question is the control you are using is part of the form or separate ?. If it is separate then you could not get the data because when you patch, it writes value to a specific record's column.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It is part of the form. The form itself is very basic, one screen, and writes to one list. It also receives some data from a second list for a few different dropdowns, but those are working correctly and are not related to or affected by this dropdown I am asking about.