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
View original
+16
Hi
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
+13
Hey
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?
+8
Thank you.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.