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 / "The columns produced ...
Power Apps
Answered

"The columns produced are all nested tables and/or records, however the property expects at least some columns of simple values (such as text, or numbers)"

(0) ShareShare
ReportReport
Posted on by 158

Hello All!

 

I have an issue to access my data in one of the Sharepoint column. The column is a choice type called "Job description" and is set up the same as my other one called "Process". For some reason it is displaying data type "Record" for Process and "Table" for Job description. How I can convert Table type data from my column so I can access it through dropdown box please? I can't even view this data in my gallery as it's Table format... 

 

marcy_pi_0-1709814714640.png

marcy_pi_1-1709814733706.png

 

 

 

Regards 

Categories:
I have the same question (0)
  • AhmedSalih Profile Picture
    6,680 Moderator on at

    Hello, @marcy_pi, I am not clear about how you are presenting the SP list, if you are linking the list to a Gallery control, and you want to show the Choices column value in a text input control or label, use ThisItem.'Job description'

     


     

    If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

    Visit my Blog: ahmedsalih.blog

    Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

  • MP-13011217-0 Profile Picture
    158 on at

    Hello,

     

    This is error I am getting when trying to compare my data from sharepoint colum with data from dropdown box.

     

    marcy_pi_1-1709816868227.png

     

     

    Regards 

     

    marcy_pi_0-1709816836444.png

     

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    @marcy_pi, in the ComboBox, are you pulling the choices using similar formula:

    Choices([@YourSharePointList].'Job description')

  • MP-13011217-0 Profile Picture
    158 on at

    Ok it is working but how do I include this data in my gallery as this is not working when I try ThisItem.'Job description'. I also tried the name from SP which is Jobdescription and it just won't pull the data. 

     

    marcy_pi_1-1709818948651.png

     

     

     

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    @marcy_pi , ThisItem.'Job Description'.Value

  • MP-13011217-0 Profile Picture
    158 on at

    Still no luck but thank You for suggestion 😞 

     

    marcy_pi_0-1709848114119.png

     

  • Verified answer
    AhmedSalih Profile Picture
    6,680 Moderator on at

    @marcy_pi, this could be due to your Choice Column is set to be multichoice column and in that case, you need to use the function Concat to column values into a text:

    Concat(ThisItem.'Job description'.Value, Value & ", ")

     

     


     

    If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

    Visit my Blog: ahmedsalih.blog

    Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

  • MP-13011217-0 Profile Picture
    158 on at

    It works!!!!!!!!!!!!!!!!!!!!!! THANK YOU SOOOOOOOO MUCH!!!! 👌🙏🙏🙏

  • MP-13011217-0 Profile Picture
    158 on at

    Thank You again! 🙂

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    @marcy_pi always happy to help 🙂

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 273

#3
Kalathiya Profile Picture

Kalathiya 232 Super User 2026 Season 1

Last 30 days Overall leaderboard