Answered

Cannot save combo box results to SharePoint choice field

(0) Share

Report

Posted on by RubyHu

Hi, PowerApps Community!

I am tring customize the sharepoint list with PowerApps.I have created the (multi-selected) combo box, and pubilished to the sharepoint list.Here is the problem I meet：what ever I create or edit the item the combo box results are not save to the list.

This is my combo box in powerapps form:

AIField_Combox

Items = Distinct(KeyMethod, AIField).Result

DefaultSelectedItems = Parent.Default

for the AIField_DataCard Update , I had tried 3 ways, but their all not work：

= AIField_Combox.SelectedItems.Result

= ForAll(AIField_Combobox.SelectedItems,{value:Result})

= {value:AIField_Combox.SelectedItems.Result}

Any idea to dill this problem ?

My English skill isn't well, if the problem description is not clear please tell me, tks.

Cheers,

Ruby

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @RubyHu,

That's impossible that you could display all the value using the Distinct() function if the AIField is a Choice column allowing multi select.

Here is something I want to confirm with you:

1). If AIField is a Choice column allowing multi select?

If so, please confirm it from the column settings and check if you have tick the multi select option.

2). If it is a Choice column allowing multi select and you want to save the combo box selected items to it, you could directly set the Items property of the Combo Box using the Choices() function:

Choices(KeyMethod.AIField)

Update property of the data card as :

AIField_Combobox.SelectedItems

3). If the AIField is a Text column and you populate the ComboBox with distinct value, then you want to save the selected items to a Choice column in the SP list, well, you need to modify as below:

ForAll(ComboBox17.SelectedItems,{Value:Result})//Here Value has a capitalization of V

Was this reply helpful? Yes No
RubyHu 7 on at

Like (0)

Report
Copy link

Link copied!

Thank for your help.😊

Was this reply helpful? Yes No
webbedfeetmaest 81 on at

Like (0)

Report
Copy link

Link copied!
Hey thank you. I've searched high and wide for a solution to this seemingly simple problem but you have nailed it.
orAll(ComboBox17.SelectedItems,{Value:Result}

Was this reply helpful? Yes No