Power Platform Community Forum Thread Details

Building a calendar HTML flow. Need some help with messaging the data from a Sharepoint list

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.

Quick Links