使用电源查询，如何将Exchange数据源限制到特定的电子邮件文件夹

发布于 2025-01-31 15:35:02 字数 473 浏览 2 评论 0原文

我正在寻找的是限制查询范围的一种方法。获取所有帐户，然后导航到邮件和过滤我的需求不是问题。问题在于，这样做可以将超过28 000封电子邮件拿走。

这是M代码的开始：

let
    Source = Exchange.Contents("[email protected]"),
    Mail1 = Source{[Name="Mail"]}[Data],
    #"Other Column deleted" = Table.SelectColumns(Mail1,{"Id", "Body", "Categories", "DateTimeSent"}), 
    ...

任何想法都受到欢迎。

原文

What I am looking for is a way to limit the scope of the query. Getting all the account then navigating to mail and filtering on what I need isn't a issue. The issue is that doing it pulls over 28 000 emails for nothing.

Here is the beginning of the M code :

let
    Source = Exchange.Contents("[email protected]"),
    Mail1 = Source{[Name="Mail"]}[Data],
    #"Other Column deleted" = Table.SelectColumns(Mail1,{"Id", "Body", "Categories", "DateTimeSent"}), 
    ...

Any idea is welcomed.

分享到QQ

分享到微博