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
Try putting the Outputs within single quotes. Example:
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
I received:
The error now is:
Regards
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
66 | |
23 | |
16 | |
16 | |
13 |
User | Count |
---|---|
116 | |
35 | |
32 | |
28 | |
26 |