Power Platform Community Forum Thread Details

slice(outputs('Compose_5'),outputs('Find_text_position_5')?['body'],add(outputs('Find_text_position_6')?['body'],add(length('.com'),-2)))

in the above formula i need to add starting index from next letter, how to add that position.

i need to amend above formula because text length will not be same every time, but it will start with '@' and ends with '.com'.

so to ends before .com i have given -2 its working but i need text to start after @.

'Find_text_position_5' will be '@' and'Find_text_position_6' will be '.com'

Kindly refer the below image for your reference.

Categories:

Slice formula Doubt