PowerApps connected to a Excel file.

[machehboune]

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.

[v-monli-msft]

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

[machehboune]

Hi @v-monli-msft

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.

[machehboune · Accepted 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.