英文:
Invalid syntax in sharepoint list filter of power automate action
问题
以下是已翻译的内容：
我创建了一个小的Power Automate流程。它通过传入的电子邮件触发，并应该使用发件人的电子邮件地址来处理共享表中的行。该表的一列名称为“E-Mail”。流程和筛选条件如下所示：
这是错误消息：
表达式“E-Mail eq 'donald.duck@gmail.com'”无效。创建查询失败。
clientRequestId: d5371e22-1551-49f3-b539-0ecc3bd1881f
serviceRequestId: d5371e22-1551-49f3-b539-0ecc3bd1881f
{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "GetItems"
},
"parameters": {
"dataset": "https://btbgmbh658.sharepoint.com/sites/devtest",
"table": "810454a5-24fe-477e-b19e-28e3a702ba4f",
"$filter": "E-Mail eq 'donald.duck@gmail.com'"
}
}
（这里我使用donald.duck@gmail.com作为占位符。列表包含有效的电子邮件地址，正在处理的测试电子邮件来自该地址）。
SharePoint列表确实包含一个名为“E-Mail”的列。如何修复这个问题？
英文:
I have created a small Power Automate flow. It gets triggered by incoming emails and should use the sender's email address to process rows from a sharepoint table. One column of that table has the name "E-Mail". The flow and filter within look like this:
This the error message:
The expression "E-Mail eq 'donald.duck@gmail.com'" is invalid. Creating query failed.
clientRequestId: d5371e22-1551-49f3-b539-0ecc3bd1881f
serviceRequestId: d5371e22-1551-49f3-b539-0ecc3bd1881f
{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "GetItems"
},
"parameters": {
"dataset": "https://btbgmbh658.sharepoint.com/sites/devtest",
"table": "810454a5-24fe-477e-b19e-28e3a702ba4f",
"$filter": "E-Mail eq 'donald.duck@gmail.com'"
}
}
(I am using donald.duck@gmail.com as a placeholder here. The list contains a valid email address and the test email being processed is coming from that address).
The sharepoint list does contain a column named "E-Mail":
How can I fix this?
答案1
得分: 1
在 OData 过滤查询中（Abfragen filtern 使用这些类型的查询），您需要使用列的内部名称，而不是显示名称。
您可以以不同的方式检索该内部名称。例如，尝试使用列设置，如在以下文章中所述：
https://elliskarim.com/2021/12/20/finding-the-internal-name-of-a-sharepoint-column/#method-1-column-settings
英文:
In OData filter queries (the Abfragen filtern uses those type of queries) you need to use the internal name of the column, not the displayname.
You can retrieve that internal name in different ways. Try for example the column settings, like described in this article:
https://elliskarim.com/2021/12/20/finding-the-internal-name-of-a-sharepoint-column/#method-1-column-settings
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论