ヒント:
Filter 関数の動作について理解を深めるには、「使い方」セクションの「Apps を Data Service と使用する」をご覧ください。
この関数を使用すると、フィールドに基づいて表をフィルター処理できます。
This function performs a case insensitive check.
ヒント:
Depending on your project's needs, you can choose to exclude certain conditions when using the Filter function. To exclude a condition, you can write an expression that resolves the filter field (first parameter of the condition array) to a
null
. For example, you can use the following:
Filter(Customer, [If(IsBlank(Dropdown.Value), null, City), "=", Dropdown.Value])
In this case, the filter on City is only applied when the Dropdown contains a value other than blank.
引数
Argument | Type | Description |
---|---|---|
Entity | Required | The entity to search (for example, a control's data property). |
Condition | Required | The condition used to lookup for in the entity. The format for the Condition argument should be as follows:[Entity Field, Operator, Value] The following operators can be used: contains not contains startswith endswith = != > < >= <= in not in |
例
Filter(Customer, [City, "=", New York])
: 読み込まれた表には、ニューヨーク市の顧客に関する情報だけが表示されます。
3 か月前に更新