Hello everyone,
I created an App using PowerApps, connected to an Excel file in OneDrive Entreprise.
In the Excel sheet, I have a Date column, in which I add the expiration date of Wifi acces we create to our clients.
Using the SortByColumns(Search(.... I only want to display Wifi Acces that are still available.
Thanks in advance.
Regards.
Solved! Go to Solution.
Hi @v-monli-msft Again,
I used the Filter function like so:
SortByColumns(Search(Filter([@WifiApp]; Date_x0020_expiration >= Today()); TextSearchBox1.Text; "Client"; "Demandeur"); "Client"; If(SortDescending1; Descending; Ascending))
Works like a charme ๐
Thank you.
Hi @machehboune,
Did you mean that you want to filter the items with expiration date later than today? Please try below formula:
Filter('Testing list', ExpirationDate>=Today())
Please have a try and see if this works.
Regards,
Mona
Thank you for your reply.
Here's the current syntax i'm using:
SortByColumns(Search(WifiApp; TextSearchBox1.Text; "Client"; "Login1"); "Client"; If(SortDescending1; Descending; Ascending))
Could you please tell me where to add the Filter function.
Thank you.
Hi @v-monli-msft Again,
I used the Filter function like so:
SortByColumns(Search(Filter([@WifiApp]; Date_x0020_expiration >= Today()); TextSearchBox1.Text; "Client"; "Demandeur"); "Client"; If(SortDescending1; Descending; Ascending))
Works like a charme ๐
Thank you.
User | Count |
---|---|
196 | |
124 | |
87 | |
49 | |
42 |
User | Count |
---|---|
284 | |
163 | |
138 | |
75 | |
72 |