Lookup issues wiht initial value

[sebaspindu]

Hi, 

Im trying to use a lookup function when a previous answer is collected in my form 

when i test the formula Im getting a result but when filling up the form the lookup is coming in blank, Im using the formula in more than 50 columns, not sure if this can affect the outcome. 

[Steve]

---

@sebaspindu wrote:

when a previous answer is collected

---

I don't understand what you mean by this.

---

@sebaspindu wrote:

Im using the formula in more than 50 columns, not sure if this can affect the outcome. 

---

The number of columns is not a problem.

[sebaspindu]

Hi @Steve ,

Sorry if I wasnt clear, Im still fairly new to the community. I have a from where based on answer dorpdown wiht 2 options I allow the user to either provide the inputs for teh rest of the form or do a lookup from another table to get teh values.

Im using a Formula in the initla value to accomplish this:

 IF([Plan Type Text]="AUTOPILOT", LOOKUP([_THISROW].[Industry-Investment], "AUTO PILOT LOOKUP", "Industry-Investment", "Meta"), 0)

If the user selects auotpilot in a prevoius question then look up formula will happen if not just leave initla value as 0.

When I test this I see it working as in the SS above but when actually geting the form filled out the lookup values are coming as blank. 

Im tryign to understand why the lookup formula is not working adn if there is perhaps a better way to accomplish this task.

Really appreciate any recos here.

[Steve]

The Initial value expression is only used when a new row is added, not when you update a row that was added previously. Is your problem happening when adding a new row?

[sebaspindu]

yes the issue is happening when there is a new row added. For additonal context whe the user selects Plan Type Text]="AUTOPILOT the form columns where the lookup formula is placed are not visbile to the user., but rather I wnat to get th lookup values for that particualr new row

[Steve]

Looks like you're going to have to do some old-fashioned debugging, then. Break your expression down to its component parts and test each part separately to make sure each works as you expect. Test each part in the app, not just in Expression Assistant.

[Plan Type Text]="AUTOPILOT"

IF([Plan Type Text]="AUTOPILOT", 1, 0)

LOOKUP([_THISROW].[Industry-Investment], "AUTO PILOT LOOKUP", "Industry-Investment", "Meta")

Make sure the LOOKUP() expression always produces a numeric or blank result. 

[sebaspindu]

Hi Steve, 

So I went ahead test out as you recommended and foudn the IF statement wokring but I can not get the Lookup to work is retunring an empty value although in the table data test is showing the correct amount.

For more context the Column 

[Industry-Investment] is a virtual colum 

Can this be affecting the overall result?

I wonder if you any suggestions into how to accomplish this a differnt way. Really appreciate the support !😊

[Steve]

Does the Industry-Investment column have a value? Please post a screenshot of its App formula expression.

[sebaspindu · Accepted solution]

@Steve  after a lot testing a figured it out, the issue is I was ussing a virtual column as serach in my lookup experssion I changed this to an actual column with a formula and voila ! definetly something that should be included in the documentation.