Replace Items

Build workflows and apps that replace matching items in array with new value - for Microsoft Power Platform, Salesforce, Nintex and more.

08 Nov

Replace matching items in array with new value (collection)

The “Replace Values in Collection” action takes user inputted values to be replaced and what it should be replaced with.

For example, an array of strings such as “the brown cow”, “jumped over”, “the brown dog” with a matched value of “brown” and a replacement value of “spotted” would return “the spotted cow”, “jumped over”, “the spotted dog”.

Parameters

Title	Name	Type	Description
Collection	input	array	Collection of strings
Match Value	match	string	Value to replace
Replacement Value	replacement	string	Value to replace with
Ignore Case	ignorecase	string	Ignore case

Response

Status	Title	Name	Type	Description
Success	Result	result	array	Collection with replaced values
Failure	Result	result	string	Error description

Integrate the "Replace Item" function into a workflow or app with the platform of your choice:

How to replace matching items in array with new value in Microsoft Power Automate
How to replace matching items in array with new value in Microsoft Power Apps
How to replace matching items in array with new value in Salesforce
How to replace matching items in array with new value in Nintex
How to replace matching items in array with new value with Custom API

How to replace matching items in array with new value with Microsoft Power Automate

Instructions

In the Flow designer, click the “+” icon to insert a new action.
Select the “Collections – Replace Values in Collection” action under PowerTools in the “Choose an operation” dialog.
Insert the necessary values or variables in each input field.
Execute the flow.

Example

Video

[Back to top]

How to replace matching items in array with new value with Microsoft Power Apps

Instructions

Add the PowerTools connector from the Data menu.
In the formula for the control, variable or element, type “ApptigentPowerTools.ReplaceValuesInCollection().result”. Within the parentheses, enter the field, control or variable that contains the source collection.
Preview or run the app.

Example

Video

[Back to top]

How to replace matching items in array with new value with Salesforce

Instructions

Drag and drop a new action onto the design surface. Edit the action and choose PowerTools from the category menu on the left.
Click in the “Action” search box, scroll through the action list and choose “Collections – Replace Values in Collection”. Insert the necessary values or variables in each input field. (Note: Click the “Advanced” link to manually assign output variables to the action results.)
Run or Debug your flow to preview the results.

Example

Video

[Back to top]

How to replace matching items in array with new value with Nintex

Instructions

Locate the “Apptigent PowerTools” group in the actions navigator then drag and drop the “Collections – Replace Values in Collection” action onto the design surface.
Insert the necessary values or variables in each input field.
Assign the result to a variable.
Test the workflow.

Example

Video

[Back to top]

How to replace matching items in array with new value in another Platform or Custom Code

Instructions

If your platform is not listed and it supports Open API (Swagger) extensions, import the API Definition document from the Developer Edition product on our Customer Portal at https://portal.apptigent.com/product (look for the Open API link at the top of the PowerTools Developer API definition page). Invoke the desired actions in your app or workflow design tool, supplying values for the listed parameters. Refer to the developer documentation on the Customer Portal for details on input and output formats.

If you are developing a custom app, execute a RESTful POST operation to the /CountCollection endpoint in your application code or use the pre-generated client scaffolding from our Github repo at https://github.com/apptigent/powertools. Be sure to include your API Key (Client ID) in the header using the “X-IBM-Client-Id” key/value pair. The body should be a well-formed JSON object with the parameter label(s) and value(s) in the specified format. Refer to the API documentation at https://portal.apptigent.com for more information.

Example

const request = require('request');

const options = {
  method: 'POST',
  url: 'https://connect.apptigent.com/api/utilities/ReplaceValuesInCollection',
  headers: {
    'X-IBM-Client-Id': 'REPLACE_THIS_KEY',
    'content-type': 'application/json',
    accept: 'application/json'
  },
  body: {
    input: ['the brown cow', 'jumped over', 'the brown dog'],
    match: 'Brown',
    replacement: 'spotted',
    ignoreCase: 'True'
  },
  json: true
};

request(options, function (error, response, body) {
  if (error) throw new Error(error);

  console.log(body);
});