Form in View Mode will not display multiple Choice column selections

(0) Share

Report

Posted on by cjones2024

I have a choice column called Update Type in my sharepoint online list data source. It allows for multiple selections.

I have a form that is in View mode in my app.

I want the app to display all items that have been selected. However, nothing displays.

I have tried 25 different code combinations. Here they are with the result they yielded.

@mdevaney , @WarrenBelz , does anyone have a brilliant solution?

Categories:

Building Power Apps

All responses (14)

Answers (1)

Sort by

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @cjones2024 ,

Based on what you have posted - 'Update Type' is a multi-value Choice column, the fourth from the bottom should work

Concat( ThisItem.'Update Type', 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
cjones2024 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Thanks for the quick reply! This was what happened:
An error was produced.

Does the formula need to go in a different place?
Thank you!
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@cjones2024 ,

What type of control is that you have posted (it looks like a Data Table to me where that code would be the Text of the column) - they also do not have a Default parameter.
cjones2024 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
It's in the data card of a form.
Thank you!
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@cjones2024 ,

Sorry you have lost me - what type of control is that and how did you insert it ? I assume this is a Canvas App ?
cjones2024 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,
No worries. Yes, it is a canvas app.
To oversimplify: create canvas app => connect to data source (sharepoint online list) => insert form => set form to View mode => 'Update Type' information does not display correctly.
Is there more clarification I can provide?
Thank you!
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@cjones2024 ,

Yes, but what type of control is it (Text Input/Combo Box / Drop-down)
cjones2024 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

It is a combo box.

Thank you!
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@cjones2024 ,

OK - I can see why I was confused as your initial post had what looked like a Data Table in it and you are using Concat, which outputs a String, so I was expecting something that displayed a table converted to a string. What you need is a Label underneath your Combo Box with the formula I first posted. If you try to display that in the Combo Box, you will not save the correct data.

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
cjones2024 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Unfortunately, that did not help. There is still an error at the data card level, and the Label with your formula displays nothing.
Are there any screenshots I can provide to explain further?