Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Patch data in Excel dropdown

I have an app where I can see different work items with different status. When the work items enter the app they have all status "New". I have build an function with help of the patchfunction so I can change status. The problem is that the dropdown1_17 shows only the status that is available right now. So if all work items has status new I can only change to status new in the dropdown1_17. but if one of the work items has another status then I can change to other statuses too beside status "New". I want the status on dropdown1_17 be fixed to 6 statuses so I can allways choose between these 6 statuses. It should also change in my Excel file to the new status. 


Dropdown1-16 is filterering on the current status (doesn't need adjustment)



Dropdown1_17 (need adjustement)

dropdown1_17 list.jpg

Dropdown1_17.jpgthe dropdown is connected to my excel file column Status

excelfile dropdown.jpgI think right solution is to connect the dropdown1_17 to another Excel page but I don't know how to do that and at the same time update Status in the first page (Ticket)

dropdown status excel.jpg

Super User
Super User


If I understand correctly you have 6 statuses and you always want those statuses to show in the dropdown even if they do not appear in the Tickets table.


It is possible to do this without building a new Table in Excel to holds the statuses.  Instead, you can just use this code in the Items property of your dropdown.  It creates a single-column table with the dropdown values (please note the square brackets).


"Work Item Communicated",
"Work Item With Release Notes",
"Work Item With Booked Meeting",
"Training Executed",


Hope this helps!


Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

@mdevaney that sounds like a good solution. Unfortunately I have some warning on my confirmation button, do you have any idea what the problem can be?

confirm button warning.jpg


Please click on the error and share a screenshot of the warning message that appears.

3 warnings.jpgwarning 1.jpgwarning 2.jpgwarning 3.jpg


Tee first error says you have a missing control name.  Do these still exist?  Check your left side menu and double check the spelling is 100% correct




Next, you can check this line in your patch.  Can you please show me the code in Dropdown1_13 for the Items property?





dropdown error.jpg


Looks good there.  So we've eliminated that possibility.


Can you check your left side menu to make sure these exist?


Checkbox1_15  I do not see this one




Also, your checkbox within the gallery has an error.  Please tell me the control name and screenshot the error too.

Gallery1_6 was correct

Checkbox1_15  I do not see this one It was wrong I have changed to Checkbox1_13

Dropdown1_13 was correct


I have still problem.

error checkbox.jpg

Dual Super User II
Dual Super User II

Hey @Djanan 


To fetch the value from a checkbox, you need to use CheckboxName.Value
Patch(Tickets, ThisItem, {Status: Checkbox1_13.Value})
But this will add true/false in the status column, if you wish to add the status selected in Dropdown, you need to update the expression as:
Patch(Tickets, ThisItem, {Status: Dropdown1_13.Selected.Value})
Assuming, that the name of dropdown control to select Status is Dropdown1_13
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,072)