Power Platform Community Forum Thread Details

I'm trying to convert an ICS file attached in a mail to a google calendar item. I was able to extract the text from the invite in the following format:

BEGIN:VCALENDAR
PRODID:-//DigiFit//Gym//EN
METHOD:PUBLISH
VERSION:2.0
BEGIN:VEVENT
SUMMARY:Summary
UID:******@********.com
STATUS:CONFIRMED
DTSTART:20220831T194500
DTEND:20220831T204500
DESCRIPTION:Description
LOCATION:location
END:VEVENT
END:VCALENDAR

Raw output:

"BEGIN:VCALENDAR\nPRODID:-//DigiFit//Gym//EN\nMETHOD:PUBLISH\nVERSION:2.0\nBEGIN:VEVENT\nSUMMARY:Summary\nUID:******@********.com\nSTATUS:CONFIRMED\nDTSTART:20220831T194500\nDTEND:20220831T204500\nDESCRIPTION:Description\nLOCATION:location\nEND:VEVENT\nEND:VCALENDAR"

Basically I want to extract the DTStart DTEnd and description, I already managed to split the text into a string array using the "

Compose CRLF: decodeUriComponent('%0A')"

Compose split(variables('lines'), outputs('CRLF'))

Apparently the \n split was a bit difficult so I used the option above. I now want to extract the 3 fields, I'm hoping to find a clever way to to this instead of looping all the lines and try to extract it via a substring() in combination with the "indexof(). to find the ";"

Categories:

Building flows