Get File Content Using Path Failing

(0) Share

Report

Posted on by gcorprew

Hello,

I recently created a desk reservation app. When the user reserves a desk, Power Automate sends a confirmation email to the user, along with a map location of the reserved desk. Something has changed in the SharePoint site and now my Power Automate flow is failing at the base64 step, before the map is inserted into the email template. Attached is an image of the current base64 function.

This is the new output from the previous 'Get File Content Using Path' step:

{
"fileName": "Reserved_ImageAttachment_[12]_[DeskLocation][36]_[f8d7e86a-85bf-4073-8f7b-f5734fa6313a][1]_[1].png"
}

How can I extract the only the DeskLocation image from the output above and convert it to the base64 image?

Thanks for the help in advance

Base64.PNG

All responses (1)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report
Re: Get File Content Using Path Failing

Hi , @gcorprew
According to your description, you want to get the image in SharePoint List. And you have got the fileName in your side .
This is my SharePoint List image Column "ImageTest":
First we can get the fileName using this http request:
Then we can get the file content:

json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['ImageTest'])?['fileName']

Then we can embed with <img> tag :

base64(outputs('Get_file_content_using_path')?['body'])

For more information, you can refer to :
Get SharePoint List Image in Power Automate - Torben Pedersen

If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,
Yueyun Zhang