Answered

Issue with using @split function to create an array

(0) Share

Report

Posted on by 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:

Screen Shot 2019-12-16 at 7.12.48 AM.png

Screen Shot 2019-12-16 at 7.14.49 AM.png

Screen Shot 2019-12-16 at 7.15.55 AM.png

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
deltaformtech 55 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@manuelstgomes

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

'#'

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
deltaformtech 55 on at

Like (0)

Report
Copy link

Link copied!

Hi @manuelstgomes , @ScottShearer ,

I enter @split(triggerBody()['ProcessImages_Inputs'],'#')
into the expression box and still receive the "The expression is invalid" message. Thoughts?

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
deltaformtech 55 on at

Like (0)

Report
Copy link

Link copied!

Hi @manuelstgomes ,

😅Thank you!! That did the trick!

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No