cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bradt30h
Helper III
Helper III

Read from Excel worksheet - Only first line is captured

Hi All,

 

Recently, I build a flow that captures data from Excel. In my Excel, I have data stored in multiple lines. However, PAD read from excel action doesn't capture line 2 and so on. Any ideas to fix this?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

It's definitely there, you just can't see it.  I just ran a test and the first row for "MonDetail" shows all 3 lines.

 

MichaelAnnis_0-1634831433075.png

 

View solution in original post

6 REPLIES 6
MichaelAnnis
Super User
Super User

MichaelAnnis_0-1634741101787.png

Make sure you are in "Values from a range of cells".  Is there a blank row between your title row and your first row of data?  Not sure that this would cause an issue, but I would need to know more to be able to help.  Are you sure it's not pulling data other than the first row?  Or are you trying to call data, and you can't get any data past the first row.  In your variable pane (on the right), right click ExcelData and go to View.  Do you get a DataTable?  Is the data you expect populated there?  If so, the syntax for calling data from ExcelData gets a little complicated, but let's make sure ExcelData is good first.

 

Let me know!

Hi Michael,

 

"are you trying to call data, and you can't get any data past the first row" Yes, this is what I am referring to.

 

Basically, my setting is:

bradt30h_0-1634781937825.png

 

This is what I have in my excel:                                              This is what was read in PAD.

bradt30h_1-1634782013673.pngbradt30h_2-1634782437862.png

 

 

Question 1)  Are gridlines missing?  Is "Test 2" on a second line inside of M2, or is that actually M3?

If "Test 2" is in M2, I bet it's in the MonDetail, you just can't see it.

Question 2)  Are you FirstFreeColumn and FirstFreeRow coming back as you would expect.  You can see their values in the variable pane on the right after you attempt to run the PAD.

 

We will get there.

Hey Michael,

 

Q1- No missing gridlines. It is all inside M2. Hmm let me try to print it out the data from MonDetail

 

Q2 - yes, no issue for this. all the rows and column value are read as what I expected... just that part the of reading data; MonDetail - that value doesn't show line 2 "Test 2".

 

Well, let me try it print out MonDetail somewhere to find out.

It's definitely there, you just can't see it.  I just ran a test and the first row for "MonDetail" shows all 3 lines.

 

MichaelAnnis_0-1634831433075.png

 

As far as I can see, then you are trying to read all data in the worksheet - correct?
If that's the case, then you can do it like this

Highboy_0-1634846411185.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Top Kudoed Authors
Users online (2,036)