cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dettek
Frequent Visitor

Image column from my SharePoint list in PowerApp form?

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

18 REPLIES 18
DeeJaWuecom
Frequent Visitor

Okay, some new impessions:

DeeJaWuecom_0-1649846207828.png

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

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.

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
Frequent Visitor

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

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.

that works also for me!

 

Thank you!

 

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

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
Memorable Member
Memorable Member

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 ‌‌👍

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,523)