web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to Show Only Calen...

Power Apps

Answered

How to Show Only Calendar Events Where Subject Contains "Booking"?

(0) Share

Report

Report

Posted on by GG-14031730-0

8

Hi everyone,
I'm working with a calendar in Power Apps and would like to display only those events whose Subject contains the word "Booking". Currently, the Visible property of C_Circle2 is set to:

CountRows( Filter( MyCalendarEvents, DateValue(Text(Start)) = DateAdd(_firstDayInView, ThisItem.Value, Days) ) ) > 0 && !Subcircle1.Visible && Title2.Visible

How can I modify this formula so that it only counts/displays events where the Subject field contains the text "Booking" in addition to matching the selected date?

Any suggestions or examples would be appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

11manish 3,333 on at

Like
a
(1)

Report
Copy link

Link copied!
If your calendar event table has a column named Subject, try:

CountRows( Filter( MyCalendarEvents, DateValue(Text(Start)) = DateAdd(_firstDayInView, ThisItem.Value, Days) && "Booking" in Subject ) ) > 0 && !Subcircle1.Visible && Title2.Visible

Was this reply helpful? Yes No
Verified answer

DP_Prabh 381 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @GG-14031730-0,

try using this formula,

CountRows(
Filter(
MyCalendarEvents,
DateValue(Text(Start)) = DateAdd(
_firstDayInView,
ThisItem.Value,
Days
),
"Booking" in Subject
)
) > 0 && !Subcircle3.Visible && Title25.Visible

✅ If this helped, please mark it as the Accepted Solution. 👍 A Like is appreciated and helps others find the answer more easily!

Was this reply helpful? Yes No

Join the conversation