Answered

Include "Assigned To" as text in Gallery?

(1) Share

Report

Posted on by Aethyta

I added a connection to a SharePoint Online Task List. In PowerApps, I have 2 menus "Assigned To Me" and "Initiated By Me" -- How do I include a text label within the gallery to display the "Assigned To" name? I tried below

ThisItem.'Assigned To'

but it give an 'expected text value' error. I added .DisplayName or .Email at the end but it didnt work as well. I could not find any online resourse on how to accomplish this. The "Assigned To" column also allows multiple values.

Basically, each gallery item returns the Task Title, Due Date, and Assigned To (for Initiated By Me screen. And Task Title, Due Date, and Author for the Assigned To Me screen. For the "Author" i used below:

ThisItem.Author.DisplayName

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Tamras

'Assigned To' in a Task list is a person column. Therefore your formula ThisItem.'Assigned To'.DisplayName should be giving you results. Make sure you have not been trying to change the SharePoint list without refreshing the DataSource in PowerApps to test. If you make changes to the datasource, then you will need to refresh it to reflect the changes.

If this is not the case for you - then please provide more details on any changes you might have to the Task list and specifically the Assigned To column (i.e. have you changed it to a multiple choices option?)

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @Tamras ,

Do you enable the "Allow multiple selections" option for the "Assigned To" field in your Task List?

If you have enabled the "Allow multiple selections" option for the "Assigned To" field in your Task List, I think there is something wrong with the formula you provided.

If you enabled the "Allow multiple selections" option for the "Assigned To" field in your Task List, the result the ThisItem.'Assigned To'.DisplayName formula returns is a Table value rather than a Text value.

Based on the issue that you mentioned, I think the Concat function could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Within your Gallery, your should set the Text property of the Label to following:

Concat(ThisItem.'Assigned To', DisplayName & "; ")

Or

Concat(ThisItem.'Assigned To', DisplayName & " & ")

Please take a try with above formula in your Gallery, check if the issue is solved.

More details about the Concat function, please check the following article:

Concat function

Best regards,

Was this reply helpful? Yes No
Aethyta on at

Like
a
(0)

Report
Copy link

Link copied!

I already tried with .DisplayName and it remained blank - I also refreshed the data connection.

Was this reply helpful? Yes No
Aethyta on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @v-xida-msft , your solution worked perfectly!! And yes, I have Allow Multiple Selections enabled
Concat(ThisItem.'Assigned To', DisplayName & "; ")
I tried concat before too...but my formula used a dot not a comma between 'Assigned To' and DisplayName
Concat(ThisItem.'Assigned To'.DisplayName & ";")

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Tamras

Yup, that's why I was asking about if you had changed to Allow Multiple... 😉

Glad you got it working.

Was this reply helpful? Yes No