Unanswered

Converting People Picker to Text field

(0) Share

Report

Posted on by NathanFra

183

I have a form that a requester will fill out. Towards the end they need to choose from a People/Group picker for their approver.

Once the requester submits the form, it goes off to the Approver to Approve/Deny based on an email they receive that will provide a link to a new screen within the APP for approvals. This new screen is setup with a Gallery so they can see all approvals that were assigned to them.

From what I've found, it isn't possible to set a Gallery to Filter or LookUp based on a People column from SP. So I want to have a hidden field on the requester's screen that then they select their Approver, it will auto fill a text field. This will allow me to filter in the Gallery.

Thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Person/Group columns are complex objects, so you can't use the column by itself to filter. But you can filter using the properties of the person/group column. For example, email or display name. You have to specify the property though.

Was this reply helpful? Yes No
NathanFra 183 on at

Like (0)

Report

@Pstork1 ,

I tried adding the .DisplayName, but seems like something isn't happy still.

The datacard with the people picker:

Here is the Items for the Gallery:

Thank you!

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report
Your code is trying to match the DisplayName for the current user against the full Approver column. You should do two things.

Save the current user DisplayName in a variable using the following. This is to prevent delegation warnings.
Set(CurrentUserName, User().DisplayName)

Change your code to the following
Filter('Travel Pre-Authorization',Approver.DisplayName = CurrentUserName)

Was this reply helpful? Yes No
Jasper762 2 on at

Like (0)

Report

This solution doesn't work for my situation which is a replication of the above solution.

Was this reply helpful? Yes No