Unanswered

Create a file from a SharePoint item.

Like (0) Share

Report

Posted on 12 Mar 2021 14:15:30 by deanking

Hi Everyone. I'm wanting to create a file from a SharePoint item that is then saved to a folder on SharePoint and then emailed to a user. I've followed a YouTube video that suggests using the 'Select' block and choosing the 'Value' of the SharePoint Item to then create a HTML table, to then be saved, then converted to a PDF, then emailed.

I'm using the ID of the item as the input of the Select as I can find anywhere that says Value but to be fair the YouTube video looks like it's using older connectors so maybe these have been updated?

All responses (6)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on 15 Mar 2021 at 17:00:44

Like (0)

Report
Re: Create a file from a SharePoint item.

@deanking , you can configure the actions as shown in below steps:

1. Use Get Item to get item properties and create document content as shown below using compose action. Also name the actions as per the screenshot

content for compose action

Title: @{outputs('Get_item')?['body/Title']} <br /> Status: @{outputs('Get_item')?['body/Status']} <br /> ID: @{outputs('Get_item')?['body/ID']}

2. Add another compose action and configure following content in the compose action

<!DOCTYPE html> <html> <head> </head> <body> @{outputs('Compose_-_Document_Content')} </body> </html>

3. Now add Create File (onedrive) action and configure it as follows, (you can use any filename here)

4. Add "Convert file using path" and configure it as follows (Use path parameter from dynamic content of Create File)

5. Then in Send Email action configure the file attachment of PDF file as shown in below screenshot
JisungHan on 15 Mar 2021 at 09:18:49

Like (0)

Report

Re: Create a file from a SharePoint item.

Hi @deanking ,

If you get the record values then you may create HTML and convert it to PDF.

I think it would be better to specify your block point and let us provide a solution/advice. Would you please share a screenshot you want to solve?
deanking 39 on 12 Mar 2021 at 15:46:18

Like (0)

Report

Re: Create a file from a SharePoint item.

Yeah.

Ideally I want all of the columns of the item to be listed on a document like below:

Learner Name: [Learner Name from item]
Employer: [Employer from item]
Test: [Test from item]
Date: [Date value from item]
annajhaveri 8,531 Most Valuable Professional on 12 Mar 2021 at 15:40:02

Like (0)

Report

Re: Create a file from a SharePoint item.

@deanking so you want to get values of all columns of that specific item and create a PDF document of those values?
deanking 39 on 12 Mar 2021 at 15:17:40

Like (0)

Report

Re: Create a file from a SharePoint item.

Hi.

Thanks for the response. I'm using the 'For a Selected Item' and then 'Get Item'.
annajhaveri 8,531 Most Valuable Professional on 12 Mar 2021 at 15:14:28

Like (0)

Report

Re: Create a file from a SharePoint item.

@deanking how are you getting the SharePoint items in flow? Are you using Get Items action?