Power Platform Community Forum Thread Details

I need to Extract 6 digits from an email body. ChatGPT has instructed me to use Compose with this input:

substring(body('Get_email')?['body'], indexOf(body('Get_email')?['body'], 'Your verification code is') + 25, 6)but when i open the file it just shows the code and not the 6 digits. Also willing to try in Desktop if it's possible

Categories:

Building flows

Based on your screen shot, you just wrote your expression in the Compose action. You need to use the expression builder to write the expression. When you use the expression builder, it will show like this:

Your expression is also not valid as "+" is not the expression to add in Power Automate. I think you are trying to get the next six characters after "Your verification code is" from a string. If so, you expression would be:

substring(triggerBody()?['text'], add(int(indexOf(triggerBody()?['text'],'Your verification code is')), 26), 6)

Replace the two highlighted portions with the value from the dynamic content picker that stores the value. I think you also need to add 26 instead of 25 to account for a space after the search string. If not, then you can adjust 26 to what works.