Answered

Multi selection columns not displaying - data type wrong?

(0) Share

Report

Posted on by AmeliaDwight

Hi,

My multi choice columns are not displaying and are are showing, [Option], [option] ect, but my single choice columns are. The data type for the columns are different (see image) so wondered if i needed to change the multi choice column data type to complex, like the single choice column. Not sure how i would do this tho! - The data is connected to a table made on PowerApps.

I am happy to use a gallery instead if there was a way to scroll horizontally as there will be lots of columns and vertically just like the table allows.

Thanks!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AmeliaDwight ,

Change the Text property of the column to

Concat( ThisItem.'Physical TouchPoints', Value, "," )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
AmeliaDwight 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

This worked great thanks! i had to use it on a few more columns so that i had
Concat(ThisItem.Market,Value,",") and this worked!
Now i would like to make a filter for my table using market but it is saying this is invalid - i assume because of the data types of market that i had to change from ThisItem to Concat..... Please you you help?? Below is what i tried and is invalid.
Filter(Tracks,IsBlank(Dropdown1_10) || Market = Dropdown1_10.Selected.Value)

I assume i need to change 'market' to something?

Thanks,
Amelia
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AmeliaDwight ,

Probably this

Filter( Tracks, Len(Dropdown1_10.Selected.Value) = 0 || Market.Value = Dropdown1_10.Selected.Value )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
AmeliaDwight 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

It says the values being compared are not the same data type?
My drop down filter is Choices(Tracks.Market) (table data type)
My Market column is Concat(ThisItem.Market,Value,",") (text data type)
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@AmeliaDwight ,

What type of field is Market and what is your data source ? If Market is a choice field in SharePoint, is it single or multi value ?
AmeliaDwight 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

Dont worry - i just recreated the column in the table and it created the right data type for me!