Unanswered

Compose returns wrong data in Power Automate

(1) Share

Report

Posted on by Luilui8090

Hi guys!
I´m trying that a compose action returns the subject email, but not completed, and example could be like this:
If and email arrives with this subject - Test 13 PM Stage3, then i want that the compose returns Test 13.
but if the subject email is Test PM Stage3, then the compose return Test.
I have a function in the compose:

if(

or(

equals(length(split(toLower(triggerOutputs()?['body/subject']), '[_/\\s-]')), 4),

equals(length(split(toLower(triggerOutputs()?['body/subject']), '[_/\\s-]')), 5)

concat(

split(toLower(triggerOutputs()?['body/subject']), '[_/\\s-]')[0],

' ',

coalesce(split(toLower(triggerOutputs()?['body/subject']), '[_/\\s-]')[1], '')

first(split(toLower(triggerOutputs()?['body/subject']), ' '))

)

But when i receive and email with the first example i give you (Test 13 PM Stage13), it returns to me only "Test".

I´ll give a little bit more of context, I want that if the first word of the email subject is text and the second one is a number, then the compose returns to me this two values.
Example Email Subject - Test 1313 PM Stage 15
Returns - Test 1313
But if the first condition is not correct, then returns only the first word of the subject.
Example Email Subject - Test PM Stage 15
Returns - Test

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

sandeepstw 312 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Luilui8090 ,

User this code in compose action -

if( and( equals(split(triggerOutputs()?['body/subject'], ' ')[0], 'Test'), isNumeric(split(triggerOutputs()?['body/subject'], ' ')[1]) ), concat( split(triggerOutputs()?['body/subject'], ' ')[0], ' ', split(triggerOutputs()?['body/subject'], ' ')[1] ), first(split(triggerOutputs()?['body/subject'], ' ')) )

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra

Was this reply helpful? Yes No
Luilui8090 32 on at

Like (0)

Report
Copy link

Link copied!

But how can I use this code if the subject always change in every email that arrives.
So the subject could be different, it don’t always need to be “Test” in my subject, this could be change when an email arrives, as the numerical word.

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (1)

Report
Copy link

Link copied!

Please elaborate your subject condition what ever it could be.

Was this reply helpful? Yes No
Luilui8090 32 on at

Like (1)

Report
Copy link

Link copied!

Of course! 😄
The subject can be anything, there is no specific one.
The function in the compose must do the following:
If the second word or fragment of the subject is numeric, then return the first two words or fragments of the subject.
If this condition is not met, it should only return the first word or fragment of the subject.
Example of a subject:
Charlie 567 MX Stage4
The condition should return:
Charlie 567
If the subject were:
Charlie MX Stage4
The condition should return:
Charlie

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!
if( and( greater(length(split(triggerOutputs()?['body/subject'], ' ')), 1), isInt(split(triggerOutputs()?['body/subject'], ' ')[1]) ), concat( split(triggerOutputs()?['body/subject'], ' ')[0], ' ', split(triggerOutputs()?['body/subject'], ' ')[1] ), split(triggerOutputs()?['body/subject'], ' ')[0] )

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (1)

Report
Copy link

Link copied!
HI @Luilui8090 ,

Use this expression -
if( isNumeric(split(triggerOutputs()?['body/subject'], ' ')[1]), concat(split(triggerOutputs()?['body/subject'], ' ')[0], ' ', split(triggerOutputs()?['body/subject'], ' ')[1]), first(split(triggerOutputs()?['body/subject'], ' ')) )

Was this reply helpful? Yes No
Luilui8090 32 on at

Like (0)

Report
Copy link

Link copied!

I got this error in my function with your code

Was this reply helpful? Yes No
Luilui8090 32 on at

Like (0)

Report
Copy link

Link copied!

I got this error in my function with your code

Was this reply helpful? Yes No