Hi flow experts, been stumped on this flow built thus far.
Some pre-requisites:
1) Labour Purchase Order (LPO) parent of 2)
2) Labour Purchase Order Line Item (LPOLI)
3) Sales Order (SO) parent of 4)
4) Sales Order Line Item (SOLI)
LPO has a lookup to SO as LPOs are generated off from a SO. Essentially, it is a lookup field looking up to the same object Order.
The requirement is:
1) Build a screen flow that is invoked as a button on the LPOLI record.
2) If there is a matching SOLI in the parent SO (Sales Order record type) record, to sync/assign SO Id and SOLI Id to the LPOLI record.
Where I am stumped is the trying to create containers for both LPOLI as well as the SOLI since they are both the same objects. :/ How do I get records from the child line item as well as the child line item from another parent of the same object type?
Where I am stumped is the trying to create containers for both LPOLI as well as the SOLI since they are both the same objects. :/ How do I get records from the child line item as well as the child line item from another parent of the same object type?
This should be possible with get record
check this
https://developer.salesforce.com/forums/?id=9062I000000IWt2QAG
however if you are using too many queries , ensure you are not hitting the limit
And if it is too complicated , call apex from flow
