Howdy all, I'm a very novice user to be honest. We am starting to build some tools and have had sucess creating a public report page showing current week events from a shared event calendar in our O365 environment. I have that linked to a window on some digital signage in our warehouse. The next report would come from a iCalendar link outputted by one of software platforms we use for scheduling. When I place the data (web) in my query and double click to open, I get a single column with roughly 17,000 rows. It is breaking out every single piece of info into a specifc row. Each event starts with a BEGIN:VEVENT row and ends with a END:VEVENT row. The info (that resides between those markers) that I'd like to pull out would be DESCRIPTION, DTSTART, DTEND, LOCATION, and SUMMARY. Each of these would be a column that I could map to the fields from the cool little Calendar Visual from MAQ that I am using for the shared calendar report. This would want to re-run a few times a day (unless is too data heavy) as schedules are constantly being updated. Do I need to double step through Power Automate? Thought, prayers? Thanks in advance!
