cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Djanan
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_16.jpg

 

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

11 REPLIES 11

@Djanan
You are getting an error because you need to change Checkbox1_13 I to Checkbox1_13.Value just like it was in your original post.

@mdevaneyalmost fixed. I don't get any errors but when I click on the checkbox it update to the new status automatically. I want to click on the confirm button to do that. 

 

I have also problem with that the new status appears in a new field in my dropdown. I think I should use distinct somehow. 

distinct.jpg

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (4,261)