ics attachment to parse JSON, unexpected character in B. Path

[Marissa_A]

I have an issue with Parse JSON processing \n in the body content. I tried to use split to make the \n a comma, and I tried using replace to make it a comma, but I can't even update my compose function because it's those were invalid. The ai says that my flow doesn't support split or replace, and when I ask it to help it gives me another blank compose action and throws a send email onto the end of my flow. Not helpful, and I haven't seen anyone else with quite the same problem.

Here is my compose function:

Here is an excerpt of the output content the Parse JSON needs to process:

    "content": "BEGIN:VCALENDAR\nVERSION:2.0\nPRODID:-//Racarie Software//ApplicantStack//EN\nCALSCALE:GREGORIAN\nMETHOD:PUBLISH\nBEGIN:VEVENT\nSUMMARY:Interview- Teams\nX-MICROSOFT-CDO-BUSYSTATUS:BUSY\nURL:https://allweathersealofwestmichigan.applicantstack.com/events/view/aneinqs9hr4p\nLOCATION:Teams Call\nDESCRIPTION:Candidate....."

The builder ai said the unexpected character we were running into is the \n, so these are the functions I thought I could use:

*Compose being the original Compose action I mentioned at the beginning

When the function tool told me those were invalid, the ai kept insisting that the problem was the flow not supporting it, so here's the meat of that:

If it makes a difference, the data I'm decoding is an ics email attachment that was in binary. It opened a link, but was technically in JSON format rather than html like similar examples I've seen. This is my attempt at accepting an ics email attachment into my calendar. This is the thread that gave me the idea to use the replace function, but it's formatted in html: Unexpected character encountered while parsing value: E. Path 

[Marissa_A]

@ekarim2020 I just saw a similar issue you helped with. Any idea what I can do here?

[ekarim2020]

Hi @Marissa_A ,

I don't think it is possible to read and then import the ics file attachment into Outlook. The content of the ics file when read will also not be in JSON format. Please see  Re: .ics in main calendar Outlook - MS Power Autom... - Power Platform Community (microsoft.com):

"Unfortunately, there is no built-in action for importing an ICS file through Power Apps.  It is possbile to read the raw ICS file and create an event, but it is difficult.  I've seen some blogs on creating ICS files, but haven't seen any on how to read and import them using Power Automate.  Please post any that you have seen. " @Pstork1 

Having said that if you still want to split the content of the ics file at the CRLF (carriage return line feed) character:

The Attachments property is an array:

Get the content converted to string:

 Split the content at the CRLF character

 

 

split(outputs('Compose'),decodeUriComponent('%0D%0A'))

 

This is an ics file showing the CRLF characters at the end of each line:

 

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[Marissa_A]

Thank you, I've gotten closer. The "%0D%0A" code didn't work, but "\n" almost did.

This is the input code for parse JSON. There are " " lines where info should be, and the lost info is preventing my schema from working. You can also still see some "\n"s in there.

This is what the decoding outputs, and this is the info my schema needs. Most of the properties occupy their own line with "\n" showing up in the body, so I suppose it is double-dipping a bit with the "\n" phrase. It actually looks like it's removing lines from the DESCRIPTION property but leaving it between properties.