SetLocalVar Macro Action (Access custom web app)

The SetLocalVar action creates a temporary variable and set it to a specific value.

Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Note

The SetLocalVar action is available only in Data Macros.

Setting

The SetLocalVar action has the following arguments.

Argument name	Required	Description
Name	Yes	A string that specifies the name of the variable.
Expression	Yes	An expression that will be used to set the value for this temporary variable. Do not precede the expression with the equal sign (=). You can click the Build button to use the Expression Builder to set this argument.