Answered

Flow Expressions on PowerAutomate Desktop?

(0) Share

Report

Posted on by 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?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
nehry 8 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
nehry 8 on at

Like (1)

Report
Copy link

Link copied!

Hey VJR,

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

Thanks so much for the solution. It now works.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Great to hear that.

Was this reply helpful? Yes No