I'm new to applying power automate, so apologies if I am missing obvious insights.
I am looking at typical business process management flow where one user provides data on a new project. This process then moves to the next user from another user role to review and add their piece of information such as Financial Accounting Capex number and finally a third user from yet another user role to review and approve the creation of the project.
Is this something that can be achieved using Power Automate Business Process Flow?
I would say this is exactly what BPF is supposed to be used for. I tried BPF in a model-driven in a similar 'workflow-managment' scenario where a data-item moves from stage to stage where at each stage a person with a specific role has to do some task and deliver the data.
For your scenario the stages in the BPF would be like: 'init', 'accounting', 'final review'.
You could hard-code the users responsible for each stage or you could let it be set by the process itself. You can then attach a cloud-flow that is triggeret by the BPF-related table to notify each person when they recieve a new item.