Changing a Dropdown Value from a Button

(0) Share

Report

Posted on by LyonsBI_BRL

214

I'm currently stuck on a formula for changing a Dropdown value from a button.

Here's my scenario

I select on the Garbagecan icon to Archive an item.

The popup comes up as a variable as I have set it to Set(varShowArchive, true)

Which pops up the below

I was able to do this on another app, using Removif, but I'm not trying to remove the record I'm simply attempting to change the value or a dropdown per that item from ACTIVE to ARCHIVED.

So the source would be '2A Customers'

And the result would be. If I click on ARCHIVE, it'll set the Dropdown from ACTIVE to ARCHIVE and thus patch the record.

Any help would be greatly appreciated. I know I can do this through the Edit form, (that is a feature of the app) but this would make things super quick for archiving old records.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LyonsBI_BRL

Patch( '2A Customers' ,ThisItem, {Archived:true})

This is assuming there is an Archived column in your list , the button is in the gallery and the column type is a simple text column. Replace Archived with the name of your column.

Otherwise, Patch( '2A Customers' ,ID=Gallery1.Selected.ID, {Archived:true}) if the button is outside of the gallery.

Was this reply helpful? Yes No
LyonsBI_BRL 214 on at

Like (0)

Report
Copy link

Link copied!

Hey @Drrickryp that's what I tried earlier but because I'm attempting to select from a dropdown menu, it's not working.

So within the Whiteboard Gallery, there's a Dropdown called "Status2" which has the choice of ACTIVE or ARCHIVED.
Would it make more sense then to just make a column in SQL called "Archived"

Thanks!

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LyonsBI_BRL

If you already have a column Status2, I would just patch that column using the dropdown's selected value.

Was this reply helpful? Yes No
LyonsBI_BRL 214 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp I do have column status 2, however the button that I'm trying to set it for ThisItem.CustomerID, lives outside of the Gallery. How would I go about doing that. So the Archive button below, should be able to Patch / Update the status for ThisItem there within the Gallery.

Was this reply helpful? Yes No