How to convert Base64 Text in a SharePoint List

[G99]

Hi all, I have images (taken from the camera) from Power Apps and stored in a SharePoint Online list, as Base64 Text (in multiline text field).
The users would like to view/download these from SharePoint (they can view the image fine in Power Apps) and I am unsure how to achieve this.
It was suggested I would need a flow to convert this, but I am unsure how to do this.
Any help would be appreciated

[PrasadAthalye]

You can use Create file option and may be send it via email given in below thread...

https://powerusers.microsoft.com/t5/Building-Flows/Get-File-Content-as-Base64/td-p/73919

OR Save the file back to Document library and send a link to that doc library file..

Like and Mark this as answer if it resolves your issue

[G99]

HI @PrasadAthalye 

I've seen that post and attempted it prior to posting my question, for whatever reason it is not working for me, please see screenshot of my flow and then another screenshot of the error.

any ideas why its not working for me please?

[PrasadAthalye]

@G99 Can you directly use Create file to create JPG? In the filename give the name as .JPG and remove convert file action?

[G99]

@PrasadAthalye 

I've tried that and the step does not fail, but when I go to open the file created in OneDrive it states:

If i download it I get:

Suggesting to me the creating of the file isn't working correctly?

[PrasadAthalye]

@G99 - Can you check Base64 string if it mentions the file type? I think it might be .png OR .JPEG... Try one of these...

[G99]

Hi @PrasadAthalye 

I've checked the base64 string in PowerApps and it states:
data:image/png:base64,etcetc

What is you are suggesting I do?

[PrasadAthalye]

Please use .png as file extension and run flow and see if you can open generated file.

Please like and Mark this as answer if it resolves your issue.

[G99]

@PrasadAthalye 

This doesnt work either, i wouldnt have thought it would make a difference, but changing to .png results in the same error when i try opening the file... any other suggestions in getting this working?

[Jay-Encodian]

Hey @G99 @PrasadAthalye 

Check out this post- https://blog.encodian.com/2019/09/reduce-the-size-of-images-generated-by-powerapps-with-flow/

You don't need use the Encodian actions... but steps 4 to 8 explain what you need to do

HTH

Jay

[G99]

Hi I have managed to use Shane Youngs video to copy over the image to a SP doc lib:

https://www.youtube.com/watch?v=ovLIwnj6QjU

I just need to add another action, where the original SP list gets updated with the image location, something I am struggling with:

I am using update file properties action and in the expression:

concat('https://URL/Lists/ListName', outputs('Update_file_properties')?['body/{FullPath}'])

The error I have is:

Could not find list item.
clientRequestId: ID
serviceRequestId: ID

I presume this is because it does not know which item to update? Unsure how to tell it to update the current item?