Next create an app and in the example I created, I added a list. Set the source of the list to the above created table. Show the Approver and Amount columns in the list. I have made the Amount editable, which means an app user can change the amount.
Thank you for the time and effort you put into this explanation. It is excellent if I simply wanted to hide the approver if the amount was less than $500, but what I'm trying to do is keep the existing workflow shown in the template. The only change is to automatically add an additional approver if the amount is over $500.
If Item is under $50 = Auto Approve (The template is already set up for this)
If Item is over $50 = Approval required by Department Head (The template is already set up for this)
If Item is over $500 = CFO is automatically added to approval list regardless of department
The addition of the CFO could potentially be 3 or 4 approvers down the line.
The trigger for the automation is still change in the status tracked by the [Status] column. This expression I provided performs additional checks to make sure the automation will only run when all of these conditions are true.
Yes, the action would be to update the Approver to your CFO. If this a single person, then you can directly update it from the automation rather than reading it from a table.
Please let me know if you have additional questions.