Filtering Data From Excel

(0) Share

Report

Posted on by firda59

372

Hello!

I have a gallery in PowerApps, I want to grab data from Excel which has more than 20.000rows. But, I know that PowerApps can grab data from excel less than 2.000. So, I want to fillter it.

I'm similar using this formula,

reload button: ClearCollect(POnumber ,Filter(Perform,Value(No)<=2000), Sort(Perform,No,SortOrder.Descending))
text input: Distinct(POnumber, Order)

then, I can get the lastest 2000 rows form excel.

But, now, I want to get at least 1500 rows excel, which has 'Received Date' value 3month from now and 'Delivery Date' value blank.

How to filter that data? Thankyou.

Categories:

General Questions

Connecting to Data

Using Apps Using Formulas

Dataflows

All responses (3)

Answers (0)

Sundeep_Malik 6,488 on at

Like (0)

Report

Re: Filtering Data From Excel

@firda59

Not exactly sure, first time seeing this error. Try the following expression. If it doesnt work. I will try it on my end on the weekend.

ClearCollect(
POnumber,
Filter(
Perform,
Value(No) <= 2000 && // Limiting to 2000 rows
DateValue(Text('Received Date', "yyyy-mm-dd")) >= Today() - 90 && // 'Received Date' 3 months from now
IsBlank('Delivery Date') // 'Delivery Date' is blank
),
Sort(Perform, No, SortOrder.Descending)
)
firda59 372 on at

Like (0)

Report

Re: Filtering Data From Excel

Hello @Sundeep_Malik ,

I try that formula, but I got this message:
expected value '' to be a valid rfc 3339 'date-time' format. allowed iso 8601 format(s): 'yyyy-mm-ddthh:mm:ssz', 'yyyy-mm-ddthh:mm:ss±hh:mm', 'yyyy-mm-ddthh:mm:ss'

I use format dd-mm-yy in my excel file, ex: 14-Mar-23.

Do you know how to solve this? Thankyou
Sundeep_Malik 6,488 on at

Like (0)

Report

Re: Filtering Data From Excel

Hey @firda59

You can try the below expression/formula for your scenario:

ClearCollect(
POnumber,
Filter(
Perform,
Value(No) <= 2000 && // Limiting to 2000 rows
'Received Date' >= Today() - 90 && // 'Received Date' 3 months from now
IsBlank('Delivery Date') // 'Delivery Date' is blank
),
Sort(Perform, No, SortOrder.Descending)
)

I hope this helps 🙂