web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to bind two or mor...
Power Apps
Answered

How to bind two or more lists in SharePoint

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello everyone,

 

I have a question about SharePoint. 

Is it possible to bind two or more lists in SharePoint and use them together?

For example I have two lists in SharePoint and first list has information about persons and second list has goals which have to be done.

And now I can see a person on the first list and I can choose a goal from another goal's list for this person, what have to be completed. 

Could someone tell me whether it is possible?

 

Regards 

Categories:
I have the same question (0)
  • JR-BejeweledOne Profile Picture
    5,836 Moderator on at

    Yes you can do it.   What do you want it to look like?   There are a number of options.

     

    Do you want to work with a single person at a time or do you want to have a 'list' of persons and select the one you want to work with?  

     

    Will the selected goals be saved back to the list that has the persons information?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you for your answer, 

     

    I want to see it works: I choose one person and I can add to this person some tasks (for example for one week), this tasks should be saved on the persons list. And all tasks which have to be done, they are on another list in SharePoint.

  • Verified answer
    JR-BejeweledOne Profile Picture
    5,836 Moderator on at

    Here is what I would do.

     

    In your OnApp Start, create 2 collections, 1 from the Person information list and one from the task list.

     

    Have 2 galleries.

     

    In the first gallery Items property put your Person Information Collection.   In the second gallery put your tasks collection.    I don't know if there are different tasks for each user, so you might have to filter the tasks to only show the ones that apply to the specific user.

     

    In Gallery 1, set the OnSelect property of your icon to Set(varRecord, ThisItem).    This is going to give us some information to use when the tasks are saved.

     

    Set the Second Gallery to the Title layout.   Add a checkbox input and delete the other label.   Select the Checkbox control and set it's items to the column that contains the task name.

     

    This would look something like this:

     

    Checkboxtext.png

     

    In the image below #1 shows what it would look like when applying the formula shown above to the Text property of the checkbox.    You can delete the 2nd gallery arrow icon shown at number #2,

     

    Gallery 2 ExampleGallery 2 Example

     

    If necessary in your Gallery 2 Items filter so only tasks that apply to the selected person show up. 

     

    In your gallery 2 in the OnCheck property of the checkbox set a formula like this:

     

    Collect(CollectionName, ThisItem)

     

    In the OnUncheck Property set this:

     

    Remove(CollectionName, ThisItem)

     

    When you are finished, in your save button/icon in the OnSelect, you will add this information to the person list.

     

    I don't know what type of column you have that will hold the tasks, but if you are going to use a single line of text field you would do something like this:

     

    UpdateIf(

        PersonListDataSource, varRecordID = ID,

        {

           TaskColumn: Match(Concat(CollectionName, ColumnName & ", "),"^(?<trim>.*), $").trim

     

      }

     

    )

     

     

     

     

     

     

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you @JR-BejeweledOne , 

     

    I will try it in the next days and give you feedback, whether it works.😁

     

    Reagards

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 404

#2
timl Profile Picture

timl 344 Super User 2026 Season 1

#3
WarrenBelz Profile Picture

WarrenBelz 320 Most Valuable Professional

Last 30 days Overall leaderboard