Automatic sorting of table before refresh PQ

Hi.

I am using Power Query to make a to do list.

I am having a master list with the deadlines (monthly/weekly). This master is unpivoted to create the to do list. Unique id for each task would be ID + week.

People are allowed and should filter and sort the list as they please. When a job is done they will mark it done (check box).

But sometimes there will be new tasks in the master and the query needs to be updated. The sorting will make the markings and comments jump so I will need to make sure it is sorted correctly before updating.

Is there a good way to this. I have tried the copilot, but it was not to much help…