Unable to insert record in group member table through flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 04:16 AM
I have a flow designer developed for AD integration with Servicenow through AD spoke
While trying to add user to group in Servicenow instance after adding the users to the AD group I am getting an error that says "Error occurred while inserting record : null"
I have referred to the KB article available but they do not provide a clear fix as expected
I have already referred to these KBs: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0827213
And related KBs to this error but unable to find a fix
Below is the flow with error execution:
Actual flow logic:
Please let me know if you could find the issue?
- Labels:
-
flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 06:24 AM
Yes tried creating a subflow but no luck
Same error in that case swell

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 05:00 AM
Hey,
Few things to check here,
- Does the user and group exist in the SN tables?
- Make sure, we are passing "sys_ids" for both user and group.
- Check if Flow is running as system user
Feel free to mark correct, If I answered your query.
Will be helpful for future visitors looking for similar questions 🙂
Aman Kumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 05:02 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 10:07 PM
Hi,
I would suggest that you remove your custom action (step 5), and instead do it in 2 separate steps, as follows:
- Look up records (sys_user or whatever record you are using as List collector value) where sysID is one of Step1->List collector values
- For each record found in above action, to a create record (your step 9 currently).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-02-2022 06:25 AM