So my overall goal is to be able to take a list of users in a group, then for each user in the group, create a record of their email in a table if one does not exist already. Then generate and assign a unique uid for each user in the table and then write that unique uid to a guid attribute in a user’s okta profile. I’m trying to build it out step by step for now.
Right now I am able to list the group members and add them to a table using the workflows in the screenshots. But what would be the best method to check if a user record is already added to the table, and if found skip adding another record for that user every time the flow runs?
Any assistance is much appreciated.
Hi @fishersam,
Before you save the user, you could use the Table—Search Rows card to check if the user exists in the table. If no user is found, then continue running the flow.
So what logic needs to be used in the where expression to make this correct? And would I need a continue/if or if/else card or something else added to make this work right? Im not quite understanding how to make this work just using that search rows card on its own at least.
This workflow without the search rows card works fine the first time its ran as its adding those initial users from the group to an empty table. But I am wanting to get it to the point where as users are added and the workflow runs again that it will not be duplicating the users already in the table each time its ran.
thanks for your help
The flow could look like this:
