web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapps and Sharepoi...
Power Apps
Unanswered

Powerapps and Sharepoint Limitations

(0) ShareShare
ReportReport
Posted on by 232

As I think many community members would have found, the precise way to get images into a Sharepoint list item using the available image controls in PowerApps can be a bit tricky and messy.

 

I'm currently using a Flow method to upload images to a Sharepoint List item into the attachment column, and I have 10 separate image controls in my app, for a potential 10 images per list item.

 

But a flow, of course, can fail on occasion, and this messes with the renaming and ordering of images in a given list item.

 

So instead what I want to do now is grab the base64 encoding of an image from an image control (Image 001 image control), and submit that to a corresponding multi line column in Sharepoint (Image 001 column).

 

Each of my list item averages 1 to 2 images, but they can have up to 10 images in some cases.

Each image is a jpg roughly 2-5mb in size (so the base64 string is significant).

 

This is working brilliantly in initial tests, but I've got some concerns about the sheer amount of data in the form of characters I'm plugging into a Sharepoint column. I already need to hide the columns from view in Sharepoint in order for the browser to load the list.

 

I don't want to build this thing, have it work for a month, and then have it completely melt down.

 

For reference, he's what the list looks like:

cfebvre_0-1593560813083.png

 

Can anyone give me some rough guidance on this, based on their experience?

Would I be creating data-zilla?

 

Cheers in advance.

 

Categories:
I have the same question (0)
  • leyburn19 Profile Picture
    2,157 on at

    I do know that a SP list will hold 33million records.  Not really knowing teh construct of SP lists,  I am aware that a multi line list may be the same as a Memo field used in other databases,.  In other databases these are containers that are linked to the a table.  rather than an actual field.  In so doing memory is handled more fluently.  SP might use the same approach,  which should mean low issues are presented

  • cfebvre Profile Picture
    232 on at

    @leyburn19 Yeah thanks leyburn19.

     

    I think I might simply be in a position where I need to stress test the hell out of it before I go live. It's working great right now, and I'm really happy with it, so I'm hoping I can stick with it.

  • KrishnaV Profile Picture
    5,023 on at

    Hi @cfebvre ,

     

    What you will be doing with the attachments? I mean how the user will access the attachments? through PowerApp or through the backend SharePoint list? 

     

    Option 1: Accessing through PowerApps

    Create a document library and upload the attachments to document library and add all the document library URL of the attachments in a comma-separated fashion to the parent list on a multiline text column

    In powerApp while reading showing the item render the multiline column and show them in the screen as an icon with link to the document.

     

    Option 2: User Accessing through SharePoint list

    In this approach, users will see multiple links on the list item and they can click on the individual items as per the user interest.

     

    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Regards,
    Krishna
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

  • cfebvre Profile Picture
    232 on at

    @KrishnaV Hi KrishnaV, thanks for the reply, but that's not really what I'm trying to accomplish.

     

    Basically I'm asking whether I will crash my Sharepoint list if my Powerapp submits the base64 encoded string of up to 10 images (2-5mb each) to 10 corresponding multi line columns in the SharePoint data source.

     

    My users would be selecting their own images for the list item they are creating (always new and unique images). I have around 20 users submitting entries, and we create roughly 150 - 200 entries per week.

  • KrishnaV Profile Picture
    5,023 on at

    Hi @cfebvre ,

     

    Here are the limitations:

    Single line of text: 276

    Multiple Lines of Text: 192

    Choice: 276

    Number: 72

    Currency: 72

    Date and Time: 48

    Lookup: 96

    Yes / No: 96

    Person or group: 96

    Hyperlink or picture: 138

    Calculated: 48

    GUID: 6

    Int: 96

    Managed metadata: 94

     

    Items limit in SPO is 30 million:

    https://docs.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits#:~:text=Items%20in%20lists%20and%20libraries,list%2C%20library%2C%20or%20folder.

     


    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Regards,
    Krishna
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 834

#2
Valantis Profile Picture

Valantis 533

#3
Haque Profile Picture

Haque 410

Last 30 days Overall leaderboard