Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Display data in a calendar

I am trying to develop a calendar that will display the list of data on the corresponding date cell based on the "Due Date" field indicated on my data source: Sharepoint List. However, I am hitting the error below (second image)




If((Text(ThisItem.'Calibration Due Date'))=Text((DateAdd(varVideoFirstDayView,ThisItem.Value,Days))),true,false)


Super User
Super User



from your screenshot i see the problem is in ThisItem.Value.

What data column and datatype it suppose to have?

What does the error say if you hover mouse pointer over Value word in your code?

You are correct! I have a Gallery within a Gallery wherein the ThisItem.Value refers to a property in Gallery 1 where I am trying to enter it in Gallery 2. Here are more detailed info:


GalListMonth (Gallery 1) contains the corresponding Date value through the Label4 text property. This is how I can display the days of the month on the calendar.






GalListData (Gallery 2) is where I would like to compare the "Due Date" field I have from my Sharepoint List and "Label4" text property from Gallery 1, and if values are same I would like to set the Visibility property to true but I am not sure how to go about this. Can you help me please?




Super User
Super User


You might want to take a look at this post.  In message number 3, I provided a full calendar example that would simplify your calendar design.  It does not use nested galleries.  So you will have your date values available on all cells easily.

Although this is not about addressing your initial problem, it's just a suggestion of a calendar design that you might like to work with.

I hope this is helpful for you.

Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Super User
Super User


you can place a hidden (or with transparent text colour) label inside GalListData.

label.Text = Label4.Text


and then refer to that hidden (transparent) label in your calculations

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,096)