cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mhorian
Frequent Visitor

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

Hi all, 

 

I have created a  Form with the following questions:

 

mhorian_3-1628014248068.png

 

mhorian_4-1628014264023.png

 

The responses are collected with a flow in a sharepoint list:

 

mhorian_2-1628013223615.png

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:

 

mhorian_6-1628015665200.png

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

 

mhorian_9-1628017053594.png

Then I want to get only the item where Area is 614_1 with a "Get Items" and  a filter query 

 

mhorian_0-1628018393760.png

 

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

2 REPLIES 2
ekarim2020
Community Champion
Community Champion

Try putting the Outputs within single quotes. Example:

ekarim2020_0-1628019196736.png

Ellis

 

 

 

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

 

mhorian_1-1628021502218.png

 

I received:

 

mhorian_0-1628021429183.png

 

The error now is:

 

mhorian_2-1628021580095.png

 

Regards

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,837)