Validate Data in another list before Submission

Unfortunately , the lookup function only alows 1 parameter to search.

You can write some javascript to read your item with SharePoint REST service.

There are many samples here.

If Stage is not a lookup/choice field (text column connected to a choice form control) you could add a calculated column in the Delays list for <ID>_<Stage> and use this as a filter; it can be made hidden in the list's advanced setting to manage content types.

Thanks Jean,

Th issue with Lookup is it just return One Item. I need to do a query on all related Barrier to see if the're removed.

Thanks Fernando,

I'm doing some search about this!

Thanks Fernando,

I'm doing some search about this!

I need to do a query on  Stage, Barrier Removed? and Master Id.

what's the difference between 'Stage' and 'Master ID'?

it seems from your description they both identify the same master record. so you need not to filter by both.

so you're left to filter just by two fields, by (eg) Master ID and BarrierRemoved.

having just two fields to filter by you could handle it as follows

InArray(lookup('DetailList','MasterID',CurrentMasterIDInMasterFormNamedControl,'BarrierRemoved',true),'No')‍

so, if for given MasterID there is at least one item with value NO in field BarrierRemoved, the formula evaluates to true