Issue with using @split function to create an array

[deltaformtech]

Hi,

I'm having issues with passing a collection of images from PowerApps to Flow and splitting a large string into an array. I receive the following error:

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('ProcessImages')' is of type 'String'. The result must be a valid array.

Here are images of my Flow:

[manuelstgomes · Accepted solution]

Hey @deltaformtech 

Your formula is correct but you're putting it as a string and not an actual formula. Hence the message. Power Automation gets the string of the formula instead of the result of it. You don't need the " in the formula.

Please include it here:

Makes sense?

If you need further assistance please let me know

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[deltaformtech]

Hi Manuel,

You're response makes sense, however, I am still experiencing an issue.

When I attempt to input the formula: @split(triggerBody()['ProcessImages_Inputs'],#) into the Expression box, I see the following:

Am I still missing something?

Greg

[manuelstgomes]

Hi @deltaformtech 

In the formula put "#" instead of just #

It will work with that.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ScottShearer]

@manuelstgomes 

Did you mean to say to put single quotes around the # :

'#'

[manuelstgomes]

Yep single quotes indeed!!!!! Thanks @ScottShearer 

@deltaformtech  does it work for you?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[deltaformtech]

Hi @manuelstgomes , @ScottShearer ,

I enter @split(triggerBody()['ProcessImages_Inputs'],'#')

into the expression box and still receive the "The expression is invalid" message.  Thoughts?

[manuelstgomes]

HI @deltaformtech 

When inserting in the formula remove the @.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[deltaformtech]

Hi @manuelstgomes ,

😅Thank you!! That did the trick!

[manuelstgomes]

Hi @deltaformtech 

AWESOME!!!!!!!!!! Glad to hear it.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel