Filter Query Based on SharePoint List Person Field in Power Automate

This video will walk through how to apply a query filter on a SharePoint list person field using Power Automate flow. I have used the "Get items" action of Power automate to retrieve data from the SharePoint list. The OData filter query in power automate can't filter person objects instead it can only filter on the specific attributes of the person field. In this example, I will be using the Email attribute of the person object to filter the SharePoint list inside Power to automate the "Get Items" Action.
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#PowerAutomate
#SharePoint
#GetItems

[@anayaali6189]

This video helped me alot Jazak Allah🥺❤

[@KeaPointTechTips]

Thanks Anaya.

[@aliparvaiz56]

Great video!

[@KeaPointTechTips]

Thanks.

[@tezcansarraf1854]

Really wonderful solution..

[@KeaPointTechTips]

Thank you.

[@nitinjain4519]

how to do using claims

[@Zunira-eo4yn]

Hi! Instead of EMail, can you guide , how i can do that with Picture.. if i want to filter only those user who don't have any profile picture.

[@KeaPointTechTips]

I tried this in Powerapp, never did it in power automate Filter(Office365Users.SearchUser({searchTerm:TextInput1.Text}),Office365Users.UserPhotoMetadata(Id).HasPhoto = false)

[@vipulpotdar3053]

How to do this for getting dynamic email address

[@KeaPointTechTips]

Thanks

[@craigf5773]

🙌 promosm

[@KeaPointTechTips]

Thanks.