Cannot query by user unless we have the “ID” of the person within the sharepoint list. How do you do this dynamically (varies based on several factors so we only have email addresses at this point in the workflow).
Please enlighten me on how this is achievable with query a list item for sharepoint online and conditions for data sources (same issue - only can filter by ID if data source is using sharepoint online connector)?
Best answer by rickdemarco
+16Save the Users’ email address (or Full Name) into a People column on SPO site.
Query the same People column to retrieve the ID.
Create a Component Workflow for this if you are regularly using this function.
Then you should be able to use the ID in a Query list Item
Hope that helps
+13Start Form with people picker (authenticated form)
Workflow will query a list in sharepoint to find list items where the user is listed in a person or group field.
I have to create a “fake” item in a “fake” list to obtain this “ID” because the conditions do NOT include person field email option. Why does the condition not include email as an option to filter by on a person field?
+8Thank you.
+3
+22Would querying the User Information list with the email address to return the ID help with this issue?
Example https://YourTenant.sharepoint.com/_catalogs/users/detail.aspx
+3
+22Hi
The user profile in Active Directory (AD) and the user information in SharePoint profiles are different. If you want to use the Query List action, you'll need to find the user's SharePoint ID. There are a couple of ways you can do this! Garrett, for example, adds the user to a SharePoint list and then queries the user for their SharePoint ID. Another option, as I mentioned, is to query the User Information list, which could involve making a simple API call. Whatever works best for you!
+3
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
