web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calendar View with Sha...
Power Apps
Answered

Calendar View with Sharpoint List only display items (Form) on every other day

(0) ShareShare
ReportReport
Posted on by 2

Hi everyone, 

I've a problem and maybe you can help me. 

Ive created a Sharepoint List with data in it and a column "date". 

In the Canvas App I've created a Calendar view which displays the data of the sharepoint list in a Form to edit. 

So if I click on the calendar (_Dateselected) the CalendarEventGallery compares the date column in the Sharepoint List with _dateselected 

The Form on the right display the data of the right column. 

 

The problem is no mather whith date I selecet. the Form displays only the data of every other day I select. 

 

To get no delegation warning in filterin the data in the Calendareventgallery, I changed the date into a number: 

february the 10th 2023 is 10022023 in number. 

I also change the _dateselected into that kind of number

 

Items of Form: calendareventgallery.selected

Items of Calendareventgallery: SortByColumns(Filter('Liste IH App Allgemein'; 'Datum Zahl' = Value(Text(_dateSelected; DateTimeFormat.ShortDate))); "Datum")

 

I know that is maybe a little less info but maybe someone can help me 

image.png
image.png
image.png
Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @millys ,

     

    If the Datum column is a Date only column, please try below formula:

     

    SortByColumns(Filter('Liste IH App Allgemein'; Datum = _dateSelected); "Datum")

     

     

    Besides, you'll have to check the variable _dateSelected and see if it is correct according to the date you selected in calendar.

    vjefferni_0-1676613374809.png

     

    Best regards,

  • millys Profile Picture
    2 on at

    Hi @v-jefferni 

     

    thanks for replying! 

    unfortunately that does not work: 

    millys_0-1678184253259.png

     in the bottom left corner you see I show _dateselected and thisItem.

    Both date version and number version. 

     

    But the result is the same.

     

    BR

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 150 Super User 2026 Season 2

Last 30 days Overall leaderboard