You’re offline. This is a read only version of the page.
39
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",
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!
Share
Report
All responses (
Answers (
