Hi all,
I'm having trouble finding the solution to the following flow. My solution is attached but not working because I cannot reuse the 'current item' for the apply to each in the delete the row step.
We have a Sharepoint Online List and an export to Excel is needed to update the dataset of the belonging power bi report. The Excel is already existing and connected to the Power Bi dashboard. Connecting the Sharepoint list to the Power Bi dataset would be too much work for now, so we preferred to export the lines to Excel.
After updating the dashboard, the lines are no longer needed in the Excel file so I need to delete them from the table.
Since I can't reuse the 'current item' from the first apply to each step, what would be your solution for this flow?
Thanks in advance guys!