Get SPO list item depending on a form's answer to a question

[mhorian]

Hi all, 

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 

Marina

[ekarim2020]

Try putting the Outputs within single quotes. Example:

Ellis

[mhorian]

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

I received:

The error now is:

Regards