web

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

News and Announcements icon

Power Platform CommunityForums Power Automate IndexOf inside a SubSt...

Power Automate

Unanswered

IndexOf inside a SubString

(1) Share

Report

Report

Posted on by OllyH

Hi,

I'm trying to get the First Name of a contact from a field by finding the first ' ' in their full name

Any idea why this formula including add() works:

substring(triggerBody()?['05 - CS Contact'],1,add(indexOf(triggerBody()?['05 - CS Contact'],' ') ,-1 ) )

But this without add() gives a 'The expression is invalid' message:

substring(triggerBody()?['05 - CS Contact'],1, indexOf(triggerBody()?['05 - CS Contact'],' ') -1 )

Cheers!

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (1)

Report

Hi @OllyH ,

Because if there is no function outside ‘-1’, it will be defaulted to a string, which does not meet the requirements of the formula.

If you add the 'add' function, the index position of the first space represented by the space is subtracted by 1.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @OllyH ,

If I solved your problem, could you please mark my reply as the solution? This way I will help more people in the future.😃

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
OllyH on at

Like (1)

Report

Done! 😁

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

Like (1)

Report

@OllyH

Using a couple of split() expressions will work also

Was this reply helpful? Yes No

Join the conversation