
Announcements
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
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