cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dga
Frequent Visitor

Trying to convert an excel (existing file) into a PDF file and then emailing a link to the file.

Hello Everyone,

 

I am fairly new to the Automate world, so far have been doing well but struggling with a flow.

 

Basically I have a form which asks users to enter details and then it updates an excel (timetable - for booking items out) and then it emails with a success message as well as link to the timetable. Now, I want to create a PDF file from the updated excel (timetable) for which a link will be emailed to the user as well as it will be visible to all on SharePoint if they want to see which items have been booked out. I don't want the excel timetable to be visible to users as otherwise (due to our organisation settings etc) it can be manually manipulated.

 

I am trying something of this sort (see below) but failing as the flow is unable to find the file. 

 

dga_2-1607349686430.png

In the Get File Properties, in ID field the following options are available.

 

dga_3-1607349760205.png

Hopefully someone can help me.

 

Thanks

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
dga
Frequent Visitor

Great Thanks for explaining to me, although I managed to workaround the problem with Get File Metadata, Get file properties etc.

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @dga :

Firstly let me explain why you encountered this problem.

The parameter "Id" of 'Get file properties' is the item id in the SharePoint library . It is just the number of the item in the SharePoint library, so neither the "When a new response is submitted" trigger or the Update a row action will return this value.

Secondly, If you want to get the item id of the specified file in the SharePoint library, there are two ways:

Solution1: Find the file id directly by modifying the view of the library

v-bofeng-msft_0-1607405590317.jpeg

 

v-bofeng-msft_1-1607405590317.jpeg

 

v-bofeng-msft_2-1607405590318.png

 

Solution2: Get item id by searching file name in flow

v-bofeng-msft_3-1607405590326.png

 

Best Regards,

Bof

dga
Frequent Visitor

Great Thanks for explaining to me, although I managed to workaround the problem with Get File Metadata, Get file properties etc.

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (26,741)