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
Resident Rockstar
Resident Rockstar

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,066)