Power Platform Community Forum Thread Details

I have created a form and needs a formula that checks if the input amount does not exceed the "limit". We have 2 sharepoint list. The limit and balance sharepoint. So when user click submit, it should check if the value in this expected maximum exposure field does not exceed the "limit". To get the limit, If user selected bank in the form and put the expected max exposure, form should lookup the limit table based on bank and Currency of USD, and subtract to Balance tab based on bank and currency. Expected Max exposure < limit - balance. If max exposure is greater than limit - balance, user should not be able to submit and gets message.