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

how data should be structured for desk reservation app

Dear community,


I was starting to build a desk reservation app but scratching my head how should I structure my data on the Sharepoint.


Per day I have only 50 desks available and user can select any date for the month. I am not sure how many Sharepoint list I should create to have 50 desks available per day basis calendar selection. User should also be able to see slots available for that day.


Any guidance on how many list I should create or how to source all the data in 1 list to cater to above requirement?




@KvB1 thanks for the last message, after further tweaking basis logics you provided it worked thanks.


I am not sure but on some date, If I go back to the screen the button is deactivated but in the gallery the item which I already booked still show as 'Unreserved'. Not sure why gallery is not reflecting the latest data? I did put in the formula - Refresh(datasource) 

Solution Specialist
Solution Specialist

Keep in mind that your gallery is showing the items from one datasource, but it determines the reserved/unreserved field by looking up a value in your second datasource.

Are both datasources being refreshed?

Added the other data source, still cant see status change for newly added items in the gallery

Solution Specialist
Solution Specialist

So this means that the LookUp function used can't find any records, therefore it returns Unreserved.

Can you confirm the format and argument type of the date are identical is identical to the value of the datepicker?

Helper IV
Helper IV

Its same I guess, attaching screenshots for the same for your reference



Date format Sharepoint.jpg

Solution Specialist
Solution Specialist

Could you test some more, set Text value of test label to: First(List2).DateBooked


Then set your datepicker to that date, and see if 
DatePicker2.SelectedDate=First(List2).DateBooked returns true?

Coming as False.

Solution Specialist
Solution Specialist

Now we confirmed that validating the existance of the record based on the date doesnt work, because it doesn't see the value of the date column of the record in sharepoint as identical as the output of the datepicker.


If we can figure out how to match them it will work. 


If you add a . after First(List2).DateBooked does it suggest anything? Will that make the validation we tried return true?

You can also try converting both to Text( etc

Its not coming if I add '.'


And Sorry My Bad - First record of had date as 07 July and when I put that date in datepicker then it comes as 'True'.


I read the previous comment differently.

Solution Specialist
Solution Specialist


Does this also return true?

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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