i would like to create a power automate sales quote approval to have different group of approval based on GP% (this is custom field)
and i want the workflow routing as below
GP % > 50% ==> approver A
GP% between 0%-50% ==> approver B
GP% < 0% ==> approver C
think of create 3 separate power automate flow to filter the GP% based on above
Above flow is working but i am unable to access custom field GP% in trigger "When a sale document approval is requested", i have created custom API in 2nd stage Get Records am able to see the GP% field in subsequent stage but i think i will need to filter the GP% during the 1st trigger stage.
How should i go about this ?