You’re offline. This is a read only version of the page.
Below code i wrote in function bar. Giving me error.
Requirement: Dropdown value should be blank first time.
Items = if(Dropdown1.SelectedText = "" , Table1 , Distinct(Table1,Location))
You cannot have your Default property determine what the Items property should be.
Your dropdown Items property should be: Distinct(Table1.Location)
Your Default property on the Dropdown should be : Blank()
Your AllowEmptySelection property on the dropdown should be true
I hope this is helpful for you.
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
Share
Report
All responses (
Answers (