Trim text in Output

(0) Share

Report

Posted on by PowerAppsUser99

All,

This is my Output of my compose step.

RUN-CAC: Testing123

I would like to create a new compose step to only parse the "Testing123". So essentially I need to trim out the bolded text.

Does anyone know how I can achieve this?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If the text at the front is always RUN-CAC: then you could do a simple replace() to replace 'RUN-CAC: ' with ''. If its something else each time, but always ending in a : then you could do a split and use Last() and Trim to get the value.

Was this reply helpful? Yes No
ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@PowerAppsUser99

Following up on what @Pstork1 has offered, here is an example of the split() technique:

Was this reply helpful? Yes No
BJ94 264 on at

Like (0)

Report
Copy link

Link copied!
Hi @PowerAppsUser99
You can use Split function to split the string.

split(variables('MyString'),'with')

and save output.

------------------------------------------------------------------------------------------
Regards,
Bharti
Community Support Team _ Bharti
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
BJ94 264 on at

Like (0)

Report
Copy link

Link copied!

Hi @ScottShearer
I am using same formula as you given but it says expression is invalid.

Was this reply helpful? Yes No
Pstork1 68,923 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Your parentheses are unbalanced. You have 3 open parentheses and 4 closing parentheses. Remove one of the closing parentheses.

Was this reply helpful? Yes No