Flow Expressions on PowerAutomate Desktop?

[nehry]

Hello,

I want to use Power Automate to automate some information from my outlook onto a spreadsheet via OneDrive Excel. The problem is, i want to extract the subject of emails but I only want to extract the last 12 characters of the subject because they contain a reference. From what I've seen from tutorials, I'm supposed to use Flow Expressions but that's only doable on the Web version of Power Automate. Is there a way for me to do it on the Desktop Version instead? 

If not, what are the other alternatives? 

[jinivthakkar]

@nehry not an expert in PAD just trying to help, see if Get SubText action helps?

https://www.youtube.com/watch?v=GLPROTFfCdE

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[VJR · Accepted solution]

Hi @nehry 

Not a bit straightforward to go from the back of the string and pull the characters, but below is something you can do.

You can make changes to the below keeping in mind that index starts from 0.

[UK_Mike]

Regex could work, if we knew the string...😁

[nehry]

Hey VJR,

Thanks for your solution, just trying to add the %Subject.Length-12% however it's saying that the variable doesn't have the property Length.

Any reasons why? 

[VJR]

At first just get the length, remove the minus 12 and check with display box.

Looks like you are storing something else in Subject.

There is a Length property available if it holds a text value.

If you are not seeing this then you are using an incorrect variable to get the length.

[nehry]

Hey VJR,

Thanks for that, I was able to figure out based on your help. 

Thanks so much for the solution. It now works. 

[VJR]

Great to hear that.