Announcements
hello, I have an excel file of 250 records, I would like to put a filter on several columns but I cannot find the right syntaxthe first filter carries the "Chauffeur" column
thanks in advance
Hi @Vincent_72 ,
You can try below code if it helps.
Filter (Saisies_courses; StartsWith(Chauffeur,TextInput2.Text))
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
thank you, but that doesn't change a thing
Could you please confirm the column type ?
Is it by any chances choice field ?
Chauffeur
in the excel table, no it is a free text field; on the other hand if I connect the table with share point, under sharepoint, yes it is a choice field
Basically the excel file is a degraded solution, I wanted to manage everything from share point
IF you have sharepoint data connected to your Powerapps please try below code. If error please share the error message as well.
Filter (Saisies_courses; StartsWith(Chauffeur.Value,TextInput2.Text))
Résultats de traduction
May be the issue is with the comma. Please try below code.
Filter (Saisies_courses; StartsWith(Chauffeur.Value;TextInput2.Text))
there is a message maybe more preciseTextInput2 = There is an error in this formula.Try to revise the formula andrerun.Data Type: Control
I forgot to specify, I have an AZERTY keyboard
The below formula works in my case if I put it in a items property. But it seems you are adding it in text field.
I'll update the formula try if it works in your case.
Worked in my case : Filter(DataSource,StartsWith(ColumnName,TextInputControlName.Text)) // - Results in many records best suited in case of gallery or items First(Filter (Saisies_courses; StartsWith(Chauffeur.Value;TextInput2.Text))).columnName //- Results in one record best suited in case of textfields
when I add the field in which I want to put the filter, it is the system which puts it in text; I do not have the hand to put it in property Iems; or else I don't understand your answer
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 392 Most Valuable Professional
11manish 181 Super User 2026 Season 2
MS.Ragavendar 112 Super User 2026 Season 2
