Filter function

(0) Share

Report

Posted on by NurNina

375

Hi, how do I filter the field created on in cds to today inside the canvas apps?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Filter (Datasource,Text(CreatedOn,ShortDate,=Text(Today (),ShortDate)

You can give more details about the Datasource if you still have issues
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
NurNina 375 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @eka24 ,right now, I have the gallery that I filter based on verification. and I have a field created on display inside the gallery. I want to filter the list of data to today's list,next to verify inside the filter below.

Filter(Attendances,Verify='Verify (Attendances)'.No)

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If want to add the date filter:
Filter(Attendances,Verify='Verify (Attendances)'.No &&
Text(CreatedOn,ShortDate,=Text(Today (),ShortDate))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
NurNina 375 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eka24 Ive tried but it says here the text function has invalid argument.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please can you show the full formula. Your screen shot is not clear enough.
Before that try;
Filter(Attendances,Verify='Verify (Attendances)'.No &&
Text(CreatedOn,ShortDate)=Text(Today (),ShortDate))

Take a screenshot of the full formula is you have issues with the formula above
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@eka24 and @NurNina

I would be curious to see why this wouldn't work:

Filter(Attendances,Verify='Verify (Attendances)'.No && DateValue(Text(CreatedOn)) = DateValue(Text(Today())))

Let me know if this helps.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
NurNina 375 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @PowerAddict , @eka24 ive tried both formula, they work. However, they have delegation warning. In result, the gallery does not display all the items for today. Only 7 out of 11.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you make the screenshot bigger to cover the complete formula. You are only showing a small portion
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NurNina ,

Try to use this code in Gallery.Items property, which is delegable.

Filter(Accounts,'Created On'>Today(),'Created On'<DateAdd(Today(),1,Days))

Hope this helps.

Sik

Was this reply helpful? Yes No