Skip to main content
Nintex Community Menu Bar

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)? 

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.


@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.

Thank you. 


@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. 


Reply