Answered

Mutliple sharepoint lists to Collection and Back to Original Sharepoint list

(0) Share

Report

Posted on by Froesiie

I might be completely over thinking this but we have multiple SharePoint lists that we are using to keep track of different projects. I have combined them into a Power App collection as they all have the same fields. The thing I'm struggling with is sending the information the field technician submits back to it's original SharePoint.
The field techs could be working on multiple projects at once and I just want one app but when they submit I want to be able to patch the information back to it's original SharePoint list so it can update our data.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @Froesiie ,

I have one initial question, why have you got multiple SharePoint lists, when you could have one with a Project field?

Was this reply helpful? Yes No
Froesiie 17 on at

Like (0)

Report

@WarrenBelz
We would end up having THOUSANDS of items and I believe it would end up getting really messy if we did it that way.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @Froesiie ,

SharePoint will accept up to 30 million records and I have several with over 50,000. It will be even messier having to do a new list for each project as you cannot dynamically connect or refer to list names - it would all have to be hard-coded. As long as the Project name is stored in a Single Line of Text and it is indexed in SharePoint, queries to it are Delegable, so you should be able to display whatever project you want.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No