Unanswered

SharePoint List with Multiple Values and PowerApps Data Table or Gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a SharePoint list with a column that accepts multiple inputs. When I connect the list to a PowerApps data table, I get the following error "The property on this control expects Text values. The rule produces Table values which are incompatible."

When I try to connect it using a Gallery, the card corresponding to the column doesn't even populate as an option. Please see below for screenshots. Any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

FacundoGorla 293 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, What is it that you want to see in the table?

in the data table you need to give the full table in the "Items" property, for example: Choices("SharePoint List name"."Column Name")
Then in the fields property of the datatable go to edit and addfields. It will give you the options to add the columns of your table.

Let me know if you could do it or if you want tell me the name and columns of your table and I can upload imgs of how it should look like.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for responding!

I would like the table to display all the items selected within in the drop down. It works when allowing for only one selection, but can't get multiple.

I was not able to use your solution, but I'm sure it's because I'm quite new to PowerApps. I'll give you the names and hopefully that would help. Either way, thank you so much for taking your time to assist!

SharePoint List name: ORR Test List
SharePoint List Column Name: Edit Types
Data Table Column Name: Edit Types_Column1

Please let me know if you'd like more info @FacundoGorla

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Feeding the results to a ComboBox (even if invisible) and using SelectedItems of ComboBox may help you here, though it depends.

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, drop downs only allow for one selection...combo boxes allow for more than one or list box can show more than one.

Was this reply helpful? Yes No
FacundoGorla 293 on at

Like
a
(0)

Report
Copy link

Link copied!

As stated above, you need to use a combobox to be able to select multiple choices.

In your case, you should put this in the Items property of the combobox: Choices('ORR Test List'.'Edit Types_Column1') in the format of Choices("SP list name"."Column name")
I recomend to not use spaces in your columns, or create them without a space and then add it. It would remain with the creation name.

Now insert a datatable and in the Items property put ComboBox1.SelectedItems.
then as I stated before go to the properties of the datatable, and on fields you can add what you want to show in your table from your selected items. The data will change depending on what choices you selected.

Combobox admit multiple selection by default but in case it doesn't theres a property called "Allow Multiple Selection" just set it to true.

Was this reply helpful? Yes No
ritchieliu029 8 on at

Like
a
(3)

Report
Copy link

Link copied!

Hi There,
You can use

Concat(ThisItem.<column name>,ThisRecord.Value &";")
For example:
Concat(ThisItem.ZoneTitle,ThisRecord.Value &";")

Hope it helps.

Ritchie

Was this reply helpful? Yes No