(First attempt) Failing to pull excel row into an Array

[William382]

**I'm very new at this.  I understand basic programming.  Please be gentle as I'm figuring out how to get these things working, pics and lables..

I was successful pulling one row from excel and adding to a planner.  But I tried to expand to include an array and broke all of it.  

Background - Looking at onboarding, using an excel sheet our HR person updates that runs a scheduled task on every few hours and updates a column and starts a flow.  The flow starts with pulling those rows and sending them out via Email to departments, 2 in testing now. I had this working before I setup for > 1 new person, but I'm confused about how to best structure the array using the web interface.  

Steps(pics below):

1.) Initialize variables (Works)

2.) open a document on sharepoint and pull rows with today's date. (Works)

3.) Adds those to an Array - this will eventually need to be used to create multiple tasks, but I can't pull more than 1 person and my array is always empty after running.

Run will always complete.

I don't understand what output is pulled from other step for the Apply to Each, I thought it's pulling rows with today's date.  I am 100% seeing data before the "Apply to each" step.  I tried to put the actual array in Apply to Each and still am not seeing anything

Issue: my array's are coming back empty, nothing is failing.  I had this working once, and it's how i'm structuring things, I'm sure.  I had them working a little bit ago.

https://imgur.com/aeFNzaw

https://imgur.com/3tCzW1E

[yashag2255 · Accepted solution]

Hi @William382 

In the screenshots that you have shared, you are using the Get a row action and this returns a single row. You might want to use the list rows present in a table action to get multiple rows at once and then that output can be used on the apply to each. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!