"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) Share

Report

Posted on by MP-13011217-0

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

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Hello,

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

Regards

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@marcy_pi , ThisItem.'Job Description'.Value

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Still no luck but thank You for suggestion 😞

Was this reply helpful? Yes No
Verified answer

AhmedSalih 6,680 Moderator on at

Like (1)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Thank You again! 🙂

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (1)

Report
Copy link

Link copied!

@marcy_pi always happy to help 🙂

Was this reply helpful? Yes No