Set(varUserArray, HolidaysGetUsersDepartment.Run(txtMyDepartment.Value).userarray);
Set(parsedJSON, JSON(varUserArray));
Set(parsedJSONArray, Table(ForAll(Value(parsedJSON), Value)));
ClearCollect(
colUsersDepartment,
ForAll(
parsedJSONArray,
{
DisplayName: Text(Value.displayName),
Department: Text(Value.department)
}
)
);
JSON(varUserArray)
: Converts the stringified JSON into a proper JSON object.Value(parsedJSON)
: Retrieves the value
array from the JSON object (which contains the user details).Table(ForAll(Value(parsedJSON), Value))
: Extracts each item in the array for further processing.colUsersDepartment
: Builds a collection from the parsed JSON array.Label
to display intermediate variables like parsedJSON
to verify their structure during debugging.Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.