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 / Show all record in sha...
Power Apps
Answered

Show all record in sharepoint that add in this label with one click

(0) ShareShare
ReportReport
Posted on by 162

Hi, 

 

I have created PowerApps as Calendar and show in app as Calendar form. In one day their have many record show in calendar I would like to set when user click in a day then pop up screen to show that day have any users that booked on the day.

 

EX. If I want to check 1 Dec 2023  and click this day and PowerApps will pop up show all record in this day.

 

Screenshot 2023-11-10 133841.png

Categories:
  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @nitisak ,

     

    There is a sub-Gallery inside the calendar Gallery, so, you can simply use UpdateContext OnSelect of the Calendar Gallery, set a variable to save the selected date, and on the pop-up screen add a new Gallery, Items set to similar as the sub-Gallery, only the criteria would be different. 

     

    Best regards,

  • nitisak Profile Picture
    162 on at

    Hi @v-jefferni 

     

    Could you explain more I dont get it.

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @nitisak ,

     

    What I meant was to set a variable OnSelect of the sub-Gallery, Navigating to a pop-up screen where includes a Gallery just like the sub-Gallery. If you can share the formulas in Items of main and sub-Galleries, I will be able to give you more detailed formulas.

     

    Best regards,

     

  • Verified answer
    nitisak Profile Picture
    162 on at

    Hi @v-jefferni 

    Main Gallery 

    nitisak_0-1700122813283.png

     

    Sub Gallery (I Have Filter Status HDO cause I have 2 Status for users to select)

    nitisak_1-1700122840017.png

     

  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @nitisak ,

     

    Please follow below steps:

    1. OnSelect of main Gallery:

    Select(Parent);Navigate(PopUpScreen)

     

    2. Nothing in OnSelect of sub-Gallery.

     

    3. popup screen Gallery items:

    Filter(Calendar, Status.Value = "HDO", StartDate = MainGallery.Selected.Value) || SecondDate = MainGallery.Selected.Value || ThirdDate = MainGallery.Selected.Value))

     

    Best regards,

  • nitisak Profile Picture
    162 on at

    Hi @v-jefferni 

     

    Now it's work. thank you 

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

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 258

#3
Mohsin Ali Profile Picture

Mohsin Ali 231

Last 30 days Overall leaderboard