I have added the below code in my combo-box items and defaultselecteditems as follows :-
SortByColumns(ShowColumns(FirstN(Search(Filter(VendorsV2_3,TextInput1.Text in 'Search name'), TextInput1.Text, "VendorSearchName"),50),"VendorSearchName"),"VendorSearchName",Ascending)
This works perfectly fine, if i put a text-box above the combo-box and search in the text-box and corresponding value gets filtered in the combo-box.
But when i replace the TextInput1.Text to Combobox1.SearchText, nothing happens.
Can anyone please help me with this.
Solved! Go to Solution.
Distinct(Sort(FirstN( Search(Filter(VendorsV2_3,StartsWith(Name,ComboBox3.SearchText) || StartsWith(description,ComboBox3.SearchText)),ComboBox3.SearchText,VendorOrganizationName),50),VendorOrganizationName,Ascending),VendorOrganizationName).Result
Hey @cyberco01
SortByColumns(ShowColumns(FirstN(Search(Filter(VendorsV2_3,StartsWith('Search name',Combobox1.SearchText)), Combobox1.SearchText, "VendorSearchName"),50),"VendorSearchName"),"VendorSearchName",Ascending)
It is giving me error - StartsWith has an invalid argument. Kindly help.
Also, it is giving me the large dataset warning.
Please check below my exact issue with the first combo box on screen.
I have shared the video of my exact issue. Please do let me know if you are able to see.
I removed the code from defaultselecteditems field and now I am able to search the vendors.
But, now the saving is not happening. As in I select a vendor and save the item and then open for edit but unable to see it.
Currently, code in my items property is
SortByColumns(ShowColumns(FirstN(Search(Filter(VendorsV2_3,ComboBox2.SearchText in 'Search name'), ComboBox2.SearchText, "VendorSearchName"),50),"VendorSearchName"),"VendorSearchName",Ascending)
Dearies,
Kindly help me with this issue as the value i save is not reflected in combo-box in edit mode.
Update property of datacard: ComboBox3.Selected.Result
Items Property: Distinct(SortByColumns(ShowColumns(FirstN(Search(Filter(VendorsV2_3,ComboBox3.SearchText in 'Name or description'), ComboBox3.SearchText, "VendorOrganizationName"),50),"VendorOrganizationName"),"VendorOrganizationName",Ascending),VendorOrganizationName).Result
Distinct(Sort(FirstN( Search(Filter(VendorsV2_3,StartsWith(Name,ComboBox3.SearchText) || StartsWith(description,ComboBox3.SearchText)),ComboBox3.SearchText,VendorOrganizationName),50),VendorOrganizationName,Ascending),VendorOrganizationName).Result
User | Count |
---|---|
262 | |
110 | |
92 | |
55 | |
41 |