Handling a large SharePoint List in PowerApps

(0) Share

Report

Posted on by Ann_DAS

115

Good afternoon,

I am building my first canvas app from a large SharePoint list and I could really use some help. The list is for toolbox distribution - there are a set of tools, a set of checks to verify that each tool is in the box and that it was delivered to the employee and a text field to record the serial number. All told there are over 100 columns in the list. Output looks something like this:

It makes for a very long list in SharePoint as there are about 60 tools (columns), each has to be identified as Delivered and Present and each has its own serial number (column).It's bulky in SharePoint but downright scary in PowerApps when I attempt to create a canvas app especially since I am a beginner.

Has anyone ever dealt with such a large list? As it is now, the Edit screen is do-able though it requires a lot of scrolling. Does anyone have any suggestions on how to deal with this in PowerApps?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,924 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Ann_DAS ,

If you want to make this scalable, I believe you need to forget the Excel-type structure you have now and re-think your data structure with three lists

One for all employees and any details relating to them

One for all the tools

One replacing what you have now with a record for each employee/tool combination

Yes - it will be a lot of records, but if you stay with Text columns, queries should be mostly Delegable. You can select employees or tools for new records from drop-downs drawing from the first two lists and adding an employee or tool is simple.

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

Was this reply helpful? Yes No
Ann_DAS 115 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the help. I've already broken this down to 7 lists - most cover what you mentioned. However the manager wants a list recording the employee, each tool issued to them, a set of checklists to identify that the tool was a) delivered to them and b) present in the toolbox and the serial number of each tool. I've broken it down to three lists - one for each toolbox type, but the remaining information still makes for a very large list.

Was this reply helpful? Yes No