Unanswered

email a list of items from SP Lists

(0) Share

Report

Posted on by YEUNG_Gabriel

I am trying to use FLOW to email me a LIST of contents from a Sharepoint LIST. I know it cannot be filter by Formular column so I just try to email the whole LIST to my mailbox then I write some outlook VBA to manual filter it.

However it seems automatically add a "Apply to each" and email to me Record by Record (some it sent many emails) in this format ...

639.916789409719Health & SafetySURNAME, OTHERNAMEmyname@mydomain.comhttps://xxxxxx.sharepoint.com/team/HongKong/Training/_layouts/15/UserPhoto.aspx?&Size=S&AccountName=myname@mydomain.comChan Yin XXXXXX2019-04-22ExternalXXX1716Blue Card - Shipboard Cargo Handling Basic TrainingXXXXXX1716

can I have email with delimitator AND only ONE Email ??

columnA, ColumnB, ColumnC, ColumnD, ColumnE, ColumnF....

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @YEUNG_Gabriel
I assume that you use PowerApps since you are posting in the PowerApps forum. In that case, it will be quite simple to use a PowerApps action using something like SendMail() and Concat to concatentate the text into a single email.
Please let me know if this is not clear.

Was this reply helpful? Yes No
YEUNG_Gabriel 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

As mentioned, can you show me how to REMOVE the "Apply to each" as it just add this itself

And the resule is a VALUE of the TITLE and email individually all records so I recieved many emails of signle records....

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

OK, sorry. You are posting on the PowerApps forum, not the Flow forum.

Was this reply helpful? Yes No