Answered

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

(0) Share

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

All responses (2)

Answers (1)

PatrickMcLeanGL on at

Like (0)

Report

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

That worked, thank you.
Verified answer

ANB 7,075 Super User 2025 Season 1 on at

Like (0)

Report
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