Answered

Is it possible to parse paragraph marks from a multi-line datacard (when sending to Flow)?

(0) Share

Report

Posted on by Medoomi

523

I am collecting the content of a form, one of the fields of which is a multi-line Field (Dataverse) & using JSON format to integrate this with flow. eg. "ScopeOfWork" below:

ClearCollect(
 colFormWithNotes,
 {
 State: DataCardValue88.Selected.Abbreviation,
 Zip: DataCardValue42.Text,
 ScopeOfWork: DataCardValue90.Text
 }
);
FlowProjectDetails.Run(JSON(colFormWithNotes))

However, when I parse the content to JSON in Flow, the paragraph marks from "ScopeOfWork" are missing.

Is there a way to parse a multi-line datacard and retain the paragraph marks?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Medoomi

I assume you collected data in PowerApps to the collection is fine. And you are sending the collection to Flow.

In the flow, when you parse the JSON content in the flow, you have to provide the Scheme which can be generated from the sample.

Add Parse JSON action
Click "Generate from Sample" for schema and provide the below sample
{ "State": "Minneapolis", "Zip": 55445, "ScopeOfWork": "My Scope" }

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
Medoomi 523 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @StalinPonnusamy ,
in Flow, I had to adapt the schema to allow for null values, but apart from that, there's not much difference. My final schema is as follows:
{ "type": "array", "items": { "type": "object", "properties": { "ScopeOfWork": { "type": [ "string", "null" ] }, "State": { "type": [ "string", "null" ] }, "Zip": { "type": [ "string", "null" ] } }, "required": [] } }
But still, the paragraph marks are not parsed.
Is this because I am using type: string for ScopeOfWork? i.e. should I be using array, or will this mess up the schema?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
I believe ScopeOfWork is Multiline text which has NewLine and other special char that not parsing properly.

Can you Hardcord the value from PowerApps and sent it to Flow to test the flow piece working or not.?
Is the Collection is an array from PowerApps to flow?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Medoomi

Can you try substituting the values and see data are passing through like
Substitute(DataCardValue90.Text,Char(10),"<br/>")

Was this reply helpful? Yes No
Verified answer

Medoomi 523 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy
Thanks again for your reply. I should have checked before, but new lines apparently are parsed correctly (I can see them in the output in Flow). They are carried as /n...
Seeing as I was writing html, I simply introduced style="white-space: pre-line" to the paragraph, and the /n marks are read correctly.
Thank you so much for trouble-shooting!

Was this reply helpful? Yes No