Answered

Combobox Choices not submitting to SP list field

(0) Share

Report

Posted on by neill_long

728

I have a form which has a combobox on it. You can select multiple items from this. But when the form is submitted, the column is empty and not saving what choices were selected.

The SP List field is a lookup column.

On the form, the 'Items' property of the combobox is:

Sort(Distinct(Filter(LDR_ListofEquip,Title=DataCardValue6.Selected.Value),Equipment),Result)

The update property of the datacard is:

DataCardValue38.SelectedItems

Is there a reason why the choices are not saving or is there something i can add to the formulas to make it happen?

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

npeterq 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

The update property should look something like this:

{
Id: LookUp('LDR_ListofEquip', Equipment' = DataCardValue38.Selected.Value, ID),
Value:DataCardValue38.Selected.Value
}

I think it 's having trouble looking for the ID and Value number. I had this same issue. Hopefully this helps.

Was this reply helpful? Yes No
neill_long 728 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Almost there i think. had to adjust the formula you provided @npeterq :

{
Id:LookUp(LDR_ListofEquip,Equipment=DataCardValue38.Selected.Result, ID),Value:DataCardValue38.Selected.Result
}

It now saves one item that has been selected. But it doesn't save all. I suspect i need to put a forall into this formula?

Are you able to advise how i would do this?

thanks

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @neill_long,

Yes, you need a ForAll() to loop through the selected items from the Combo Box:

ForAll(DataCardValue38.SelectedItems,{ Id: LookUp(LDR_ListofEquip,Equipment=Result, ID), Value: Result }

Was this reply helpful? Yes No