web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Slice function

Power Automate

Answered

Slice function

(0) Share

Report

Report

Posted on by Mysterious

69

Hi Everyone,

I needed to extract a substring from a string and I used the slice function there. But it's showing an error.
Screenshot 2024-06-28 122605.png

Does anybody have a clue what I have to do here because I don't?

Categories:

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

v-mengmli-msft on at

Like (0)

Report

Hi @Mysterious ,

Please show outputs of this and tell me the substring you want.

Best regards,

Rimmon

Was this reply helpful? Yes No
Mysterious 69 on at

Like (0)

Report

Hi @v-mengmli-msft ,
"RITM0338201" this is the substring I need.

This is the output.

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (2)

Report
Hi @Mysterious ,

The slice expression should contain position of start character and end character. Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Please modify your expression.

slice('<text>', <startIndex>, <endIndex>?)

You can also try substring. Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Best regards,

Rimmon

Was this reply helpful? Yes No
Mysterious 69 on at

Like (0)

Report

I appreciate your help so much @v-mengmli-msft

Was this reply helpful? Yes No
RT-20121435-0 4 on at

Like (0)

Report

inside the slice expression instead of the start and end index number, you can also use a function called indexof() intead of manually giving index number to dynamically find the index number.

Was this reply helpful? Yes No

Join the conversation