Unanswered

Create a flow that will fill the first empty row in the Excel table

(0) Share

Report

Posted on by ilvutchenko

I have an Excel file that contains a table, and Dataverse table from which data is sent to the Excel table. And there is an application that adds a row of data to the Dataverse table.
I need to create a flow that, when adding a row to the Dataverse table, will add this row to the Excel table.
I was able to create a flow that adds a row to an Excel table, but it adds it at the end of the table, resulting in more empty rows before being written.

I also tried the flow option of editing a row in an Excel table, for this I selected the ID column (['Date']) in the value line and set it to null. But the check returned me this option, because ID cannot be empty.

Help me create a flow that will fill the first empty row in an Excel table, rather than adding a row at the end.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-jefferni on at

Like (0)

Report

Hi @ilvutchenko ,

You can delete blank rows from the table using office script before the Add a new row action. Please refer to below blog:

How to Delete Blank Rows in Excel with Power Automate - Power Tech Tips

Best regards,

Was this reply helpful? Yes No
ilvutchenko 10 on at

Like (0)

Report

Thanks for your suggestion, but it doesn't work for me. I don’t need to delete empty rows, since the Excel table is filled in directly, and in it, in some cells, there are formulas for calculations. That's why I have to look for an option specifically with editing empty lines

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @ilvutchenko ,

The thing is, as you have already observed, blank rows without ID value cannot be found in the table.

Best regards,

Was this reply helpful? Yes No