web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Placing multiple files...

Power Automate

Unanswered

Placing multiple files links in email body

(0) Share

Report

Report

Posted on by Tetris

72

Hi,

I'm trying to create an email with a series of links to files from a SharePoint library, like so:

RCP fixes _ Fitting Rooms1_SM1.jpg

Powerapps provides the file IDs and Get file properties the links. How do I add the links to the email body?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

v-yueyun-msft on at

Like (0)

Report
Hi , @Salv
According to your description, you want to pass the ID to the flow and send the links of the files to the email.
This is my Ids pass to flow in Power Apps:
[{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":9},{"ID":12},{"ID":15},{"ID":16}]
I use the Json() funtion to convert the Ids to the string to pass to the flow:
This is my flow:
(1)The trigger and the initial variable action:
(2)The Apply to each action:
json(triggerBody()['text'])
int(item()?['ID'])

(3)The Last two actions:
item()?['fileName']
concat('<a href="',item()?['Link'],'" >',item()?['Link'],'</a>')
replace(replace(replace(body('Create_HTML_table'),'<','<') , '>','>'),'"','"')

The result is as follows:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Verified answer

Tetris 72 on at

Like (0)

Report

Thank you @v-yueyun-msft . Great suggestion on the Append to array variable! I used it but I think I came up with a simpler solution (I am a beginner, so I used the actions are familiar with). Thank you for your help!

Was this reply helpful? Yes No

Join the conversation