Answered

Get data using 2 datepickers

(0) Share

Report

Posted on by Jyothi1

Hi Everyone,

I have a data in excel which I have added using patch function and in another screen I need to get that data using 2 date pickers like Start date and End date. I should get all the data from that month which is stored in excel. I tried various ways but its not working. Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Jyothi1

On the Items property of your gallery:
Filter('Data source', 'Date Column' >= DateFrom.SelectedDate && 'Date Column' <= DateTo.SelectedDate ) // Change DateFrom and DateTo with the names of your date pickers

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
Verified answer

FazalUrrehman 131 on at

Like (0)

Report
Copy link

Link copied!
Try This :
Filter('Data source', DateValue('Date Column') >= DateFrom.SelectedDate && DateValue('Date Column') <= DateTo.SelectedDate )

Was this reply helpful? Yes No
Jyothi1 39 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Thank you for the reply but it isnt working.

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Jyothi1

What does the error say?

Also, it says "We didn't find any data to show at this time". Double check you have data is in between those dates selected.

Was this reply helpful? Yes No
FazalUrrehman 131 on at

Like (0)

Report
Copy link

Link copied!

Whats the format of Date in excel ??

Was this reply helpful? Yes No