Unanswered

Patch to sharepoint, replace image with blank

(1) Share

Report

Posted on by Matt383

407

Just trying to swap out signature with blank image if no signature is found. Can this be done in the patch section like below? (Image10 is the image i am trying to replace it with.

Patch(Malcolm, Defaults(Malcolm),{Signature1: If (IsBlank(CollectGallery.Selected.Signature2, CollectGallery.Selected.Image10});

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (0)

Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Hi Jeffer, I added a label in the gallery CollectGallery.Selected.Image10 and the result ends in the same string i am referencing to in the patch button. (ending in kjggg==)

Signature1: If(
EndsWith(
CollectGallery.Selected.Signature1,
"cBBgAWRAABGi1TOgAAAABJRU5ErkJggg=="
),
CollectGallery.Selected.Image10,
CollectGallery.Selected.Signature1

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Copy link

Link copied!

Hi @Matt383 ,

Please add another Image control in the Gallery and bond it to Image10 and see the result.

Best regards,

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Hi Jeffer, I have referenced the string to point to the blank image (Image10) and can see Image10 with the string ending in ggg== showing in the sharepoint entry, however the pdf from the flow still shows as X or broken link

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Copy link

Link copied!

Hi @Matt383 ,

You've made it correct to use JSON string of blank image. Using Image 10 value in Compose operation was just to check if it could be used for the availability. It's not necessary now.

Best regards,

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!
Hi Jeffer, Yes test with two blank signatures. There is an Image10 column in the sharepoint list. I changed the syntax to
EndsWith( CollectGallery.Selected.Signature2, "ABAgQIPNd0AlfRZdoTAAAAAElFTkSuQmCC"
In powerapps patch.
which is the json string for the blank signature2. Is that right, or should it be the json string for Image10? In what way would you use the Image10 value in the Compose operation?

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Hi Jeffer,

I had a look and blank signature ends in MBY4eISIECAAAECBAxAP0CAAAECBAgQiAkYgLHCxSVAgAABAgQIPNd0AlfRZdoTAAAAAElFTkSuQmCC
I changed the formula to this string but still same results 😕
EndsWith(
CollectGallery.Selected.Signature1,
"MBY4eISIECAAAECBAxAP0CAAAECBAgQiAkYgLHCxSVAgAABAgQIPNd0AlfRZdoTAAAAAElFTkSuQmCC"
),
CollectGallery.Selected.Image10,
CollectGallery.Selected.Signature1), Signature2: If(
EndsWith(
CollectGallery.Selected.Signature2,
"MBY4eISIECAAAECBAxAP0CAAAECBAgQiAkYgLHCxSVAgAABAgQIPNd0AlfRZdoTAAAAAElFTkSuQmCC"
),
CollectGallery.Selected.Image10,
CollectGallery.Selected.Signature2
)});

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Copy link

Link copied!
Hi @Matt383 ,

Even if there is no signature in the Pen Input control, there should be JSON string for the blank image in the collection, and it should be end with the part from my previous post:

My formula was to check the end part of the JSON strings from the two signatures to replace any signature with the JSON of image 10

Patch( Malcolm, Defaults(Malcolm), { Signature1: If( EndsWith( CollectGallery.Selected.Signature1, "MgQOABYzEA52Z8YEEAAAAASUVORK5CYII=" ), CollectGallery.Selected.Image10, CollectGallery.Selected.Signature1 ), Signature2: If( EndsWith( CollectGallery.Selected.Signature2, "MgQOABYzEA52Z8YEEAAAAASUVORK5CYII=" ), CollectGallery.Selected.Image10, CollectGallery.Selected.Signature2 ), Image10: CollectGallery.Selected.Image10 } ); SaveData(KBLMalcolm."MalcolmKeep")

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Hi Jeffer, where do i find the json string for the signatures? If no signature is entered, there is nothing in the collection under signature1. The image10 (blank image replacement) Is what i provided in previous post.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Copy link

Link copied!

Hi @Matt383 ,

Sorry my bad. I need to check if the JSON string of the two blank signatures are end with "MgQOABYzEA52Z8YEEAAAAASUVORK5CYII=" in the collection "KBLMalcolm"

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

This is how image10 is displayed in sharepoint data&colon;image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAEsAAABLCAMAAAAPkIrYAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyBpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNSBXaW5kb3dzIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFGMzc2MkFDMThDRjExRUJBNDVBREY4MTg0QjgzMkMyIiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFGMzc2MkFEMThDRjExRUJBNDVBREY4MTg0QjgzMkMyIj4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUYzNzYyQUExOENGMTFFQkE0NUFERjgxODRCODMyQzIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUYzNzYyQUIxOENGMTFFQkE0NUFERjgxODRCODMyQzIiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz6RoGuZAAAABlBMVEX///8AAABVwtN+AAAAH0lEQVR42uzBgQAAAADDoPlTX+AIVQEAAAAAwDcBBgAWRAABGi1TOgAAAABJRU5ErkJggg==

Was this reply helpful? Yes No