Defect in Jotform, Power Automate & SharePoint

(0) Share

Report

Posted on by wiredupjax

195

I'm using Jotform to conduct surveys. That survey data is coming over into a SharePoint list via Power Automate.

Even though I have selected "text" for the fields, I'm receiving HTML <br>'s after the Jotform answers. This is preventing me from managing the data once in SharePoint.

Adding HTML.jpg

Here is the PA flow:

Below shows the spaces in the text:

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@wiredupjax

Try the following - replace the values in your Create item action with following expression for each column:

first(split([reference to the value from Jotform from Dynamic props], '\n'))

So, for each column in the SharePoint list, you'll enter the expression above with a reference to the value to be inserted from Dynamic props.

Was this reply helpful? Yes No
wiredupjax 195 on at

Like
a
(0)

Report
Copy link

Link copied!

@ScottShearer Thank you for the response.

I created the expression as you described, however I am still getting the \n

See the flow and flow output

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @wiredupjax,

I tried to produce a JotForm, and create an item in SharePoint list, but '\n' doesn't appear, I guess the root cause is on the JotForm, when you submit the JotForm, did you type any "Enter"?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
wiredupjax 195 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-litu-msft

Try to create a question as Yes/No -- not as a single choice but the Yes/No and see if it comes across with the \n

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @wiredupjax,

Yes, if it is a Yes/No type, it will have the same issue. If it is a simple choice type, it will not has additional '\n'.

So, as a workaround, you could use the simple choice, set the options to Yes/No:

Or you could use the uriComponent() function to convert the '\n' into URI code '%0A', then use replace() function to remove the '%0A', then use the decodeUriComponent() function convert it back:

decodeUriComponent(replace(uriComponent(triggerBody()?['QuestionName']),'%0A',''))

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No