Forum Discussion
Help - Power Automate / SharePoint: ODATA Filter Query with coustum value in Get Items not working
Hello,
I tried to make a filtered Get Items Function based on another List, so that it will only give out the items in which the valur of this column is the same. I tried a few options and I do think this should work, but it doesn't.
Has anyone an idea why or what to change to make it work?
Here is what I have done:
And the Error:
Thanks in advance
You have to use the internal name of SharePoint list columns in the filter queries.
You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?
Use the correct column name in filter query.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
3 Replies
You have to use the internal name of SharePoint list columns in the filter queries.
You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?
Use the correct column name in filter query.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Thanks ganeshsanap
Doing that, the Error now states that Type Note cannot be used for qerys, I guess that's because of multiple lines text are allowed in that column. (Since I don't run SharePoint in English, I do not know if that option is called notes in English and I just used it for readability.)
Setting it to single line text, it is accepted. (Just for future notice)
Yes, correct. "Multiple lines of text" columns are not supported in Filter queries.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
