cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yazeed_Ablan
Helper II
Helper II

SUBSTRING FUNCTION

Hi All, 

i need to write a function in power aoutomate that will extract the email form this table in sql server, 

"ASJDIVLCL@DOVMCYAZEEDABLAN@OUTLOOK.COMQWERIVNXCC"

 

the email is yazeedablan@outlook.com , 

and always comes after "VMC" and ends before "QWER"

thanks all 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @Yazeed_Ablan ,

 

I did a sample for you.

vxiaochenmsft_0-1658893049846.png

slice(outputs('Compose'),add(indexOf(outputs('Compose'),'VMC'),3),indexOf(outputs('Compose'),'QWER'))

 

vxiaochenmsft_1-1658893074026.png

 

More flow function information:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#i...

 

Best Regards,

Wearsky

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @Yazeed_Ablan ,

 

I did a sample for you.

vxiaochenmsft_0-1658893049846.png

slice(outputs('Compose'),add(indexOf(outputs('Compose'),'VMC'),3),indexOf(outputs('Compose'),'QWER'))

 

vxiaochenmsft_1-1658893074026.png

 

More flow function information:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#i...

 

Best Regards,

Wearsky

Yazeed_Ablan
Helper II
Helper II

hi @v-xiaochen-msft 

thank you so much for your past solution

now i have semi coloums and it wont split it 

(c09a9c70cfd3':'ganiul.zadid@g.bracu.ac.bd','ce512137-d1ea-44fc-8a39-)

and it always comes after (c09a9c70cfd3':') and before ','ce512137

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,311)