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
Super User
Super User

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,603)