I am trying to develop an application which should suggest a product model based on the form entries of the users. The end user should fill out a form (a couple of category questions and a numeric input) and as he hits the save button, he should be directed to a specific product model, which will be selected from a lookup table.
How should it work? Let me give you an example: The user enters in the form: Fruit, Apple, Jonadold and types in the weight 120gr. Now the expression should go to my output (lookup) table and compare the concat which is just created in the formentries table and the one in the lookup table and then take the next bigger weight for the boxmodel. So the desired result here is: Boxmodel S
[Concat] [Weight] [Boxmodel]
FruitAppleJonagold 100 XS
FruitAppleJonagold 150 S
FruitAppleJonagold 200 M
FruitAppleJonagold 250 L
VegetableTomatoeCherry 50 XS
VegetableTomatoeCherry 100 S
Until now, I have created an action with a target link with a LINKTOROW expression. User fills up the form and as he hits the Save button, he is directed to Ref View, which he should see the result. The expression I am using is validated but giving the whole entries of a lookup table instead of a single row:
LINKTOROW(SELECT(FormEntries[_THISROW], Output[Concat]=FormEntries[Concat]), “Output”)
I was hoping that this expression should at least give me the rows matching the Concats but I am viewing all of the entries in the table. I also tries expressions with Any Select and Filter but I am not getting desired results.
Here are the tables I have:
This is the table where the form responses are recorded. The options the users are selecting are concatenating in a new column called [Concat] with an initial formula.
This is a lookup table in view only mode (with a Ref View on UX) where I have a column [Concat] which will be compared with the FormEntries later. This is my main reference table to indicate which will be the right model for the selections made based on the concat.
Here are my views:
This is the form the user is supposed to fill in, of course in form type. This is the only visible UX, others are ref views. Data source is the FormEntries table
This is a ref view with the data source with the same name
For a record of this table: FormEntries
Do this: Go to another view within this app
Target: LINKTOROW(SELECT(FormEntries[_THISROW], Output[Concat]=FormEntries[Concat]), “Output”)
Can someone help me with the right expression?