Sharepoint List Items Image to PDF

[reyaldi7]

Hi all,
Is there any way to create pdf file from images in SharePoint list? 
I have SharePoint list for expense report, and there's one column that contains images of receipt for each expense.
In another column, there are ref ID, which will be the query to be filtered.
For example, there are 3 items list with ID 234. I want the receipt images from these 3 lines become one pdf file.

If you know the way to do it or any reference, I could see please let me know. I'm new in power automate, so please help me with step-by-step guidance.

Thank you so much!

[v-dezhili-msft · Accepted solution]

Hi @reyaldi7 ,

Are your images stored in an image column in a SharePoint list?
You can try to put the picture into an html file, and then convert this HTML file to a PDF file.

_api/Web/Lists/getByTitle('listG')/items?$filter=ID eq @{items('Apply_to_each_3')?['ID']}&$select=Img

concat(json(item()?['Img'])?['serverUrl'],json(item()?['Img'])?['serverRelativeUrl'])

<img src=@{dataUri(outputs('Get_file_content_using_path')?['body'])}></br>

Best Regards,

Dezhi

[reyaldi7]

Hi @v-dezhili-msft 

thank you for the response. I've just finished creating the flow as your instruction, but I'm facing some problems here. Please take a look for the error and the flow I build.

my sharepoint list name is 'Expense Report Detail'
and please take a note that i'm using filter with colum 'Ref ID' in my 'Get items' please inform me if it can cause any failure.

where do you think is wrong with my adjusted api code? please let me know. I'm so close with this problem
thank you

[v-dezhili-msft]

Hi @reyaldi7 ,

You need to replace all Img with your column names.

Best Regards,

Dezhi

[reyaldi7]

Hi @v-dezhili-msft ,

I've replaced all Img with my column that have image name, but still same error.
Maybe because my list name has space inside? could you please correct my input?

_api/Web/Lists/getByTitle('Expense_Report_Detail')/items?$filter=ID eq @{items('Apply_to_each_3')?['ID']}&$select=Receipt

thank you ins advance

best regards,

Reyaldi

[reyaldi7]

Hi @v-dezhili-msft ,
Yes it works!!

thank you so much for the guide!
God bless you

[reyaldi7]

Hi @v-dezhili-msft ,
I have a problem with the flow you suggested.
The SharePoint list I made by me; thus, it's stored in my OneDrive. 
I've also set it up to public so everyone can access the list (and yes, they can access)
but when they try to run the flow themself, the flow failed to run.

is it because of the permission in OneDrive where the list image is stored? could you please help me solve this?

Note: if i run the flow, the flow runs well