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?
Solved! Go to Solution.
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!
"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:
This is what I have in my excel: This is what was read in PAD.
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.
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.