I have Smart Object named ExpenseDetails which have some of the columns named Department Name, Expense Type, Minimum Amount and Maximum Amount.

I have Approval Amount field on my InfoPath. I need to know based on my Approval Amount which Department will approve it.

I set Rule on Approval Amount field that once user enters it will trigger the rule and get the Department Name.

For finding Department name based on Expense Type it worked well. Below is the list of Actions I used for same.

1) Set Field's value Expense Type ( Smart Object Field ) : "Expense Type ( On InfoPath Form )"

2) Query using a data connection : "SmartObejct Connection Name"

3) Set a field's value : Department Name ( On InfoPath ) = Department Name ( From Smart Object )

For getting data based on Approval amount below is the logic but its hard to prototype in InfoPath

1) Expense Type ( On Smart Object) = Expense Type ( On InfoPath )

2) Minimum Amount ( On Smart Object ) < Approval Amount

3)  AND Maximum Amount ( On Smart Object ) > Approval Amount

4) OR Minimum Amount ( On Smart Object )  = Approval Amount

Basically I want to pass value from InfoPath and it checks the Range from SmartObject Data

I am looking for codeless solution for InfoPath as I cannot write code in my current environment.

Any help will be appreciated