Question

how can i filter with dymamic string

0

You're loo You're looking for a way to query data based on a dynamic string, for example, in table A with fields ABC, DEF, and GHF. The query should allow you to fetch ABC, DEF or ABC, GHF based on the string passed.

asked 2025-01-15

Toan Hoang

1 answers

Rene van Hofwegen · Accepted Answer · 2025-01-15

It depends on what the source is of the string passed

In any case, the string value should be captured in a variable before the retrieve action.

This variable can be used to express the string value of the contains function.

This variable can be of type Object. In case a user expresses a value in a input field on a page. Hence you do have a dataview with an object and attributes you pass into this microflow.

Then the expression would be $NameOfTheInputVariable/AttributeUsed

Or this can be an object as a result of a previous microflow action (retrieve, create, rest service call, ....) Then the expression would be $NameOfTheActionResultVariable/AttributeUsed

Or this can be a string variable as a result of a previous action

Then the expression would be $NameOfTheStringVariable