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
@marcy_pi always happy to help 🙂
Thank You again! 🙂
It works!!!!!!!!!!!!!!!!!!!!!! THANK YOU SOOOOOOOO MUCH!!!! 👌🙏🙏🙏
@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
Still no luck but thank You for suggestion 😞
@marcy_pi , ThisItem.'Job Description'.Value
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, in the ComboBox, are you pulling the choices using similar formula:
Choices([@YourSharePointList].'Job description')
Hello,
This is error I am getting when trying to compare my data from sharepoint colum with data from dropdown box.
Regards
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