Unanswered

Send email using append an array from SharePoint list

(1) Share

Report

Posted on by Rajath Krishna S

Hi,

I have a SharePoint list and I'm getting the list using "Get Item" and then I'm initializing the array variable. After that I'm appending the array and inside that I'm passing the E-mail body in Json format.

Format as follows.

Then I'm passing that variable in Compose section

Then in "Send an E-mail" I'm adding the outputs in body of E-mail

But I'm getting E-mail like this, I don't know how to enter correct format.

Can anyone help?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Rajath

You are using Get Item so it's going to return always one record. You don't need a variable (Array) to map the values. Delete the variables and append array action steps. Under the send email body enter the text you want

eg: FirstName:, then map the value directly from the Get Item step. Please see below:

Was this reply helpful? Yes No
Rajath Krishna S 50 on at

Like (0)

Report

Yes, I tried this, but it will work for one list. If I use get item again to get another list and try to map the values of that item then automatically the 'Send an E-mail" is going into Apply to each loop.

Same happening for every single "Get Item"

Was this reply helpful? Yes No
Rajath Krishna S 50 on at

Like (0)

Report

Hi,
I have 4 different SharePoint lists and used 4 different get items and filtered the ID with parent ID.
I have 4 gallaries and mail is triggering for each and every entry in gallery.
Can anyone help me how to achieve this with single E-mail?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Rajath

Try the below method:

So here I have used a string variable, append the variable with the name and value. Then again append the variable with enter key for new lines. Use the variable or compose output (see above) in your email body.

Let me know how it goes.

Thanks

Was this reply helpful? Yes No