News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion Slice function

Power Automate - General Discussion

Answered

Slice function

(0) Share

Report

Report

Posted on by Mysterious

67

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:

Process Advisor

All responses Img

All responses (5)

Answers Img

Answers (1)

RT-20121435-0 4 on at

Like (0)

Report

Slice function

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.
Mysterious 67 on at

Like (0)

Report

Re: Slice function

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

v-mengmli-msft on at

Like (2)

Report
Re: Slice function

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 67 on at

Like (0)

Report

Re: Slice function

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

This is the output.
v-mengmli-msft on at

Like (0)

Report

Re: Slice function

Hi @Mysterious ,

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

Best regards,

Rimmon

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 143,867

#2

RandyHayes 76,308

#3

Pstork1 64,174

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans