Cloudy standing next to text that says, "Create Workflows in Data Cloud Using Flow."

Create Workflows in Data Cloud Using Flow

By

Are you a Salesforce Admin who wants to streamline and optimize key Data Cloud processes such as ingestion, identity resolution, calculated insights (CIs), segments, and activation? If so, you’ve come to the right place. In this blog post, we’ll explore how you can use Salesforce Data Cloud and Flow together to create custom workflows to meet your organization’s unique needs. The post also covers the do’s and don’ts of configuring workflows for Data Cloud. By chaining together Data Cloud actions and defining trigger conditions based on your business requirements, you can take advantage of the powerful capabilities of Flow and optimize your customer Data Cloud processes.

With the Winter ’23 Release, the following Data Cloud actions are available in autolaunched flows.

  1. Refresh DataStream (Salesforce CRM and Amazon S3 ingestion)
  2. Run Identity Resolution
  3. Publish Calculated Insights
  4. Publish Segments and Activate

As Data Cloud continues to evolve, more actions will be available for use with Flow and other platform capabilities. For now, keep reading for an example of how you can use Flow to orchestrate Data Cloud workflow processes.

Use case: Automating a workflow

Your organization is looking to compensate customers who are affected by a technical failure. It wants to deposit 500 rewards points to each impacted customer’s account and send an apology email letting them know about the reward.

To do this, your organization wants to kick off CIs once new data is ingested and the identity resolution job is run. Publishing CIs calculates the impact, duration of the failure, membership ID, and so on. Once CI is completed, you can materialize segments to query newly refreshed data and then kick off activation. At the end, an apology email will be sent, letting the customers know about the reward.

The above workflow needs to be automated to ensure the customers are compensated every time there’s a technical failure.

Here are the key platform features you can use to set this up in Flow.

  1. Platform events
  2. Record-triggered flows
  3. Autolaunched flows (which is your main workflow)

Create platform event(s)

Create a custom platform event by going to Setup > Platform Events. You need to create a platform event for each action that you intend to use in your main autolaunched flow. For our use case, one event needs to be created for each of the below actions.

  1. Refresh DataStream
  2. Run Identity Resolution
  3. Publish Calculated Insights
  4. Publish Segment

As you create a custom platform event for each action, you also need to create at least one field for each action that’s populated based on the record-triggered flow (which is the next step after creating platform events). For example, if you create an event for “Refresh DataStream”, you can add a field named Data Stream ID. For CIs, you can add a field named Calculated Insight Name.

Platform Event for Data Ingestion Completion.

List of all Custom Platform Events.

The next step is to create a record-triggered flow. For our use case, note that it’s the record-triggered flow that publishes the platform event (that is, populates the field in the platform event). Only after publishing the platform event does the autolaunched flow (described later in this blog) resume.

Flow diagram describing how to configure the workflow logic at high level.

Create record-triggered flow(s)

You must create a record-triggered flow in order to publish the platform event you created in the above step. It can then be used to resume the execution of your paused main autolaunched flow, which we will get to later.

To create a record-triggered flow:

1. Go to Setup > Flows > New Flow > Record-Triggered Flow.

Record Triggered Flow for Ingestion Completion.

Create a new Record-Triggered Flow.

2. Configure the Start step of the record-triggered flow by choosing the appropriate object. For example, for Ingestion, select the DataStream object. For Calculated Insight, select the Calculated Insight object, etc.

Configure the Record-Triggered Flow.

3. For our example use case, configure the trigger when a record is updated (as shown in the image above). Also, select the conditions (as shown in the image below) with the appropriate DataStream ID.

Configure conditions for Record-Triggered Flow.

This will ensure that the flow gets triggered whenever the DataStream import run status is changed to “Success” for the specified DataStream ID.

One of the steps in this record-triggered flow is to populate the respective platform event. For example, if you’re creating a record-triggered flow for “Refresh DataStream”, create a record in the platform event pertaining to “data ingestion” and set the field to the DataStream ID.

Populate the platform event for the Record-Triggered Flow.

Similarly, create record-triggered flows for all four processes:

  1. Refresh DataStream
  2. Publish Calculated Insights
  3. Run Identity Resolution
  4. Publish Segment

Once you’ve created your record-triggered flows, the next step is to create your main autolaunched flow.

Create autolaunched flow

This is your main flow that defines an end-to-end workflow for the business use case.

1. Go to SetUp > Flows > New Flow > Autolaunched Flow (No Trigger).

Create an Auto-Launched Flow.

2. On the canvas, click Add Element and then Action. In the left pane, click Data Cloud, and then select a Data Cloud action. Enter the label, API name, and input values, and click Done.

Select the Data Cloud Action in the Auto Launched Flow as needed.

3. Select the Refresh DataStream action and enter the DataStream ID as the input field when prompted. Then, create a Pause step for the workflow to pause until data ingestion is complete and the platform event for data ingestion is published.

4. Resume the workflow only when the platform event is published.

Setting the Resume Event condition based on the Platform Event.

5. Repeat steps 1 through 4 for the “Identity Resolution”, “Calculated Insights”, and “Publish Segments” actions. Once you’ve completed the steps, your main autolaunched flow appears.

Entire Flow representing different Data Cloud Processes.

6. At the end, configure the “Send Email” action as the last step to send an apology email to the impacted customers.

Configuring "Send Email" action.

7. When your autolaunched flow is ready, you can run it manually from the UI by clicking Run. You can also trigger it via an API. Or, you can use this autolaunched flow as a subflow within the record-triggered flow to make it completely automated.

Explore the combined power of Data Cloud and Flow

This use case is just a simple example. Flow is a powerful tool that allows you to build complex, enterprise-scale automation into your workflows with automated triggers, reusable building blocks, and prebuilt solutions. You can use it for a plethora of different use cases inside and outside of Data Cloud. For another example detailing how you can use Flow to proactively notify team members of any critical status changes in your Data Cloud implementation, check out the Medium blog linked in the resources below.

Resources

Overcome access dilemmas with permission sets

Use Permission Sets To Overcome Common Access Dilemmas

As an Awesome Admin, it’s probably in your nature to look for any way to optimize a process or situation! As part of that never-ending desire for optimization, I would bet that you’ve spent a lot of time thinking about your permissions setup in Salesforce. Salesforce provides multiple ways to grant permissions to users, each […]

READ MORE
Advance Your Admin Career With Dev Fundamentals

Advance Your Admin Career With Dev Fundamentals

Ready to take the next step in your admin career but unsure where to start? Take a page out of my book and learn development fundamentals to jumpstart your abilities as an advanced admin and extend your Salesforce Platform knowledge. Several years ago, I was at a career tipping point. I felt solid in my […]

READ MORE
Upgrade to Hyperforce with Confidence Using Hyperforce Assistant

Upgrade to Hyperforce with Confidence Using Hyperforce Assistant

Demystifying Hyperforce for admins As a Salesforce Admin, you might be wondering, what is Hyperforce? Put simply, Hyperforce is Salesforce’s new public cloud-based infrastructure designed to support Salesforce services for the future. A cloud-native architecture, Hyperforce will replace our existing first-party infrastructure and provide significant benefits to our customers, including data residency, enhanced security, availability, […]

READ MORE