Power Apps add new value within the ChoiceList ComboBox could also be displayed when add another new record next time

[Anonymous]

Hi, 

Does anyone know how to add new value within the ChoiceList ComboBox could also be displayed when add another new record next time?

Current ComboBox:

Az

Uv

After add value:

Az

Uv

"NewValue"

[Anonymous]

@Anonymous 

Where does the Combo Box data come from? Is it a Choice Field in SharePoint or a list or somewhere else?

[Anonymous]

@Anonymous 

Yes, my data source is the SharePoint list with the Choice field.

[v-albai-msft · Accepted solution]

Hi @Anonymous ,

Do you want to save a new record with the manually entered choice value into your list?

If yes, you can use the SearchText property of the combo box to get the new entered value. Make sure you have enable "Allow searching" feature of your combo box.

I did a test on my side for your reference.

Here is my Choice column called “Status” with three options:

In my app, I have a submit button with this formula to create a new record:

Patch(list9,Defaults(list9),{Title:DataCardValue14.Text,Status:{Value:DataCardValue17.SearchText}})

Here is the result after creating new record:

Best regards,

Allen

[Anonymous]

@v-albai-msft 

Thank you for your reply.

Yes, I want to save a new record with the manually entered choice-value into my list. 

Also I wish to display the newly saved record from the combo box when add another new record next time.

This is my case:

At first, I just have two choices for TFR number from my SharePoint list.

The Apps can allow users to enter a new TRF number and record it in sharepoint list.

Let say the user adds 'new TRF number' using power apps.

The 'new TRF number' will appear in the dropdown list after the record is saved and the user can use it for the next record. 

My column is the choice field, Do you have any idea about this?

[v-albai-msft]

Hi @Anonymous ,

Yes, this can be done. just add one point to my previous answer, make sure that you have selected "Can add values manually" for your Choice column:

Then follow my steps mentioned in my previous answer to achieve this.

Best regards,

Allen

[Anonymous]

@v-albai-msft  Thanks for your reply.

I have tried your suggestion, but I don't know why the power apps do not save my manually key data. IT will turn to the choice that I set before in the SharePoint list.

this is the TRF number I try to add to the list:

I have set the function to can manually key in data whether in Power apps and Share point list.

From my Sharepoint list, the record show the 1st choice that I have set before.

Do you have any idea on how to solve this problem? 

This is the function on my submit button.

```

Patch(
'(MR) Material Record List',
varFormData,
PipngForm.Updates,
DuctingForm.Updates,
Rform.Updates,
Testform.Updates
);

Set(ShowConfirmRequest,false);

Navigate(HomeScreen)

```

[Anonymous]

I think I find out how that happens.  When I manually key in data for 'TRF Number', then move to the next page, power apps won't help me to keep the data. 

When I click to return to the pages, the 'TRF number' that I key in manually will disappear.

Does anyone know why this happens?

[v-albai-msft]

Hi @Anonymous ,

This is a by design feature. 

So based on your information, I would suggest you first save your changes in the 'test info' form, on the NextArrow button in the first form, try formula like this: 

Patch('(MR) Material Record List',varFormData,{Date:DataCardValue1.SelectedDate,'TRF Number':{Value:DataCardValue2.SearchText}});Navigate(RefrigerantInfoScreen)

Best regards,

Allen

[Anonymous]

@v-albai-msft 

Thanks for you reply.

your solution is good.

But for my case, I need to select all the data 1st b4 save the data to database. 

i have figure out another way to do this but still got some problem.

Kindly refer to https://powerusers.microsoft.com/t5/Building-Power-Apps/Save-combobox-data-into-Sharepoint-list/m-p/...  if you have free time to help me solve the problem.

Thank you.