Answered

Error filtering data by selected calendar date

(1) Share

Report

Posted on by CU10030108-0

Hi ,

Im a beginner to Power Apps and I’m building a staff weekly schedule calendar in Power Apps. The calendar shows dots on dates that have programs. When a user selects a date, I want to display all program details for that date in a gallery on the right side.

My data source is an Excel table (Table1_1). I tried using this formula in the gallery Items property:

Filter(Table1_1, Program = _dateSelected)

But I get this error:

“Invalid filter clause: unsupported operation. Only 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.”

I used this to connect the dates to the calandar

!IsBlank(
LookUp(
Table1_1,
DateValue(Text('Session Date'))=DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days),Program
)
)

How can I correctly filter the gallery by the selected calendar date so that when a user clicks a date, the programs for that date appear on the right side?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Mitanshu 1,658 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Is the Session Date column in Excel a Date column or a Text column or a DateTime column?

Can you try:

Filter( Table1_1, DateValue('Session Date') = _dateSelected )

Note:

1- Excel as a Power Apps data source is very limited in the functions it supports for delegation and filtering

2- I strongly recommend to NOT use Excel as a data source for serious applications. Excel isn't recommended even for prototypes!

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @CU10030108-0,

Firstly @Mitanshu is correct in that Excel is really the "data source of last resort" and will cause you more problems than this, especially with dates and also once the table gets bigger. If you have access to SharePoint Lists, I suggest you change to one of these.

Apart from the question on how you are storing the date in Excel (I assume as Text as DateValue works for you), but the item you have not included is how you define _dateSelected as the error is a bit strange.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CU10030108-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No