Unanswered

Dropdown menus not refreshing after patch.

(1) Share

Report

Posted on by js3428

Hello,

I have a gallery with drop downs in each item, whenever the user selects an option and presses the save button, that selection is updated in the source excel file. After the patch, the drop downs "refresh" their values. Is there a way to keep them showing the value that the user selected before pressing save? I tried using:

ThisItem.columname

in the Default property of the drop down, but it seems like the Excel doesn't update fast enough for it to catch the new value and display it.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,928 Moderator on at

Like (1)

Report
Copy link

Link copied!

hi @js3428

Refresh the datasource after your patch

Refresh(ExcelDataSource)

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

hey @js3428

just like @FLMike said, its a possibility to place a button for example and just insert the code he provided.

You could also place it in the onvisible property of the first screen or wherever u prefer.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
js3428 2 on at

Like (1)

Report
Copy link

Link copied!

Now I realized that my title is totally wrong. I want the opposite of the dropdowns refreshing. So when the user presses the button, the patch runs. When the patch runs it automatically resets the dropdowns to whatever value they had before. I want them so show that new value the user just applied.

Was this reply helpful? Yes No