Combo box values not saving in canvas app

(1) Share

Report

Posted on by godala_vamshi

174

Hello,

I have a custom Combo box and Items are from Excel, I was able to select the values but when I save and refresh, it is saving with some random single selection(multi values are not saving). below are the screens for reference.

On Data card update :

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

HolaManchester 16 on at

Like (0)

Report

Hola,
have you tried to use the concat?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @godala_vamshi,

Do you want to save multi select from combo box to your excel table?

Could you please tell me that how you set the Items property of the Combo Box?

If you set the Combo Box with the column directly as below:

Table1.ApplicationName

I think you should modify your Update formula as below:

Concat(DataCardValue3.SelectedItems,ApplicationName,";")

Was this reply helpful? Yes No
godala_vamshi 174 on at

Like (0)

Report

@v-qiaqi-msft I just want to save field values with in form using Application names from source excel.
I tried as you suggested but seeing below error for update.
Thank you for you help!

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @godala_vamshi,

Could you please check my formula one more time?

Concat(DataCardValue3.SelectedItems,ApplicationName,";")

Concat(DataCardValue3.SelectedItems,ApplicationName,";")

Please note that there are four operators within the Concat(), first is a dot, second and the third are a dot as well, and the last one is a separator referred using a "".

Was this reply helpful? Yes No
godala_vamshi 174 on at

Like (0)

Report

@v-qiaqi-msft Yes, I tried that and it is expecting Table value.
Thank you!

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @godala_vamshi,

Could you please tell me that if the ApplicationName column exists in an Excel table or SP list?

For that you have set the Update property with {Value:xxxx} at very first, I guess you want to save the Combo Box selected items to a Choice column in the SP list, right?

If so, I think you should try the following steps:

1). Make sure that the Choice column in the SP list allows multi select in column settings

2). Modify your Update property as below:

ForAll(DataCardValue3.SelectedItems,Value)

Please do answer the above questions if the formula could not solve your problem.

Was this reply helpful? Yes No
godala_vamshi 174 on at

Like (0)

Report

@v-qiaqi-msft Yes, ApplicationName is existed on Excel table(screen below). Yes, for the custom combo box I created source should be Excel AppName and I want to save that value in choice field(which does accepts multi select) in SP list(screen below).
I tried updating the update property but getting error for "For All"
Also, do you think is that some thing to do with default property? I have set default property as ThisItem.AppInterfaces

Thank you and appreciate your help on this.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @godala_vamshi,

Modify your formula as below:

ForAll(DataCardValue3.SelectedItems,ApplicationName)

Was this reply helpful? Yes No
godala_vamshi 174 on at

Like (0)

Report

@v-qiaqi-msft Thank you, That worked.

Was this reply helpful? Yes No
godala_vamshi 174 on at

Like (0)

Report

@v-qiaqi-msft
Hi,

We just noticed when we try to add additional values to combo box and save, when we refresh the record it is saving with the newly selected value and removing the previous value, I tried adding if condition for update property but no luck.

For example: If I select below values and save for the 1st time, there is no issue.
But then I comeback next time and add additional value as below and save/refresh, It is only saving new selected value.
On Update : ForAll(DataCardValue3.SelectedItems,ApplicationName)
Default : ThisItem.AppInterfaces

Thank you very much in advance!

Was this reply helpful? Yes No