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'".
That worked, thank you.
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
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1