Unanswered

Azure AD user values to SharePoint list

(0) Share

Report

Posted on by mcinnisbr

Hi all. I'm trying to pull user data from an Azure Active Directory and into a SharePoint list. It seems as if I'm able to grab 1 user column value (the email address). The flow doesn't fail, however, the SharePoint list doesn't seem to pick up and populate the column. I was using this as a resource without full success:
Solved: Azure Group Members Sync to SharePoint List - Power Platform Community (microsoft.com)

Categories:

Using connectors

All responses (5)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mcinnisbr ,

You have had the condition in Filter array operation been changed from "does not contain" to "equal to", could you please explain why? If the condition is equal to, all emails will be ignored since there is nothing in the SP list.

Best regards,
mcinnisbr 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, you are correct in regards to steps not followed. In making the change, I'm running into another error snag. Any ideas what this means? Is it that the AAD data type is one, and the sharepoint is another and they dont understand each other?
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mcinnisbr ,

Comparing to the thread from the link, I found that you may have mistake in Select 2,

Please change to text mode then select the dynamic content:

Best regards,
mcinnisbr 21 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-jefferni, thanks for the feedback! Interesting. However, that didn't seem to solve. Still running this error:

InvalidTemplate. The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@not(contains('(join(body(''Select''), '';'')', item()))' failed: 'The template language function 'contains' expects parameters of matching types: a dictionary and a key (string), an array and a value (object), or a string and a substring. The provided types 'String' and 'Object' are incompatible. Please see https://aka.ms/logicexpressions#contains for usage details.'.

Still wondering if this logic is off in filter array, or that I just don't understand what it's doing.
@not(contains('(join(body(''Select''), '';'')', item()))
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mcinnisbr ,

The error message is telling that the expression of filter array is incorrect, data types of the two parameters for the contains function is not matching.

You have 2 Select operators that need to switch mode for mapping:

Without switching mode, the outputs of the two operators will be blank and of type string. In that thread, the two operators are as below:

Hope this helps.

Best regards,