I currently have a couple SP lists that are referenced in my app.
On one data table, I have a few records being displayed based on a gallery selection.
One of those columns I want displayed is a 'Person or Group' data type.
PowerApps does not like this, and is expecting a text value. Any ideas on how I could display this information as a text data type?
I am currently using ThisItem.Supervisor as my code (doesn't work).
I used ThisItem.COLUMN.Value in other areas where I had similar issues, and that worked, but not for this specific column/data type.
Solved! Go to Solution.
In case you folks are curious, this is the code I was required to use:
Concat(ThisItem.'Supervisor'.DisplayName, Concatenate(Text(DisplayName),", "))
Glad to have it working now! Had me stumped for a couple days 😤
Still don't know why it works, but we'll take it.
Not working perfectly though. Only the first record in the 'Supervisor' column in my SP list is being returned to the data table, even though I have multiple users selected for that record.
Unles the Supervisor column is saved as text type in the list, I have no idea why this is happening.
Maybe disconnecting the source and re connceting it again sets everything right.
Hi Charlie, thanks for taking a look, but still getting an error in this column...
If it helps at all, I had errors in another column I fixed by using this code:
Concat(ThisItem.'Session type'.Value, Concatenate(Text(Value),", "))
Hi @aebara ,
I suspect your Supervisor column is multi-select, in which case if you only ever have one item selected
Concat( ThisItem.Supervisor, Value )
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Happy to see you here 😊
Still getting an error using this formula unfortunately.
Yes, this is a multi-select column. Most times there will only be one selection, but I wanted to leave the possibility of having multiple selections open.
Any more ideas?
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.