Power Automate Filter List items by person login name

Question

We need to filter the list items by person login name (fully qualified i.e, i:0#.f|membership|[email protected]),

How we can achieve this using Power automate GetList Items method or through REST API,

Any help would be appreciated.

Answer 1

Follow below steps:

1. Get User Id from SharePoint using user login name:

REST API endpoint: /_api/web/siteusers('<login-name>')?$select=Id

Flow expression used: uriComponent(variables('loginName'))
Complete Uri: _api/web/siteusers('@{uriComponent(variables('loginName'))}')?$select=Id

2. Filter SharePoint list items using user ID:

References:

1. SharePoint REST API: Get User Id by User Name
2. get items - filter person field
3. Microsoft Docs - uricomponent() function
4. Parsing JSON in Microsoft Flow