Unanswered

SharePoint List columns modified in PowerApps do not populate the SharePoint list

(0) Share

Report

Posted on by Deb30001

My SharePoint columns were set to a Single line of text. In PowerApps I changed some of them to Dropdowns or a ComboBox with the source data from a different list and depending on another Dropdown.

PowerApps works but the SharePoint list does not recognize the Dropdown choices.

I then changed one of the SP columns to Choice, but that didn’t work.

This is the Items fx in PA for an existing column in SP:

Filter('A different list on SharePoint', ''Specific Column' = A Dropdown created in PowerApps.Selected.Result)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Deb30001

If you are referring to controls in an edit form, you need to change the Update property of the card containing the dropdown or combobox to recognize the new control, like Dropdown1.Selected.Value or Combobox1.SelectedItems or Combobox1.Selected.Value.

FYI, the Update property of the card is the only important property for saving data. The rest are bells and whistles.

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (1)

Report
Copy link

Link copied!

I personally use only text and number column types as much as possible for my SP lists. This keeps them simple and makes patching much easier. When I want to data to be a data or a number or be chose from a list of options, I just build that into the Power Apps side. Here is an example:

You want to have a choice column in SP that users can select from in Power Apps with choices new, started, complete. Rather than make that a SP complex column I would just make it a single line of text column and build the Power App in a way that let them chose from only those choices. this will give the same end result but without the headache of patching complex columns.

Patch(yourlistname, itemtopatch, {textcolumn: Dropdown.selected.columname})

Was this reply helpful? Yes No
Deb30001 28 on at

Like (0)

Report
Copy link

Link copied!

I must be dumber than a stump. I have DataCardValue1.SelectedItems.
What do I change it to?

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

Like (0)

Report
Copy link

Link copied!

Try not using comboboxes unless you require the Search or Multiselect properties. Use dropdowns instead if possible, they are easier to work with.

@Deb30001

Was this reply helpful? Yes No
Deb30001 28 on at

Like (0)

Report
Copy link

Link copied!

If I want them to choose more than 1 selection, my understanding is I need a Combobox. What other solutions are there?

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

That would be the multiselect property he was speaking of so you are on the right track with the control it seems like. The only way to change that would be to use multiple dropdowns. Not sure if that is feasable for you or not but it would be a sort of an awkard work around.

combobox's with multiple selections enabled have a return type of table. This is what makes them a pain.

If you are sure that only 2 can be selected for example you could do something this as a work around:

this just takes the first item and last item in the table returned by the combobox and concats them together with a comma in between. Not sure if this will work for your case. That string in the text box could then be saved to SP. If you had to read it in the future you would split it on comma and then have your original values again.

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

Like (2)

Report
Copy link

Link copied!

@Deb30001

You have chosen one of the more difficult things to do. In general I never use complex column types in SharePoint and stick to only single line of text, date/time and number columns. That said, check out Shane Young's recent video on how to patch complex column types for some clues: https://www.youtube.com/watch?v=b4Fb57UsJLI

Was this reply helpful? Yes No