web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to Populate Form w...

Power Apps

Answered

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

(0) Share

Report

Report

Posted on by PatrickMcLeanGL

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'".

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
PatrickMcLeanGL on at

Like
a
(0)

Report
Copy link

Link copied!

That worked, thank you.

Was this reply helpful? Yes No

Join the conversation