I have created a Form with the following questions:
The responses are collected with a flow in a sharepoint list:
With the following logic:
Depending of the selection in Question A, Question's B and C outcome should be calculated according to the following SPO list and field Category:
So if the Area selected in form's Question A has Category value less than 4, the Question's B outcome is calculated as:
For selection in Question B: Exceptional --> 0.1*4
For selection in Question B: Fair --> 0.1*3
For selection in Question B: Poor --> 0.1*2
For selection in Question B: Very Poor --> 0.1*1
If the Area selected in form's Question A has Category value more than 4, the Question's B outcome is calculated as:
For selection Exceptional: 0.15*4
For selection Fair: 0.15*3
For selection Poor: 0.15*2
For selection Very Poor: 0.15*1
In the same way Question C outcome is calculated based in the Category value, etc.
In the flow I have tried to retrieve the item from the list Categorization by first creating a variable to collect the response for Question A
Then I want to get only the item where Area is 614_1 with a "Get Items" and a filter query
Since the Area is not a number it seems that I cannot find a way to collect only the specific item and the flow fails with error
The expression " eq Code" is not valid. Creating query failed.
I have tried to use the field ID instead "Field=_x039a__x03a9__x0394__x002e_" with no luck.
Can you please help me?
Thanks - Regards
Now the message changed:
Column 'Code' does not exist. It may have been deleted by another user.
Change from column name to field id: _x039a__x03a9__x0394__x002e_
and again received:
Column '_x039a__x03a9__x0394__x002e_' does not exist. It may have been deleted by another user.
When I configure the filter query
The error now is: