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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint List Multi-...
Power Automate
Unanswered

SharePoint List Multi-choice column in Datatable showing error

(0) ShareShare
ReportReport
Posted on by 57

1- I have created a multichoice column in SharePoint Online List and other columns also

2- created a Power app and inserted a data atble inside it to show data

3- created connection and added some column with multi choice column and its showing below error and after clicking on details it showing below

 

2.png

Untitled.png

 

Categories:
I have the same question (0)
  • RezaDorrani Profile Picture
    12,143 on at

    @vishalgoyal2472 

     

    Data tables dont work with complex types

    you can create a collection and add a new column to store that value and use the collection in data table

     

    example:

    ClearCollect(colData,AddColumns(datasource,"CountryText",Concat(Country,Value&",")))

     

    In my case Country is the multi select column

     

    Regards,

    Reza Dorrani

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

  • Verified answer
    yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @vishalgoyal2472 

     

    This is happening because Data Table expects its values to be text. As an alternate to this, you can directly refer to the column by placing the expression on Text property of the column as:
     
    Concat(ThisItem.'Issue/Objective Type',Value,",")
     
    Here, Value is the column that holds text value for choice type fields.
     
    Hope this Helps!
     
    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
  • PowerUser6 Profile Picture
    67 on at

    Thank You for your response,

     

    We tried with your approch by creating new collection and adding columns insude it.

     

    ClearCollect(IssueObject,AddColumns('Issue Objection Assignments',"Edit","Edit","IssueObjectType",Concat('Issue/Objection Type',";")))

     

     

    But , Now the datatable is showing only ;;; and not val1;val2;val3

     

    Any thought what we did wrong?

     

     

    Thanks

    Sith

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard