cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nehry
New Member

Flow Expressions on PowerAutomate Desktop?

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
VJR
Super User
Super User

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.

 

 

VJR_3-1646821722529.png

 

 

 

 

VJR_2-1646821672238.png

 

 

View solution in original post

7 REPLIES 7
jinivthakkar
Super User
Super User

@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
Super User
Super User

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.

 

 

VJR_3-1646821722529.png

 

 

 

 

VJR_2-1646821672238.png

 

 

UK_Mike
Post Prodigy
Post Prodigy

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

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? 

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.

 

VJR_0-1647578380264.png

 

Hey VJR,

 

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

 

Thanks so much for the solution. It now works. 

Great to hear that.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,566)