Get Items from SharePoint list, compose email body with all items and send one email using flow?

[ahsanranjha]

Get Items from SharePoint list, compose email body with all items and send one email using flow?

[BigShotRob]

I would like to chime in and say I'm trying to do this EXACT thing right as we speak and can't seem to get it to work.

[v-xida-msft]

Hi @ahsanranjha,

Do you want to include all items which are from SharePoint list into an email body?

I think a HTML table could achieve your needs. I have made a test on my side and please take a try with the following workaround:

1. Choose a proper trigger, here I use Flow Button trigger.
2. Add “Get items” action.
3. Add “Create HTML table” action, From set to output of “Get items” action.
4. Add “Send an email” action. Body set to output of “Create HTML table” action.

Image reference:

The flow works successfully as below:

 

Best regards,

Kris

[BigShotRob]

This works.. but is there a way to choose what fields are coming back? The output that gets put in a HTML is just a mess, so unless there's a way to dictate that, I can't see this as a useable solution, because it makes the data I'm trying to show really hard to look at in a meaningful way 😞

Crossing my fingers here..

[v-xida-msft]

Hi @ahsanranjha,

Do you want to choose the fields are coming back by yourself?

You could add a “Select” action to filter all items. Please take a try with the following workaround:

• Choose a proper trigger, here I use Flow Button trigger.
• Add “Get items” action.
• Add a “Select” action, within Map entry, please type the content as below:

• Add “Create HTML table” action, From set to output of “Select” action.
• Add “Send an email” action. Body set to output of “Create HTML table” action.

Image reference:

 The flow works successfully as below:

Hope the above solution could help you.

Best regards,

Kris

[BigShotRob]

This is what I'm loooking at now, so I do have it a little bit more manageable, if the field types I'm returning are flat text, but fields like date come back in that form, just wondering the best way to get those all looking "clean" -- I thought of adding a calculated column for the really problematic fields, but that's not a good long term solution if I have to do this again, which I'm certain I'll want.

What do you suggest to be able to clean up the data returned if delivering through an HTML table?

[ahsanranjha]

Thanks you. 

how you map list field values in table column. I tried to find it but can't not implement it.

[BigShotRob · Accepted solution]

Once you add the "Create HTML Table" action just click the arrow to "show advanced options", you'll see the map ability there.

[ahsanranjha]

Thanks, that was not available when i created flow, after save and publish then i went to check it again, it displays options to map fields.

[jcbarrett]

How do I check if the Get Items returned no values.   I'm running a flow daily to check for items created that day...if no items were created, it still generates an empty email because I don't have conditional logic in it 

[pukut]

@jcbarrett 

Had the same issue. After 3 days of agony finally solved it: length(body('Get_items')?['value']) is equal to 0

Hope this helps!

[Anonymous]

Hi, I am trying to do the same but trying to return a list of items from a shreapoint list based on a criteria within a column. For example - return all items with YES in the YES/NO column. 

I keep getting separate emails for each item on the list and also the email body is all jumbled up 

If someone could help that would be great

Thanks

[Shabby]

Hi  where does the condition fit in? straight after Select? 

and what happens with the conditions? 

Apologies, just started with sharepoint and flow.

[pukut]

Hi Shabby,

I used Get Items then the condition, after which you define what will happen in the if yes and in the if no branch.

[Shabby]

Thank you, Although it seems to be doing something different that I need to. 

Thank you so much though!! 

Think i will open up a diff forum question for what i need

---

@pukut wrote:

Hi Shabby,

I used Get Items then the condition, after which you define what will happen in the if yes and in the if no branch.

---

.

[buro2020]

I don't have the option in advanced options to display the email in HTML in my sharepoint flow.

I also tried to customise the columns I wanted to display the information in an email, which did not work.

The email I received as a test run turned out as below:

my sharepoint workflow below, the first two steps are re-occurrence and get items (which work):

Can anyone assist me in this issue?

[Bagulhem]

getting below error

[Claud]

Hi there, I struggling to do something similar in my flow.... can you please provide screenshots with the various sections expanded?

Thanks.

[azza2004]

Hi

I'm trying to achieve the same thing.  Were you able to solve this?

Thanks

[jcbarrett]

Yes - Use the HTML Create Table - and select the fields you want to display