Time Tracking and reporting with Power Automate

Since 4 Months I use Excel to track my working hours.
It is a simple intelligent Table where I add current Date, Time, Project im working on and what I am doing. A "duration" column will subtract the entered Time from the Time of the following entry.
Since I jump a lot between Projects this Table helped me a lot to track my time to the Minute.
A Pivot Table converts these entrys in bigger chunks and presents me with an overview how much time was spent on each Project per day. Everything works perfect.

Now I need to send a report of my Time to a co-worker, who will enter it in our ERP Software.

I want to automate this process, so that I don't have to do anything additional to tracking my time. I want to use Power Automate I guess.
I allready tweaked the Overview on a second page, to round the final time track to whole 15 minutes and subtrakt breaks and filter out unnecassary entrys (I always have to enter the End of the Workday with 0 duration, for the last entry before that to caluclate its duration).

I tried to use office scripts to do this filtering for me, but it doesn't work relyable. It will often reactivate allready filtered entrys when adding to the filter.

Do you have some advice how to filter with office scrips in a pivot table? I used Makros before office scripts, and there it worked flawlessly. But Makros can't be used by Power Automate.
And how do I export the final Report Sheet as PDF in Power Automate, without exporting the whole Table with every single dataentry?
I spent hours trying to get this to work, using copilot for coding, but it wasn't very helpfull. Copilot generates error after error.

Edit: I use Excel 365