Image column from my SharePoint list in PowerApp form?

[dettek]

Hi there.

I'm trying to create a power app form where end users can input images (which eventually goes through some flows to display in a paginated report). I'm struggling with the use of the "Image" column in sharepoint. When I add the column in Sharepoint it doesn't show up as an available field in PowerApps for me to add into my form. I've searched online but couldn't find a usable solution. Does anyone have any pointers? Appreciate any help!

Thanks

[DeeJaWuecom]

Okay, some new impessions:

The Image control field thinks, that the image is a "Text" Datatype.

Any Ideas?

Update: Now, also the Test App doesn't work anymore...

So i think, Microsofts release last month is a bit buggy...

[AndreasTh]

Where you able to solve this problem in your app?

I'm currently having the same problem that images are not shown in an app using environment variables for the connection but work totally fine in an app directly connecting to the SharePoint List.

[AndreasTh]

I just found myself a workaround. Changing the output of the Image column the following way leads to a working result:

"https" &
Substitute(
    Substitute(
        Substitute(
            Substitute(
                Substitute(
                    Last(
                        Split(
                            ThisItem.Image.Full,
                            "https"
                        )
                    ).Result,
                    "%25253a",
                    ":"
                ),
                "%2F",
                "/"
            ),
            "%25252f",
            "/"
        ),
        "%3F",
        "?"
    ),
    "%21",
    "!"
)

[dettek · Accepted solution]

Latest Microsoft update
https://powerapps.microsoft.com/en-us/blog/power-apps-supports-the-new-sharepoint-list-image-column-... 

[AndreasTh]

I read that but they are not stating anything about the fact that it doesn't work when using environment variables.

[DeeJaWuecom]

Hello Andreas,

no it doesn't work.

Sometimes it works even with environment variables, but it's a bit randomly.

Now we had a call with Microsoft, it seems that some existing canvas apps are faulty, new apps hasn't problems.

Microsoft want to fix that problem.

[DeeJaWuecom]

that works also for me!

Thank you!

I will send this Solution to Microsoft, to fix the problem of the URL.

[DeeJaWuecom]

Hello @AndreasTh  ,

your Workaround works perfect within the Webbrowser, but on android it doesn't work.

How did you figure out that the URL needs to be changed this way?

Do have an Idea, how it will works for Powerapps on android?

[ganeshsanap]

SharePoint/Microsoft Lists image columns now also supports adding/updating images from Power apps and Power automate:

1. Add, update, or delete images in SharePoint/Microsoft Lists using Power Apps 
2. Add an image to SharePoint Image columns using Power Automate 

---

Please click Accept as solution & 👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍