web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Help extracting data b...

Power Automate

Answered

Help extracting data between two points HTMLtoText

(0) Share

Report

Report

Posted on by mbro0

11

Hi All,

I have a flow that uses HTMLtoText and provides the below output

Time 16:00
Place 62 Date Avenue, Testland, Test
Date 10/05/2023

I am normally OK using the expression below, however when the Place contains the word 'Date' this breaks and as such I am stuck.

trim(first(split(last(split(body('Html_to_text'),'Place')),'Date')))

I have looked around on here but cant seem to find anything that works, the below just errors when used with the above example.

trim(split(split(body('Html_to_text'),'Place')[0],'Date')[1])

As always, any and all help appreciated.

Thanks

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @mbro0

Please use the below expression:

if(greater(length(split(last(split(variables('varHTMLText'),'Place')),'Date')),2),concat(trim(split(last(split(variables('varHTMLText'),'Place')),'Date')[0]),' Date ',trim(split(last(split(variables('varHTMLText'),'Place')),'Date')[1])),trim(first(split(last(split(variables('varHTMLText'),'Place')),'Date'))))

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
mbro0 11 on at

Like (0)

Report

Amazing! Thank you

Was this reply helpful? Yes No

Join the conversation