Unanswered

Extract otherMails from AD user record

(0) Share

Report

Posted on by geomin

Hello everyone,

I am very new to Power Automate and have been struggling with an issue for the past few days. I'm building a SharePoint employee listing and would like to display "otherMails", which is set to the user's proper email address. I queried the AD user account for the fields, including "otherMails", to be displayed on the employee listing. I then used Parse JSON in order to allow me to extract the required data. When I run the flow, it appears to be extracting the data, including "otherMails", however I cannot seem to extract and save the data from "otherMails". Can someone please indicate exactly how I can extract the otherMails data that has been obtained from the query of the user profile? I have included details of my flow's run below:

I then set a variable with "otherMails" from Parse JSON:

I then create a list item. Notice that the email field, which specifies my variable, is blank:

Here is the flow's config:

...

All fields, except E-Mail/OtherMail, are present in the SharePoint list.

Any assistance would be appreciated.

Thank you

George

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@geomin , please note that OtherEmails is an array. You need to extract the item from the array before saving them into SharePoint.

You could try something like

json(variables('OtherEmails'))[0]

If the field is blank this will throw an error, so perform a conditional check as well

Was this reply helpful? Yes No
geomin 6 on at

Like (0)

Report
Copy link

Link copied!

Hello @SudeepGhatakNZ ,

thank you for your assistance. When I try to evaluate the length of the "otherMails" to determine if it is empty, I receive an error indicating that it is a null value. I'm not sure why it is doing this.

Thank you
George

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
can you add the following in compose on top of the condition?

body('Parse_User_Profile')['body']?['otherEmails']

I have a suspicion it is returning null for some records

Was this reply helpful? Yes No
geomin 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @SudeepGhatakNZ, I assume you meant this:
I used the output of the Compose in condition3 and again in the set variable, after the condition is evaluated:
The process then fails when setting the variable:
Would the Compose not have replaced ''body('Parse_User_Profile')['body']?['otherEmails']" with the actual value in the array? I assume that I would set the variable via "
json(outputs('Compose_otherMails'))[0]".

Thank you!

George

Was this reply helpful? Yes No