Unanswered

Filter Not Working For People picker

(0) Share

Report

Posted on by Community Power Pla...

Filter('Process Details', 'Process Name' = DataCardValue77.Selected.'Process Name').'Process Manager'

Above is the formula written on the item property DataCardValue128 which is a people picker. The value should display from the other SharePoint list page based on the process name.

'Process Name' -> is the column from 'Process Details' SharePoint list

DataCardValue77.Selected.'Process Name' -> is the field where process name is selected.

'Process Manager' -> is the corresponding manager for that process name from the 'Process Details' list

Thanks in Advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Can you describe more about what the problem is that you are having? Perhaps some screenshots would be helpful as well!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

I need to filter the people picker value 'Process Manager' based on the condition 'Process Name' = DataCardValue77.Selected.'Process Name'
Do i need to use choice. Then how to apply the below condition.

Filter('Process Details', 'Process Name' = DataCardValue77.Selected.'Process Name').'Process Manager'

Thanks in Advance

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Anonymous，

'Process Name' and 'Process Manager' are both Text column, right?(IMPORATNT)

You should tell us how you set the Items property of the DaaCardValue77, populated with 'Process Details'.'Process Name'?

1). If both 'Process Name' and 'Process Manager' are Text columns, the Filter() function you provided is correct.
2). If the Process Name' is Text and 'Process Manager' is Person type, please modify your Filter() as below:

Ungroup(Filter('Process Details', 'Process Name' = DataCardValue77.Selected.'Process Name').'Process Manager',"Process Manager")

Was this reply helpful? Yes No