Share
ReportI am working on a canvas app to organize bank client guidelines that we work with. The guidelines often have some specific caveats, i.e. minimum credit score required is 680 however if a customer has over 12 months reserves they will consider it, others would make the same exception but only if the loan is under 200,000 and in a specifici county. some will lend out of state but if so the credit score is required to be 720 etc... I already have multiple yes no columns and number columns for what clients will basically accept and I was really hoping to give myself 3 or 4 text fields to populate with a specific formula for the client. Is it possible to give a table record a specific formula to be used in a powerapp based on a text field, each record would have a few caveat text fields that would allow me to make these specific tweeks without creating dozens and dozens of columns.
For example I would have the following text on one clients Caveat1 field for their specific situation- If(ThisItem.PropType = "Condo" && ThisItem.Reserves >2 && ThisItem.Reserves<= 6,"Condos require 6 months reserves", "")
All responses (
Answers (
156,386
