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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,759)