Problem with expression

(0) Share

Report

Posted on by Magikmissy

109

Hi everyone,

@edgonzales very kindly gave me the below as a solution to some problems I was having with my flow. Unfortunately it won't let me enter it! I'm getting an error saying 'The expression is invalid.' from the expressions tab. I'm sure it'll just be a typo like a comma or bracket in the wrong place, but I don't know enough to correct it. Can anyone help please, as Ed won't be up for 5 hours yet...! 😂

substring(items('Apply_to_each')?['name'],0,add(indexof(items('Apply_to_each')?'name'],last(split(items('Apply_to_each')?['name'],'.'))),-1))

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Krishna92 Microsoft Employee on at

Like (0)

Report

@Magikmissy

I think the problem is with the indexof() function it accepts only two parameters and in the below formula you are trying to pass three parameters, indexof(items('Apply_to_each')?'name'],last(split(items('Apply_to_each')?['name'],'.')

indexOf
This function finds the index of a value within a given string case insensitively. This function requires 2 parameters: the string that contains the value and the value to search the index of.
Function: indexOf(text, searchText)

If this information helps you, please hit the like button and mark the solution as resolved, so that it will help other users in future.

Was this reply helpful? Yes No
Verified answer

Magikmissy 109 on at

Like (1)

Report

It was missing a bracket!

Substring(items('Apply_to_each')?['name'],0,add(indexof(items('Apply_to_each')?['name'],last(split(items('Apply_to_each')?['name'],'.')) ),-1))

Was this reply helpful? Yes No