Get base64 from split string

(1) Share

Report

Posted on by TimmyBoy

997

Hello,

How can i get the image from this part?

Last(
 FirstN(
 Split(
 ThisItem.Result,
 ";"
 ),
 5 //this line contains the base64
 )
).Result

The image is a Base64 (red dot)

data&colon;image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P4 //8/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg==

I used the above code into a image field, but nothing happens?

Thank you

Categories:

Building Power Apps

All responses (11)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,730 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TimmyBoy ,

Try

Substitute( Index( Split( ThisItem.Result, ";" ), 5 ).Result, "&colon;", ":" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz
Weird, no image is loading...
I check the sharepoint list and image field is multi text and plain text...
WarrenBelz 156,730 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @TimmyBoy ,

Please see below

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz
I guess we are doing something completely wrong?
Still no image 😞

okay, i have added the plain code
But i had to change the &colon; with :
That works, but not into my split code 😞
WarrenBelz 156,730 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@TimmyBoy ,

The Substitute will work as well (it does what you have manually) - I think you need a bit of debugging here to work out what text your code outputs.
Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@TimmyBoy what @WarrenBelz mentioned in the post should work like a charm. Just substitute should work
TimmyBoy 997 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @WarrenBelz and @Bilakanti
Yeah i think @WarrenBelz has a point
I have to look into it, and i will be back soon 😉 i must be doing something wrong in my split code i guess 😞
Thank you
TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Weird, nothing helps...
Change the position, remove all other parts so i just keep the base64
But nope
Funny part is if i use your code
The image is loading without troubles...
I really don't get it where it will go wrong 😞
WarrenBelz 156,730 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@TimmyBoy ,

Have you put both pieces of code as the Default of a couple of Text Boxes, then copied both into Notepad and see if they line up ?
TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz
Ok i have cut them
but seems the image isn't working
even i must say the image don't convert correct
It only Shows data&colon
I think it's not working because i split the ;
and i see in the base64 it have also a ; here
image/png;
maybe that's why he cuts it, and never makes the image