web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Select items that only...

Power Apps

Answered

Select items that only belong to the user

(0) Share

Report

Report

Posted on by JerryH

431

Hi,

I would like to filter my list by the user.

Any idea why it does not like it? There is a RED line under the = sign

Distinct(Filter(AssetManagementHelpdDesk, Manager = MyProfile.DisplayName),ManufacturerName)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Sort by

Doug_Apicella 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Jerry,

This is caused because you are trying to evaluate two different field types. Can you provide some more detail about the myProfile.DisplayName type and the Manager type? These two types should be the same if you are using the "=" sign. Thanks.

Doug
Did I answer your question? Mark my post as a solution!
If you liked my response, please consider giving it a thumbs up

Was this reply helpful? Yes No
Verified answer

KrishnaV 5,023 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi Jerry,

Try this:
Distinct(Filter(AssetManagementHelpdDesk, Manager.DisplayName = User().FullName),ManufacturerName)
Note: I am assuming the Manager filed is a people picker field and I am checking with User() profile.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Verified answer

JerryH 431 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Krishna

Was this reply helpful? Yes No
JerryH 431 on at

Like
a
(0)

Report
Copy link

Link copied!

On Sharepoint - Manager is a 'Person or group' type column.
On PowerApps - i want the users name to populate the Sharepoint Manager Column?

Was this reply helpful? Yes No

Join the conversation