Patch data in Excel dropdown

[Djanan]

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)

the dropdown is connected to my excel file column Status

I 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)

[mdevaney]

@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.

[Djanan]

@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.