I have applied the code on Screen.OnVisibile and now i have written the following code in my dropdown.items:
Distinct(Filter(datasource_temp,'Candidate Name'.DisplayName in ComboBox1.Selected.DisplayName, Date = DatePicker2_1.SelectedDate),'Project Name')
I simply just replaced my Sharepoint list from collection ,but still not working. Am i using correct query and database ?
I tried the below solution in my combo-box 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 ( Thanks @PaulD1 ), 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 help me with this.
Could you share a screenshot of your app showing what you are trying to achieve? I'm struggling to visualise you problem.
Also, what exactly is "... still not working"?
I continue with this problem, I managed to execute the code correctly, and I can collect lots without problems, the problem is that you cannot store in a "collection" (also try SET) an ID above the number 2000.
The intention of my code is to store a copy of a SharePoint list locally with 5,000 items, then work it locally and use SEARCH on a column.
Do you know if there is a new block?
It sounds like you want to collect all 5000 records from SharePoint to be able to use Search(). You are doing this because you do not want to use StartsWith as it is non-delegable with SharePoint.
There is a significant tradeoff here.
I recommend not using PowerApps as you would the back-end, but instead surfacing the minimum amount of data to act.
If you must use SharePoint for this scenario, you can to use StartsWith() for much better performance than collecting 5000 records. You can apply other filters ahead of the StartsWith() to pare it down even more. Another option is to use a SharePoint customized form: you have the full capabilities of SharePoint with the action taking you want to do in PowerApps.
(Side note: this thread is about CDM and filter and yours is about SP and Search. I'd suggest starting a new thread in the future so that your question appears at the top of its own and doesn't require context-switching)
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.