You’re offline. This is a read only version of the page.
Announcements
First of all, extreme rookie here. Apologize for that right away.
The goal is simple. We have a Sharepoint list for "Time Off". Consisting ultimately of a Title (a Power App will combine some fields), and a date range. So, some typical rows would look like:
"Title":"John Doe - S - 8":", "Start Date":"05-01-22", "End Date":"05-04-22"
"Title":"Jane Doe - V - 4":", "Start Date":"05-05-22", "End Date":"05-06-22"
You get the idea.
The goal with this data is to build an HTML calendar (it's a shame the built-in calendar functionality with Sharepoint lists is still a little lacking). I've got a good way through this project, thanks to this thread here.
However, I'm now at a stuck point. The "date range" idea I'm using is throwing things off a bit. I think I can move forward if I could figure out how to break the date range data above into individual days. Then in each cell in a calendar, I could pull in that day's data. (this worked with some crafted-by-hand test arrays).
Example:
{
["05-01-22": <That day's data>"],
["05-02-22": <That day's data>"]
etc., for the entire month.
Hopefully I'm making sense. I want to "expand" the data from a date range into individual dates for an array.
Share
Report
All responses (
Answers (
462
