web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Trim with multiple mat...

Power Automate

Unanswered

Trim with multiple matching values - selecting the first value?

(0) Share

Report

Report

Posted on by DanNewton

40

Does anyone have experience using trim when multiple values match the trim criteria?

Currently it defaults to the last match value and I need to use the first match value

For example if my data looks like the below:

To: a
From: 1

To: b
From: 2

To: c
From 3

trim(first(split(last(split(outputs('my_string'),'To:')),'From:')))

The above will return c

However I want to return always the first match, which is a

The number of results might change, but regardless I would like trim to always use the first match in the string rather than the last.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Mister_Shaik 1,008 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DanNewton ,

Just to clarify, trim is a string expression that removes extra spaces or new lines.

You can get the first match using this expression:
trim(last(split(first(split(outputs('Compose'),'From:')),'To:')))

Expression

You will always get the first match:

Output

Hope you find this helpful!

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No

Join the conversation