Answered

split function not recognized

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I was wondering why my split function doesn't work. I'm building my first flow
My goal for my power automat flow would be to convert the following text that i receive daily via e-mail to an excel sheet.

The part I'm struggling with at the moment is splitting the text from this e-mail at the comma's.
I tried to follow all the steps in this thread Solved: Re: Split String - Power Platform Community (microsoft.com)

but for some reason the result of the following data operation

is just the string "Split('1-2-3-4-5','-')". as if it doesn't recognize the function.
Something remarkable is that power automate also doesn't recognize the function split() if i type it and i can't find it back under data operations.

Nor can i find it by searching for the split function

Has this something to do with my license (I run power automate free). I searched online but i could not find what is included in which license.

Any help regarding the matter why I'm not able to run the function split is greatly appreciated.
Sincerely Karzos

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

srApps 306 on at

Like (2)

Report
Copy link

Link copied!

When you click on the inputs field in Compose, make sure you go to the 'Expression' tab that appears in the window and put your function there, then 'OK'. It will add it to the input correctly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey srApps,

Thanks for the quick response, When i add a compose element i don't have te option for "add dynamic content"
Do you know why that could be the case,

Thanks in advance for your help,

Was this reply helpful? Yes No
srApps 306 on at

Like (1)

Report
Copy link

Link copied!

When you have the cursor in the Inputs field and can type in it, you don't see the popup window seen in my first post? It could look different if you have a setting to enable Experimental Features and it would look like this instead. If it isn't there at all you may just need to save and close the browser window and come back. I've had the dynamic content/expression window not appear before.

Was this reply helpful? Yes No