Update dropdown in gallery after adding new dropdown value in Edit Form

[ArtHavenShelter]

Hi,
just got help in another topic about a combobox including a search solution. Now building further on this app.

I found a nice tutorial about adding a value in a dropdownbox in the EDIT FORM. So as soon as you use "Other" you can type an extra value for a choices menu in a sharepoint list. The sharepoint list will show the new choice value. 

The problem is, is that the dropdown box in the Browse Gallery doesn't update. 
I tried to use the function "allow manual choices" (roughly translated) in sharepoint list choice settings. That doesn't work because then I can't add new values anymore in the dropdown box. However, in Browse Gallery you will see the new value in the dropdown box. 

Below I have the script for the Dropdown in "Categorie". Which originally has only 3 options. And needs an "Anders" which will be stored after typing a new "Categorie" value.

Ungroup(
     Table(
         {DropdownOptions: Choices('De bieb'.Categorie)},
         {DropdownOptions: ["Anders"]}
     ),
     "DropdownOptions"
 )

I would like to have it shown also in the "Selecteer Categorie".  Which has ITEMS=Choices('De bieb'.Categorie) as the formula.

So, it seems like you can't have both. Just wondering if this assumption is correct or that I can try something else. 

In short:
SP has: choices.
Powerapp: has  "Other" in Edit Screen with the option too add a value. After updating SP has a new value in a list item. 
Browse Gallery: doesn't update with the new value. 

What to do...

[ArtHavenShelter]

@Expiscornovus, @ScottShearer , @KvB1  You guys helped me before so that's why I just add you in this commend. If you would like to help, suggest, I am happy to hear from you.

[KvB1 · Accepted solution]

Heya,

This should be able to work.

The process would look like this:

- You select the value 'Anders'

- You enter a new choice

- The choice gets patched to SharePoint

- The new choice is presented in the dropdown, where the source is the SharePoint column

You indicate that you can verify that this new choice does get patched to SharePoint, so the problem is probably the last step. 

The dropdown has a data source, which gets imported to the app at the start of the app. Some actions refresh the database, others don't. 

Could you try adding a Refresh(DataSourceHere)  line?

[ArtHavenShelter]

Hi!
Thanks for your step by step summary and your solution.

This worked indeed.

I added the Refresh(Datasource) on start of the app and changed the SP category settings to "allow add manual values".

It works perfectly. Thanks again!