Skip to main content
Community site session details

Community site session details

Session Id : fqtUs9fSZo7fcHg4oJezY8
Power Apps - Building Power Apps
Unanswered

reading data from one list to populate another

Like (1) ShareShare
ReportReport
Posted on 9 Jul 2024 14:55:21 by

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?

  • drboltz Profile Picture
    on 10 Jul 2024 at 07:57:30
    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 Profile Picture
    44,965 Super User 2025 Season 2 on 09 Jul 2024 at 16:04:27
    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

  • Srini007 Profile Picture
    3,181 Super User 2025 Season 2 on 09 Jul 2024 at 15:57:09
    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

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete