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):

Please note Facilities_Latam datatypes are singles line of text. While Region/Country/Bottler/Plant fields for 'BCP LATAM' SP are choices.

The comboboxes code are the following:

Region items:

Region displayMode:

Region OnChange:

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 (23)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@diegoandre10
What is the Update property of the datacard? That is what dictates what is stored.

It should (most likely) be:

{Value: ComboboxRegion.Selected.Result} (if you are using Distinct in the items).

I hope this is helpful for you.

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

Like (1)

Report
Copy link

Link copied!

Hi @diegoandre10

In "BCP LATAM", Are region, country, and Bottler are Lookup to another SP List?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@StalinPonnusamy good point! I saw that they were Choice columns, but that seems to be the other list.

@diegoandre10 on that note, I'd first consider if you really want to use a complex Lookup or Choices type in your list over a simple text column as this would be much easier.

Beyond that, I would then have some questions on your use of the Distinct function in the items property of your controls. Distinct will ONLY return a single column table of results. In order to update a Lookup column, you're going to need that ID of the foreign record and the Value of the foreign record. So, distinct is going to cause some concerns.

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes and @StalinPonnusamy

It worked with {Value: ComboboxRegion.Selected.Result}

The only problem is that the SP stores only one answer and not the multiple values.

See example:

Input

SP list:

Seems to be storing the latest answer submitted on the PowerApp form.

What can I do in this case?

Thanks!

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@diegoandre10

So you are trying to set multiple values...if that is the case, you first need to make sure your column in the sharepoint list is defined to allow multiple items.

Then, change your Update property to the following:

ForAll(ComboboxRegion.SelectedItems, {Value: Result})

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report
Copy link

Link copied!

The SP Facilities_LATAM that works as a dependent dropdown is simple line of text:

Regards.

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes

BCP LATAM has allow multiples choices:

Facilities_LATAM is only text therefore:

When I tried the code for Region card I get an error on update :

Thanks!

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes

It did work the code on Country and Bottler:

Region stays the same as:

Now when I press the button save, the record doesn't go through to the SP list (no error appears).

Thanks!!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@diegoandre10

Can you hover over the red underlines in the formula editor and tell me what the error is that comes up?

Was this reply helpful? Yes No
diegoandre10 517 on at

Like (0)

Report
Copy link

Link copied!

Sure @RandyHayes

For region card:

Thanks.

Was this reply helpful? Yes No