Unanswered

Unable to add multiple choices in form on powerapps linked to sharepoint data source

(0) Share

Report

Posted on by AB21

Hi all,

I have a error pop up on my form in powerapps which datasource is sharepoint. I have created a column within my sharepoint list

Screenshot 2024-04-15 at 12.35.29.png

And on the power app I get:

Screenshot 2024-04-15 at 12.27.54.png

Form:

Screenshot 2024-04-15 at 12.36.52.png

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (0)

WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report
Hi @AB21 .

Try

ThisItem.'Lunch Items'.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

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

Hi Warren,

That didnt work.

Any ideas?

Was this reply helpful? Yes No
WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report
@AB21 ,

If you want a string value

Concat( ThisItem.'Lunch Items', 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

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

Hi,

I have managed to get the items appear in sharepoint via the power app by removing the form and adding it back in however they come in like this:

But I need the items to appear like this in sharepoint:

Is this a sharepoint setting or power app?

Was this reply helpful? Yes No
WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report

@AB21 ,

That is what the code I supplied does

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

Where do I need to put this code?

I have tried it in default but it errors out

Was this reply helpful? Yes No
WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report

@AB21 ,

Sorry, but I am getting a bit lost here - where are you using this code ?

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

Apologies for not being clear:

Was this reply helpful? Yes No
WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report

@AB21 ,

That is the Data Card, not the control - it will not work there as this simply needs to refer to the field. Also you need a Text control if you want to have comma-delimited values - if it is a drop-down, you need it the way it is now.

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

I'm not entirely sure how I managed to achieve it for another column with a dropdown on a different screen / form.
I have a screen (screen1) designed for processing orders, and it functions as intended.

I duplicated this screen (lunchv2)

In the original screen (Screen1), the comma functionality works flawlessly. However, I can't recall the specific method I used to enable this, I duplicated the screen (lunchv2) to substitute "food options" with "lunch items" while still utilising the same SharePoint list.

Given that I've replaced "food options" with "lunch items" in the duplicated screen, it seems likely that the code responsible is embedded somewhere within the data card.
If not there, perhaps it's associated with the SharePoint list. Any thoughts or suggestions on where to find it?

Was this reply helpful? Yes No