Announcements
I'm trying to set a variable on the opening of a form, the data is coming from a selected gallery item, this what I'm trying;
Set(varDays,If(gallery1.Selected.Number_Days.Value="1",1,2);
I get a incompatible comparison error;
Hi @CiaranCampbell,
Is this Number_Days a Choice column allowing multi select or not?
If so, try modify as below:
Set(varDays,If("1" in Concat(gallery1.Selected.Number_Days.Value,Value,","),1,2))
Hi @v-qiaqi-msft
It was single select but it was selected as checkboxes in the SP list field settings, i changed it back to dropdown and its working fine now, thanks
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 325 Most Valuable Professional
11manish 165
MS.Ragavendar 88 Super User 2026 Season 1