Answered

Gallery issues: displaying username "This formula uses scope"

(0) Share

Report

Posted on by RubenPuertos3

I'm having some issues when I'm trying to display in a Gallery the name of the user that was assigned to one of the jobs created in my app. The message that I'm getting is ThisItem.'Lead SRO' = This formula uses scope. which is not presently supported for evaluation DATA TYPE: Table.

The app uses a sharepoint list and this field comes from a 'Person or Group' column.

To assign a job, the app uses a ComboBox to select the Username and there is no values included as Default.

I'm attaching a picture of how it looks like.

Thanks in advance for your help team

Categories:

Building Power Apps

All responses (10)

Answers (2)

Sort by

Samuel-Zhou 393 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RubenPuertos3 Try input
ThisItem.'Lead SRO'.Displayname
RubenPuertos3 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Samuel-Zhou, unfortunately "Displayname" is not working, the message that I get from it is: "Name isn't valid. "Displayname" isn't recognized"
MaximusDecimus 281 on at

Like
a
(0)

Report
Copy link

Link copied!

Going on the back of Samuel-Zhou - when you add the . after ThisItem.'Lead SRO' do you get any additional fields that you can select?
ThisItem.'Lead SRO' seems to be return a table
Samuel-Zhou 393 on at

Like
a
(0)

Report
Copy link

Link copied!

@RubenPuertos3 OK, you can first confirm what content will be displayed for ThisItem.'Lead SRO'.
RubenPuertos3 35 on at

Like
a
(0)

Report
Copy link

Link copied!

I can choose must of the other fields (Microsoft List), LeadSRO is coming from a column that is Person or Group, I'm wondering if that is part of the problem.
RubenPuertos3 35 on at

Like
a
(0)

Report
Copy link

Link copied!

I would like the name (FullName) of the individual to be displayed.
Samuel-Zhou 393 on at

Like
a
(0)

Report
Copy link

Link copied!

@RubenPuertos3 Normally, the personnel or group field should have the following fields for selection, as shown in my figure below:
RubenPuertos3 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Samuel,

I'm trying to include the Displayname but I'm getting the message "This formula uses scope, which is not presently supported for evaluation"

I would like to display the name of the user.
Verified answer

Samuel-Zhou 393 on at

Like
a
(1)

Report
Copy link

Link copied!
@RubenPuertos3 I guess your person or group field may have enabled the option for multiple selections. Try setting the formula to:

Concat(ThisItem.'Lead SRO',DisplayName,",")
Verified answer

RubenPuertos3 35 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks Samuel, the error has disapeared; however, my issue was that I did set up my List as 'multiple selections', once I deactivated that option I could see the name of the user.
Thanks Samuel and thanks team, that was the solution