cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALP1
Resolver I
Resolver I

How to get the url thumbnail from my library picture

Hi,

I have a picture library with some fields.

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

 

ALP1_0-1612968678231.png

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 ? 

 

ALP1_1-1612968807947.png

 

If i check my flow, i have nothing

 

ALP1_2-1612969149621.png

 

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

 

 

 

 
 
 
 
 
 
 
 
 
 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions

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

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

12 REPLIES 12
PrasadAthalye
Super User
Super User

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.

 

PrasadAthalye_0-1613004950453.png

PrasadAthalye_1-1613005050506.png

 

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
ALP1
Resolver I
Resolver I

It's interesting. 

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

 

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.

PrasadAthalye_0-1613061045183.png

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.

 

PrasadAthalye_3-1613061167459.png

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.

PrasadAthalye_4-1613061335698.png

 

 

 

 

 

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
ALP1
Resolver I
Resolver I

to delete

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

What i'm missing ?

 

ALP1_0-1613084770838.png

 

My flow actually look like this

 

ALP1_2-1613085668275.pngALP1_3-1613085708771.png

 

 

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

 

https://XXXXXX.sharepoint.com/

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

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.

 

ALP1_0-1613123783046.png

 

 

ALP1_1-1613123886636.png

 

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

 

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?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
ALP1
Resolver I
Resolver I

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

 

ALP1_1-1613391931939.png

 

And I see the attach file 

ALP1_2-1613392031892.png

 

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

Am i right ?

 

 

 

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

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

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

 

server url.png

 

My flow looks like this now

 

parse2.png

 

and i add the output from compose in the adaptive card

 

outputs.png

 

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 😞

 

error .png

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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

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 (35,051)