Jot Form multiple Image trim

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

We have a form that comes in through Jotform with multiple images attached amongst some other fields.

I want to put the results of this form into an excel document and store it. But the text for the images is coming through in its full form for each answer like below.

<tr><td colspan="2"><strong>Photo Of Ack Number</strong></td></tr><tr><td colspan="2"><img src="https://www.jotform.com/uploads/xxxxxxxxxxxxxxx/5363815538529013378/5363815538529013378_base64_14.png" /></td></tr>

I want to just pull the HTTPS link out and pop that into an excel field.

Thanks,

Adam

Categories:

Using flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Using first(skip(split())) might achieve your need.
Based on your description, I have made a simple test for your reference.
1. Here is my flow:
first(skip(split(outputs('Compose'),'"'),5))
2. Result Screenshot:

Best regards,
Sylvia

Was this reply helpful? Yes No