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.

1 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

enter image description here

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

  1. Filter SharePoint list items using user ID:

enter image description here


  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
  • Hi @Pradeep, Does this answers your question? If Yes, Please Upvote(^) and accept as an Answer as it will help others with same problem in future. It also removes this question from "Unanswered questions" list. If you have any doubt please ask here. Nov 24, 2020 at 15:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.