web

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

News and Announcements icon

Power Platform CommunityForums Power Automate How to extract text in...

Power Automate

Suggested Answer

How to extract text in power automate

(1) Share

Report

Report

Posted on by Jyamjams75

35

Hello everybody,

I built a flow that enable users to answer an adaptative card and then this create two tickets in two different "planner".

I works perfectly.

I use the field "description" of each planner to store data as the resquester identity, the ID of the other ticket etc...

My question is : how to extract and work on the text store in this fiels ?

I mean, i just want to extract the text beetween "**********" and then extract text between each ";" ?

My field description :

Thanks a lot

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Expiscornovus 33,828 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
You can use a couple of split functions in an expression.

Below is an example in a Compose action.

split(trim(split(outputs('Update_task_details')?['body/description'], '**********')[1]), ';')

Was this reply helpful? Yes No
Jyamjams75 35 on at

Like (1)

Report
Copy link

Link copied!
Thnaks a lot,

Now, I'm trying separate each variable :

* Variable 1 : all the text between "*********" et ;

* Variable 2 : all the text between ; et ;

* variable 3 : all the text after the 2nd ;

The outpout of your formula is

[\r\nDemande Demande envoyée par YYYYYY XXXXX\r\nDocument : TEST TEST TEST\r\nID : hW1-JzNGvkSJyJ6n-kWlk5gPLwir"]

Thought I could use First, first + slip and last to obtain my 3 variables...but it didn't work :(

Do you know what i should do ?

Thanks a lot

Was this reply helpful? Yes No

Join the conversation