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?

All responses (3)

Answers (0)

drboltz on at

Like (1)

Report

Re: reading data from one list to populate another

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.
Michael E. Gernaey 40,272 Super User 2025 Season 1 on at

Like (1)

Report

Re: reading data from one list to populate another

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
SriniK 3,025 Super User 2025 Season 1 on at

Like (1)

Report

Re: reading data from one list to populate another

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