Skip to main content

Notifications

Power Apps - Building 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 

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: "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)"

    @marcy_pi always happy to help 🙂

  • MP-13011217-0 Profile Picture
    MP-13011217-0 158 on at
    Re: "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)"

    Thank You again! 🙂

  • MP-13011217-0 Profile Picture
    MP-13011217-0 158 on at
    Re: "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)"

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

  • Verified answer
    AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: "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)"

    @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
    MP-13011217-0 158 on at
    Re: "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)"

    Still no luck but thank You for suggestion 😞 

     

    marcy_pi_0-1709848114119.png

     

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: "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)"

    @marcy_pi , ThisItem.'Job Description'.Value

  • MP-13011217-0 Profile Picture
    MP-13011217-0 158 on at
    Re: "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)"

    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
    AhmedSalih 6,678 on at
    Re: "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)"

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

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

  • MP-13011217-0 Profile Picture
    MP-13011217-0 158 on at
    Re: "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)"

    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
    AhmedSalih 6,678 on at
    Re: "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)"

    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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard