How to get the url thumbnail from my library picture

[Anonymous]

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%...

How can i add these links to my adaptive card ?

thank you

[PrasadAthalye]

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.

[Anonymous]

It's interesting. 

It there a way to add dynamically this link in my adaptive card?

[PrasadAthalye]

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-a..."}

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.

[Anonymous]

to delete

[Anonymous]

Everything works until now but i don't have the server url content.

What i'm missing ?

My flow actually look like this

[PrasadAthalye]

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

https://XXXXXX.sharepoint.com/

[Anonymous]

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

[PrasadAthalye]

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?

[Anonymous]

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 ?

[PrasadAthalye · Accepted solution]

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

[Anonymous]

Thank you.

I think i'm progressing.

I copy and paste this code. 

I used https://codebeautify.org/json-escape-unescape.

The output was : 

----------------------------------------

{\"type\":\"thumbnail\",\"fileName\":\"yammer-e1575278735551.png\",\"nativeFile\":{},\"fieldName\":\"Formulaire_x0020_droit_x0020__x00e0__x0020_l_x0027_image\",\"serverUrl\":\"https://afpa365.sharepoint.com\",\"serverRelativeUrl\":\"/sites/Photothque-test/SiteAssets/Lists/617..."}

-------------------------

and now

-------------------

{"type":"thumbnail","fileName":"yammer-e1575278735551.png","nativeFile":{},"fieldName":"Formulaire_x0020_droit_x0020__x00e0__x0020_l_x0027_image","serverUrl":"https://afpa365.sharepoint.com","serverRelativeUrl":"/sites/Photothque-test/SiteAssets/Lists/6178406..."}

---------------------------------

I now have serverul in dynamic fields

My flow looks like this now

and i add the output from compose in the adaptive card

but i have still have the error 

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

I don't know why 😞

[Anonymous]

Finally it's working.

I had an error in the copy/paste from the first Json step.

Thank very much for your support.

I learnt a lot