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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / 2 data sources - 1 form
Power Apps
Unanswered

2 data sources - 1 form

(0) ShareShare
ReportReport
Posted on by 438

Hi guys 

I have had complaints that some of the apps are too much work, so I am creating a 'lite' version to be used on the fly and I have a form which populates a sharepoint list. I have 2 fields (Manager and Authoriser) which are names of people. Originally I would have a combobox for a Person/Group column. This however would return too many values because of the amount of employees we have. I decided to create a sharepoint list with the Team members, therefore 30 people not 30 thousand. I want to use two combo boxes in the same form which take the values from the Team members sharepoint list.

nshaw75_0-1719414727201.png

I am stuck as to integrate this. To be honest after a few lame attempts I have no idea where to start as you can see both boxes have errors 😞

 

Categories:
I have the same question (0)
  • ANB Profile Picture
    7,223 Super User 2025 Season 2 on at
    Re: 2 data sources - 1 form

    HI @nshaw75 , In the SharePoint List Team members , what is type of column you are using to store value of user? If it is Single Line text then the code for Items property of combo box will be

    'Team Members'

    Considering that the exact name of list is 'Team Members' and then layout of combo box will be this:

    ANB_0-1719429617200.png

    Considering that the user name is stored in Name column of 'Team Members' list.

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    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.👍

    Thanks,
    ANB


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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 836 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 231 Super User 2025 Season 2

Last 30 days Overall leaderboard