Skip to main content
Community site session details

Community site session details

Session Id : YEDBSd1PavkghP/tukcVQk
Power Apps - Building Power Apps
Answered

How to Populate Form with Datasource SharePoint List from a ComboBox with Distinct Values?

Like (0) ShareShare
ReportReport
Posted on 21 Mar 2024 16:46:56 by

I have a combo box and a form, both linked to the same Datasource (A SharePoint List). However, my combo box is set to Distinct('SharePointList', Name) so that I am not seeing duplicate name values (I'm working on a visitor sign in, this is for returning visitors).

 

When I set my form items to ComboBox.Selected, I get the error "Invalid Formula. Expected a value compatible with 'DataSource'".

  • PatrickMcLeanGL Profile Picture
    on 21 Mar 2024 at 19:09:18
    Re: How to Populate Form with Datasource SharePoint List from a ComboBox with Distinct Values?

    That worked, thank you.

  • Verified answer
    ANB Profile Picture
    7,128 Super User 2025 Season 1 on 21 Mar 2024 at 17:31:21
    Re: How to Populate Form with Datasource SharePoint List from a ComboBox with Distinct Values?

    Hi @PatrickMcLeanGL , Can use below code on Item property of Form:

    LookUp('SharePointList', Title = ComboBox.Selected.Value)

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

    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

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 1