Unanswered

Excel sheet is empty

(0) Share

Report

Posted on by sjmiller11

I am trying to build my first Power Automate. I have a Microsoft Form that I want the responses in Excel. I have a very simple flow

but the data is not populating in my excel. I have made sure I have headers in my table, the table is not to large so it can insert, filters are off... and I have a test row of data there for it to insert after in. but its running successfully but not putting the data there?

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

NathanAlvares24 1,714 Moderator on at

Like (0)

Report

Hi @sjmiller11 !

This is my simple flow.

This is my form:

And this is my excel sheet:

So when I enter the data onto the form, this same details should be entered onto the excel sheet.

Output:

This works for me.

Can you please try doing this in the Old designer. In order to switch old designer, click the toggle here

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (0)

Report

Incase if the issue still persists, please make sure that the Excel file exists.

I have this excel file in my OneDrive.

Now when I delete it, this file will be sent to the Recycle Bin.

Here is the catch, I executed my flow, and it still showed success.

This could be that issue if you are facing. That means it is still entering data onto the excel sheet which is in the Recycle Bin.

Try creating another excel file, with the same table headers and re-initialize the data in the 'Add a row into a table' action.

Do let me know if this works or if issue still persists.

Was this reply helpful? Yes No
sjmiller11 16 on at

Like (0)

Report

nope does not work? I can get it to populate a sharepoint list....

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (0)

Report

Hi @sjmiller11 !

Can you provide a screenshot of your 'Add a row into a table' action by extending it? And also if possible the excel file with the table?

Just bar out any sensitive information before attaching it here. I want to understand why its not working for you.

Was this reply helpful? Yes No
sjmiller11 16 on at

Like (0)

Report

i also tried to do to shraepoint and it works to share point, but then when i created a flow to make the sharepoint a csv file it stays it runs, but no csv file shows up on my one drive

Was this reply helpful? Yes No
Verified answer

NathanAlvares24 1,714 Moderator on at

Like (0)

Report

Hi @sjmiller11 !

As I can see in this image, there is already existing rows here in this table. Can you scroll right to the bottom of the end of this table and see if there is data there?

Because I did the same test and I got the data at the end of the table. This is what Add a rows into a table action does actually.

So I am guessing you just deleted the data using Delete key? If yes, I suggest not to do that.

You can see those empty rows, Add a rows into a table action does not check if there is data there or not. The function is to simply add a row to a table whether it has data or not at the end of the table.

So if you are doing any testing, you need to delete the rows of that table permanently. Just right click and select 'delete rows'

And then it should look like this:

Dragging the thing marked in red up and down will make the size of the table. And now currently, I just have one row in my table since the first row 1 is my headers.

So now if I run my flow, it should add the second data on row 3 only when I give the details to the form (or I use the previous trigger),

Do let me know if this works now.

Was this reply helpful? Yes No
sjmiller11 16 on at

Like (1)

Report

That was it! How simple!

Was this reply helpful? Yes No