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'
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.