Hi @brandiwoodson
Save 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
Hey @brandiwoodson
could you share some quick screenshots explaining the steps you want to take?
Start 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?
@brandiwoodson Yes we are looking into how we can support these additional filters in the condition builder (email and display name) jsut like we do in the start event conditions.
@rickdemarco any progress on this? It's been over a since the questions was asked. I can query active directory for the user via email, but that does not return the ID needed to find that same person in the SharePoint list. If the ID was returned that would at least be somewhat helpful.
Would 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
@SimonMuntz I queried the user using the Azure Active Directory command to Get Details, that returned everything except the ID. So, you are suggesting that I make a Rest call?
Hi @jschmidt7,
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!
@SimonMuntz , Ook, thanks for the clarification. I will need to query the User Information list then.