delete rows with a flow, error in table

(0) Share

Report

Posted on by antonio_piernav

125

Hi, I hope someone can help me ...

I have created a flow that gets rows of an Excel table connected to "powerapps" and inserts them into another file of my onedrive, until here it works well, when I add the function in the flow to delete rows of my first file the error occurs, it clears them if, but loses the table format or some error occurs because afterwards powerapps can not save the data in that table.
What am I doing wrong?
I have also tried to erase the rows from powerapps with the formula removeif but the same thing happens.

How can I delete rows with a flow without losing the format of the table?
Thank you very much for the help

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @antonio_piernav,

Could you please share more details about the Excel table, and the error messages?

I tried to remove rows for Excel table in PowerApps, then add new data into that table, there is no error messages popped out.

Mostly I think this should be related with the Excel table itself. Pleas take a try to create a new Excel table and see if the error message insists.

For some known issues, please see:

Generate an app from Excel data

Regards,

Michael
Jasonkatz424 71 on at

Like
a
(0)

Report
Copy link

Link copied!

I believe the poster is referring to excel deleting all rows, including the top row which may be the header. With no rows, excel no longer recognizes the table.
dave-jorgensen 502 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I agree, that that likely is the issue, since I ran into the same issue myself - deleting all rows deletes the header row, after which the table no longer exists. Which really is a nasty bug. Makes 'delete all rows' unusable. My 'work around' was to filter out the header row when deleting rows.