Unanswered

Getting a 'null' in my log when I try to create an array with user emails from a people column in a SharePoint List

(0) Share

Report

Posted on by iramos85

I have created a workflow that will use an email variable to send out notifications, but to get there - I have to be able to create my array and then filter out the emails from the user data. However I'm only getting "null" in my logs whenever I test out the process.

I start by getting the items for my flow:

then I initialize an array variable to hold my names:

then I use an "Apply to Each" for the two columns that I'm getting data from (Directors and Responsible Persons) and union my varEmailNames and create an array of the aforementioned columns.

and Finally I set my variable:

and to check what I am outputting, i put it all into a new variable:

Now after all of this, I run my test and I come up with:

Output Null (1 of 2)

Output Null (2 of 2)

I was actually following this article to pull in the addresses if anyone has had any experience with this sort of thing:
I was following along by this article by John Liu

Seemed pretty logical and easy, but then i kept getting "null", so i was stumped. Hopefully someone else sees what I'm missing!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

I don’t get what you want to do with all that variable and apply to each stuff. Wouldn’t a select action do what you need?

Can you provide sample input and desired output?

Was this reply helpful? Yes No
iramos85 56 on at

Like (0)

Report

I'm sorry, that would probably make this less confusing. This whole rigmarole is to accommodate the following:

The workflow is designed to send notifications out at 15, 45 and 90 days based on dates entered in a column in a SharePoint list. The notification is an email that is sent out to users that are based out of two separate columns per entry.

So because of the first ask, I had to nest the flow into a "Apply to Each" condition:
and both of the columns take multiple users, so PA automatically puts my email into another Apply for Each so I always get an error.

So my goal was to extract the user emails from the people columns, place them into an array and then convert them into a string variable so I could use that as my email distributor. Hopefully all of that makes sense

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Again. Can you provide sample input and desired output?

Was this reply helpful? Yes No
iramos85 56 on at

Like (0)

Report

Sorry, so the sample input would be:
these are user accounts that are added to a SharePoint list using a "Person or Group" column.

So the output, when i print to an email is the user accounts, which comes in as:

that email field is what i'm trying to filter out, instead of getting the entire user data

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Sorry. I can't use this as sample data to provide a solution. If you have a sample JSON with some dummy data in it and a sample JSON of a desired output, I will try to help.

Was this reply helpful? Yes No