Before executing the Execute OQL statement activity, you can define parameters that will be used inside the OQL query. One of these options is Add string parameter. This allows you to safely pass a string value from your microflow into the OQL statement.

When you add a string parameter, you define two things: a Name and a Value.

The Name is the variable that will be used inside the OQL query. For example, if you set the name to YourStringValue, you can reference it in the OQL statement as $YourStringValue.

The Value is the expression that provides the actual data. In the example shown, the value is $currentUser/Name. This means the username of the currently logged-in user will be passed into the OQL query.

So the flow works like this:

First, the Add string parameter activity creates the variable YourStringValue and fills it with the current user’s name. Then, when the Execute OQL statement activity runs, the query can use $YourStringValue inside the OQL filter or condition.

For example, in the OQL statement you could write something like:

WHERE System.User.Name = $YourStringValue

This approach is useful because it keeps the query dynamic and avoids hard-coding values. It also helps prevent query errors and keeps the microflow easier to maintain.

If this resolves your question, please mark it as accepted.