Create Public Image URL

[MarCBB]

Hi there, 

I am fairly new to MSFlow, I create a flow that is triggered when a row in SQL is modified. 

part of the flow takes image text from power apps, converts and saved the image and then created a thumbnail, and then sends the URL of the thumbnail via email so that it can be viewed publically. My reason for using the thumbnail is that I needed a url that ended in .jpg because the data is also being used in Power BI. so the flow works perfectly, however, I have discovered that the thumbnail URLs expire and this is my problem. 

My goal is to create a public image URL (.jpg).

I have tried SharePoint but the URL that is generated is not .jpg it directs to a webpage with the image. 

Has anyone done something like this? what did you use to get the URL? 

[v-litu-msft]

Hi @MarCBB,

You can use the Get file properties or Get files properties action to get the properties of the image file. Then you can use the "Thumbnail" to get the URL of the picture.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-litu-msft · Accepted solution]

Hi @MarCBB,

Correct previous reply, use the Thumbnail Large, Medium, Small instead of Thumbnail.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MarCBB]

@v-litu-msft, Awesome, Thank you, that seems to work. I am assuming that these URLs will not expire?

[MarCBB]

@v-litu-msft , unfortunately, these thumbnail URLs also expire. 

[lionelp]

@v-litu-msft  @MarCBB 

I have the same concerns as you
Thumbnails expire, have you found a solution?
Thank you

[psureshkumar]

Hello @lionelp.,

I am also facing same issues. Did you get any solution for this?Please help me how to generate URL without access token. Because either I need image below 70 kb size or thumbnail image without access token to show in SSRS report.

Thanks,

Suresh.

[vizyonok]

@psureshkumar @MarCBB @lionelp guys, I've found a workaround!!! Finally!

Here is where I've found it - https://youtu.be/11qP2cx6PFo?t=511

The idea is to:

1. Get the thumbnail content (for example by using HTTP GET method)
2. Save it to file storage (for example Azure Blob or any other HTTP server where you can get a public link from, but it can't be Sharepoint storage as it uses Access Tokens)
3. Use that link in your message. It won't expire as long as the thumb file is being stored on your server.

It works for me.

However, I don't recommend using FTP protocol for uploading as it constantly corrupts the images.