Hi All,
I have an urgent requirement to complete below task,
In my app, i am using cascade drop down, textbox and combobox.
source & Datastoring in sharepoint and using gallery to view / edit existing entry and add new entry.
so previous / existing entry selection is working fine in drop down and textbox using this code "Thisitem.Task"
but in combo box default value is not coming properly also true false text box will perform based on combobox selection value so each time combobox is expecting to select values but i dont want to select for the existing entry.
Anyone help me to fix this problem.
ComboBox details:
Items : Distinct(AccountNameLookup,'Account Name')
Defaultselecteditems: ForAll(Filter(AccountNameLookup,
'Account Name'=ThisItem.ClientName
),
ThisItem.ClientName
)
Displayfields: ["Result"]
InputTextPlaceHolder: ThisItem.ClientName
SearchFields: ["Result"]
SelectMultiple : false
Default:
Based on this combobox selection , hidden truefalse textbox and onedropdown have to select appropriate value automatically but for the first time selection its working fine but for view / edit for the previous entry combo box .selected.result is empty.
Thanks in advance.
Sorry for the delayed reply.
I am using Gallery , inside i have 2combo box and few dropdowns and textboxes.
1. Gallery ITems : SharepointList
2. Distinct(AccountNameLookup,Title) - Items of Combobox
3. Sharepoint List
I still don't get it ... I need infos about:
1. Items property in Gallery;
2. Please provide formula for AcountNameLookUp ? Is a list ? Is a collection ?
3. How did you defined LookUp ? Is a list ? Is a collection ?
Thisitem.AccountName is showing error in default and defaultselecteditems
@gvrspk ,
It seems that is a problem with AccountNameLookup and LookUp(?!) collections (or data source).
Also ... from my undestanding the DefaultSelectedItems formula should easily be: ThisItem.AccountName.
Hi gabibalaban,
Thanks for quick response.
Attached screenshot for your reference.
based on combobox1 & 2 , dropdown will display automatically after saving values in sharepoint for the next edit its not picking but default selected values are displaying in combobox1 but i dont know how to set default values.
Hi @gvrspk ,
Please provide a screenshot with your configuration, i don't figure it out what are you doing there 😊
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1