How to get the url thumbnail from my library picture

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have a picture library with some fields.

I add a miniature column (I rename it to Formulaire droit à l'image)

When a user submit a new entry in the form, it send a adaptive card to my team.

How can i add a link to the miniature in my card ?

If i check my flow, i have nothing

All my miniatures are stored inside the attchmend respository and the link look like this

https://afpa365.sharepoint.com/sites/Photothque-test/SiteAssets/Forms/AllItems.aspx?viewid=589581c9%2D1c9f%2D4df6%2D8db5%2Dae52219c1b23&id=%2Fsites%2FPhotothque%2Dtest%2FSiteAssets%2FLists%2F6178406e%2Ddd9f%2D4ffa%2D8a88%2D7b99a77b21de/(link miniature)

How can i add these links to my adaptive card ?

thank you

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

PrasadAthalye on at

Like (2)

Report

If you export the view to excel, it will give you the path of the image... Please see the reference below...

Image is saved in Site Assets - Lists and a subfolder with List-Id.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It's interesting.
It there a way to add dynamically this link in my adaptive card?

Was this reply helpful? Yes No
PrasadAthalye on at

Like (1)

Report

Yes. This is going to be a longer process. This newly added Image property did not show up in getting Properties for files action. Please refer to the process below...

STEP 1: Use HTTP Action and query library with expand clause.

STEP 2: Run this much flow and capture the output and save it in notepad.

STEP 3: Add Parse JSON. Now use the above-generated output to generate Schema.

STEP 4: In the output, you will find your new column. Capture JSON generated. Mine looks like below.

{"type":"thumbnail","fileName":"PRFBaner.jpg","nativeFile":{},"fieldName":"Test","serverUrl":"https://XXXXXX.sharepoint.com","serverRelativeUrl":"/sites/PNP/SiteAssets/Lists/5e3d6008-ace7-4b8d-a677-6cade2b77b98/PRFBaner.jpg","id":"92c1dd68-62a2-48dc-9d7e-40a5ec3d8f87"}

So Add Parse JSON again to parse this one and then use ServerURL and ServerRelativeURL to form a final URL that you can use in your adaptive card.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

to delete

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Everything works until now but i don't have the server url content.
What i'm missing ?

My flow actually look like this

Was this reply helpful? Yes No
PrasadAthalye on at

Like (1)

Report

You can hardcode your server URL. That won't change... Replace XXXX with your tenant name

https://XXXXXX.sharepoint.com/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I don't understand my mistake.
I'm going to go crazy.
I always have this error

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['properties']?['d']?['properties']?['results']' is of type 'Null'. The result must be a valid array.

Why is it so hard to retrieve the url of a thumbnail ?
I hate picture library

Was this reply helpful? Yes No
PrasadAthalye on at

Like (1)

Report

A picture library is to store pictures. You have added another column to store images within it which is not a normal thing. It appears that Parse JSON failed to parse the output. Can you check the output of HTTP action if data is returned or not? Also did you use that output to generate Schema for parse JSON?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes, i know it's not a normal thing but the team needs that because they must attach the copyright of the picture.

This is the output of the send HTTP request. I upload a picture named 01.jpg and I attach OIP.jpg as copyright

And I see the attach file

So i copy all the output (from the beginning to the end) and i past it to generate the json schema.
Am i right ?

Was this reply helpful? Yes No
Verified answer

PrasadAthalye on at

Like (1)

Report

Yes. Parse that column using Parse JSON as I mentioned above and then concatenate ServerURL and ServerRelative URL

Was this reply helpful? Yes No