I am struggling with a Get Items Odata filter that keeps returning Column xxx does not exist.
Scenario:
Switch gets email address from a different SharePoint list based on the value of a choice field in the newly created item.
1. Set variable to the choice value from the newly created item, (used in step 3).
2. Switch between the selected values.
3. Case runs a Get Items to obtain the data from the 2nd SharePoint list. Odata query fails here. Not sure why it's looking for a column rather than comparing the values. I did try setting the variable using the String() method, same error.
The Images below are each step (configured and after the run)
Solved! Go to Solution.
Even though you are using a variable, you need to add single quotes in the OData string around the variable.
Title eq 'dynamic variable'
Even though you are using a variable, you need to add single quotes in the OData string around the variable.
Title eq 'dynamic variable'
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
42 | |
38 | |
37 | |
35 | |
25 |
User | Count |
---|---|
39 | |
36 | |
33 | |
31 | |
26 |