web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Unable to add multiple...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • WarrenBelz Profile Picture
    155,224 Most Valuable Professional on at

    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

  • AB21 Profile Picture
    on at

    Hi Warren,

     

    That didnt work. Screenshot 2024-04-15 at 13.43.04.png

     

    Any ideas? 

  • WarrenBelz Profile Picture
    155,224 Most Valuable Professional on at

    @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

  • AB21 Profile Picture
    on at

    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: 

     

    Screenshot 2024-04-16 at 08.31.58.png

     

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

     

    Screenshot 2024-04-16 at 08.31.54.png

     

    Is this a sharepoint setting or power app? 

  • WarrenBelz Profile Picture
    155,224 Most Valuable Professional on at

    @AB21 ,

    That is what the code I supplied does

  • AB21 Profile Picture
    on at

    Where do I need to put this code? 

     

    I have tried it in default but it errors out

  • WarrenBelz Profile Picture
    155,224 Most Valuable Professional on at

    @AB21 ,

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

  • AB21 Profile Picture
    on at

    Apologies for not being clear: 

     

    Screenshot 2024-04-16 at 09.51.35.png

  • WarrenBelz Profile Picture
    155,224 Most Valuable Professional on at

    @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.

  • AB21 Profile Picture
    on at

    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. 

    Screenshot 2024-04-16 at 09.58.47.pngScreenshot 2024-04-16 at 09.58.58.pngScreenshot 2024-04-16 at 10.00.02.png

     

    Screenshot 2024-04-16 at 10.10.34.png

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 762

#2
11manish Profile Picture

11manish 640

#3
Valantis Profile Picture

Valantis 548

Last 30 days Overall leaderboard