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:

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mysterious ,

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

Best regards,

Rimmon
Mysterious 69 on at

Like
a
(0)

Report
Copy link

Link copied!

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

This is the output.
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
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
Mysterious 69 on at

Like
a
(0)

Report
Copy link

Link copied!

I appreciate your help so much @v-mengmli-msft
RT-20121435-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Join the conversation