Answered

Using substring and indexOf to get middle of string between two indexes, but having trouble

(0) Share

Report

Posted on by j_f

I've got a flow set up to send a bot message to Teams when a file is changed in a shared OneDrive directory. The message includes a link to the folder where the file resides. I want the text of this link to be the path of the directory, but in order for it to be user friendly, I want to only keep the part of the path which is after 'root:' and before the file name.

I want to do something like this:

substring( File Path, indexOf( File Path, 'root:' ) + 5, indexOf( File Path, File Name ) - indexOf( File Path, 'root:' ) + 5 )

To take this:

"/drives/b!KosGUJrQ10-JHf8xWUb2Zvba5vzW4a2Du7qcWPXQ99r1usopxzphRrN1IXAVuIeF/root:/External Shared/10466_SAFB/Exports/SAFB_PP.nwc"

to this:

"/External Shared/10466_SAFB/Exports/"

From what I can tell, Power Fx doesn't like the math operators in my expression. The expression returns no errors without the operators, but without the operators, I can't get the specific mid section of the string I want.

Any work arounds or suggestions?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (2)

Report
Hi @j_f,

If you want to add 5 characters you could use the add function instead of the +

Try something like:

add(indexOf( File Path, 'root:' ), 5)

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Hopefully this will get what you're looking for. Assuming the Path is in a Compose action.

slice(outputs('Compose'), add(indexOf(outputs('Compose'), 'root:'), 5), add(lastIndexOf(outputs('Compose'), '/'), 1))

Was this reply helpful? Yes No
j_f 4 on at

Like (0)

Report

Thanks! I'm happy there are people out there who know more than me! I got the result I wanted using a combination of add() and sub() within the substring() function and Dynamic input for the path.

Was this reply helpful? Yes No