Power Automate should include the ability to visually preview the run, showing the first couple of hundred results simulated so you can verify that mapping and formulas are right before running the job. This would significantly save time and help avoid issues