question Re: Microsoft Ad Spoke - MemberOf groups issue in Developer forum

Microsoft Ad Spoke - MemberOf groups issue

Community Alums — Tue, 18 Jun 2024 20:19:44 GMT

I am using the OOB Look up User action which returns a user object. One of the values is memberof which is an array,string of the all the groups a user belongs to. This works fine but when I try to loop through those I get an error.

I see that other folks have had the same issue as well. https://www.servicenow.com/community/developer-forum/parse-json-string-from-microsoft-ad-spoke-lookup-user/m-p/2403809 had a solution but didn't provide enough detail. I am not sure how they got the memberof into JSON. Either way, has anyone run into this and found a solution?

Re: Microsoft Ad Spoke - MemberOf groups issue

vermaamit16 — Wed, 19 Jun 2024 07:13:13 GMT

Hi @Community Alums

Refer below posts which could be helpful :

https://www.servicenow.com/community/developer-forum/convert-string-list-to-convert-to-array-list-get-catalog-in-flow/m-p/1812001

https://www.servicenow.com/community/developer-forum/how-to-iterate-an-array-string-in-the-flow-designer/m-p/1843363

https://www.servicenow.com/community/developer-forum/output-array-string-to-record-in-flow-designer/m-p/2842314/page/4

Thanks and Regards

Amit Verma

Re: Microsoft Ad Spoke - MemberOf groups issue

Community Alums — Thu, 20 Jun 2024 15:41:44 GMT

I have seen all of these posts hence why I created a new post. These posts don't solve my issue which is that I need to be able to access an array which is part of a complex object.

Re: Microsoft Ad Spoke - MemberOf groups issue

Sumanth16 — Thu, 20 Jun 2024 16:11:56 GMT

Hi @Community Alums ,

Please refer to below thread:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0951861

https://www.servicenow.com/community/workflow-automation-forum/unable-to-create-serializable-iterator/m-p/2955380

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Thanks & Regards,
Sumanth Meda

Re: Microsoft Ad Spoke - MemberOf groups issue

Afrim Patrix — Wed, 25 Sep 2024 18:12:17 GMT

Not sure if you already found this but incase anyone else has the same issue please take a look at https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1701059

You need to create a copy of the existing action with a new output variable

Label - Member Of

Name - memberof

Type - Array.String

After creating the new output variable drag and drop the 'Member Of' Data object from the 'Post Processing & Error Handing' section

After saving and publishing, if you use the new action and the new Member now it should give you the expected array data containing the groups of the user found

Regards