Lookup Function with ability to enter value

(0) Share

Report

Posted on by NP-18101421-0

227

Hi,

I have a gallery where there is a value that uses a lookup function. Here it:Lookup function or vlookup? was solved. I just wanted to know how I can adjust the formula for the per diem rate to allow me to manually enter a value if the per diem rate is not available in the excel file.

Condition I want to satisfy:

IF the Location of Event field is not blank, then allow user to manually enter per diem rate, else, look up the per diem rate based on zip code and required meal from the Excel File.

Gallery:

Formula for Per Diem rate:

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

NP-18101421-0 227 on at

Like (0)

Report

Re: Lookup Function with ability to enter value

Thank you that worked!

I used the modern control text input - which doesn't have a default property. That is why it wasn't working. Appreciate your help!
Verified answer

scalca on at

Like (0)

Report

Re: Lookup Function with ability to enter value

I did not fully understand your issue here
nevertheless, your per diem field should be a text input control which allows the user to enter something in case needed.
you can use the If(IsBlank() function in order to check whether the location has a value or not in case it is blank then get the value using the lookup and switch function you've mentioned in the Default property
I would also change the displaymode of the field in case you get the value dynamically to DisplayMode.View or Disabled
to prevent unwanted changes by user
again use the If(IsBlank() function to check which path to follow in order to change displaymode.