Forum Discussion
Help - Power Automate / SharePoint: ODATA Filter Query with coustum value in Get Items not working
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.
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.
