Combobox responses not stored in Sharepoint List

(0) Share

Report

Posted on by diegoandre10

517

Hi all

I have dependent combo box's, they work well. The problem is that when I save the form, the region/country/bottlers responses are not stored. The SP list shows empty values.

I have 2 SP lists. One for the dependent dropdowns (Facilities_LATAM) and the one that stores the responses (BCP LATAM):

sd;lfksl;dkf;l1.JPG

lsdkfs;ldk1.JPG

The comboboxes code are the following:

Region items:

Region displayMode:

Region OnChange:

sfd;lksd;fl.JPG

Country items:

Can you please advise why the responses are not stored in SP?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @diegoandre10 ,

Could you please share the details about the lists? Which type are the two columns Region and Country in the BCP LATAM list?

I assume they are both text columns, then the Update of Region and Country Data Card should be:

ComboboxRegion.Selected.Result
ComboboxCountry.Selected.Result

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni

They are choice:

And for Facilities_LATAM they are single line of text.

Where is the Update card? Can't find it:

Thanks!

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @diegoandre10 ,

Since they are both Choices columns, you will need to change Update of the two Data Cards to:

LookUp(Choices('BCP LATAM'.Region),Value = ComboboxRegion.Selected.Result)
LookUp(Choices('BCP LATAM'.Country),Value = ComboboxCountry.Selected.Result)

Cards are the controls in the Edit Form, which would include sub controls for user interactive:

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni this works for storing multiple choices too?

Thanks!

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @diegoandre10

For multiple-choice column, Update command should be

ComboBox1.SelectedItems

Sample
Single choice column
Combobox.Selected

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @diegoandre10 ,

No, it would be totally different if the two columns are allowing multiple selections choice type columns in you case. You need to determine your scenario first then start to create the App, otherwise, with the development of the APP, you will find that there are continuous problems and it is more and more difficult to find the source.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No