Unanswered

reading data from one list to populate another

(1) Share

Report

Posted on by drboltz

I'm struggling somewhat with a routine to back populate, on a periodic basis, a sharepoint list with data from a lookup on another list

LIST1 has the following fields

UserName UserID UserLocation etc

LIST2 has a various fields but it includes

UserID UserLocation etc

I need to be able to run a routine that if in LIST1 USERLocation field is empty, it will lookup UserLocation based on the matching UserID from LIST2 and patchthe UserLocation to that LIST1 relevant list entry

The list in question is 10000 plus lines long so i come up against collection limits as well.

Is anyone able to suggest a "one off" solution, inside or outside power apps or ideally a push a button based solution for powerapps please?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Srini007 3,483 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @drboltz

Check below link for your reference

https://powerusers.microsoft.com/t5/Building-Power-Apps/data-over-500-rows-and-show-in-gallery/td-p/703970

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Cheers,

Srini

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @drboltz

I would use a flow for this. While you can "force" it to work in a Canvas App, its not how you should do it.

By the way is it Actually a lookup to List 2 like a lookup column, or a test field?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
drboltz on at

Like (1)

Report
Copy link

Link copied!

Each list is independant, the list format for the columns are, in this case, single line text items - no actual lookups involved sharepoint list wise.

Was this reply helpful? Yes No