@Razixs
Hi, based on what you have stated you are doing the only two options you have.
I would however need to review your Flow to see about optimizing it. From a processing perspective, since you need to query the rows you want, it will need a loop.
However in the loop its possible to turn on Concurrency and process more than 1 row at a time, which would speed it up. BUT there are caveats, which is why I would need to see your flow. (The Scheduled one)
However, have you looked at making the one column a Calculated Column so it changes to true based on the other column automatically?
Also how do they interact with this List? is it via an App or a Form? Something that would allow you to set the value based on their interactions with creating the data, versus a flow?
If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
