Hi,
I am trying to make a flow for invoice approval, using Microsoft lists as database, PowerApps and Power Automate. In this flow I have couple of conditions (if and switch).
First condition is did purchase order exist for this invoice? If this invoice doesn't have purchase order, I put as next condition sector (using switch function). There is three possible choices in this case (administration sector, sales sector or production sector).
Within administration sector I have condition for cost center or which department is responsible for that invoice (I am using here switch function as well, because I have 5 different departments within administration sector. For each department we have a manager who is responsible for that cost center). So this is the first step of approval process, manager has to approve invoice. If he approve that invoice then 1st director for administration sector has to approve that invoice as well, and we have last step (3rd one in this approval process) where 2nd director has to approve invoice.
Everything is fine until last step (3rd one) where I have to put IF condition, but I don't see to add action or in this case to update item on Microsoft list.
Do you know what is the reason for that? How many if or switch statements in flow can I have? Do you have some advice how to solve it? Do you have better approach for this problem?
I am asking because if I eliminate step for sector and instead of that step I put immediately cost center everything works fine. But in that case for each cost center I have to make a flow (and we have 36 CC in our company). Since that in production sector we have 22 CC and just one manager in production has authorization to approve invoices, in this step I will have just one flow for production. But in administration I have several managers who can approve the invoice, so I have to include and CC.
Please find attachments.
I hope I was clear and thanks in advance for your help.
Rash
