web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Using split function

(0) ShareShare
ReportReport
Posted on by 41

Hello,

 

I am creating a flow where an e-mail received is converted to text in order to save the required values to database.

I am stuck using the split function to get the values for  Daily Energy, Lifetime Energy and Daily Income from the lines below. 

Can anyone help me please ?

 

"Daily Energy Yield:2925.84 kWhLifetime Energy:6040139.42 kWhTotal",

 

"kWhDaily Energy Yield:2925.84 kWhDaily Income:438.88 EURTotal Income:900762.65",

Categories:
  • Verified answer
    rrovira Profile Picture
    Microsoft Employee on at

    Hello @SammutW!

     

    I think the first thing I'd do would be to remove those extra words (kWh and EUR), but I'm not 100% sure if you need them. If you can remove them from the string, then you could use the replace function: Power Automate: replace Function - Manuel T. Gomes (manueltgomes.com).

     

    After this, you could split the string using the ":" as the reference, leaving you with:

     

    Daily Energy Yield
    2925.84

    Daily Income

    438.88
    Total Income
    900762.65

     

    Let me know if this gives you an idea on how to start your flow! 

    Cheers!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 298 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard