web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Using split function

Power Automate - Building Flows

Answered

Using split function

(0) Share

Report

Report

Posted on by SammutW

32

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",

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

rrovira Microsoft Employee on at

Like (1)

Report

Re: Using split function

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!

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 666 Super User 2025 Season 2

#2

Tomac 382 Moderator

#3

developerAJ 254

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans