Unanswered

split an array

(0) Share

Report

Posted on by TarekEzz

hey everyone, am new to power automate I have a flow where it takes from email and extract a table then a change the table into array in order for me to store it into action ( add a row into a table) when I try to use the expression " outputs('split_array')[1] to pick the second team in my array it never worked. i tried to change my method and make into items but and it worked , but I couldn't pick the team I want into my excel table. the flow work fine and outputs come right but never be able to store them into my excel the flow always fail in the excel action hope anyone could help me thank you and much appreciated

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @TarekEzz,

Please, post screens of your flow : flow design, flow result and error

Was this reply helpful? Yes No
TarekEzz 16 on at

Like (0)

Report
Copy link

Link copied!

Oright,
btw : there is some issue regarding the email when it send ( I tired to add '?' so it skips if there is no element in the array ) so I can check the rest of the flow , but It spam emails , am not sure where should i put action of send the email, i tried to make out of the loop but it aways will stop at the loop and never reach to the email action if is out side of the loop .
(for update) my array after extracting from the table and split " it always come with one element and that element will include all the details in the table "

here are the screenshots .

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @TarekEzz,

Okay, you're trying to pick second object in an array that contains one or less using index, that way to do is not safe. Consider using first(skip( outputs('split_array'),1)) to pick the second team if exists. It will either return the object if exists or null. It won't throwing any error.

skip(array, 1) ignore the first object and fist() take only the first one. That'll ensure you'll get the second object in an array that may contain more than 2 objects and will return null if it contains less than 2 objects.

however, you should have a look at you input data, there is no second team in this apply to each loop, Your array has at best 1 element.

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No