Output files and update Opportunity records in Salesforce Flow (for OFC Ver.2) - Office File Creator Advanced -

This article will show you how to output files using Office File Creator and update Opportunity records in Salesforce Flow. Office File Creator can be integrated into the Screen Flow.

*This procedure is for Office File Creator Ver. 2.xx. If you are using Ver. 1.xx, please refer to Output files and update Opportunity records in Salesforce Flow (for OFC Ver.1) – Office File Creator Advanced –.

 

Completed Flow

By clicking on the "Output Invoice" button, a pop-up window will appear, and when the flow is executed, output files and update the field "Bill Output Date".

 

Demo

 

 

Key Points for Flow Creation

  • The parameter that receives the record Id from the records screen in the flow is "recordId". Create a text type variable "recordId" in the flow. No other variable name can receive the record Id.
  • To output a file in Office File Creator, place the ofcForFlowScreen component in the screen flow. It returns the result of creating the files (success or failure) and returns an error message in case of failure.
  • For details on the parameters and return values of the ofcForFlowScreen component, refer to the Instruction manual.

 

 

Flow Process Overview

This is the overall picture of the flow.

 

1. Top Screen

Display the confirmation message.

Place ofcForFlowScreen component in the screen flow and output the file.

2. OFC error judgment

Judge the success or error of the output result. In case of success, go to process 3. In case of error, go to process 2e.

2e. Error Screen

Displays an error message and end the flow.

3. Update Bill Output Date

Update the Bill Output Date of the Opportunity.

4. Completion Screen

Display the completion message.

 

Create the Flow

Let's create the flow. Open Flows from Setup and click the "New Flow" button.

 

Select "Screen Flow" and click the "Create" button.

 

 

Create recordId Variable

Click the "Toggle Toolbox" button in the upper left corner of the screen, then click the "New Resource" button.

 

Create the Record Id variable. After setting, click the "Done" button.

Resource Type: Variable

API Name: recordId

Data Type: Text

Available for input: check on

Note: recordId is a variable that receives the record Id from the record screen. Be sure to use "recordId" (only "I" is capitalized). Other variable names cannot receive the record Id.

 

First, save the flow. Click the "Save" button.

 

Save the Flow under any name. Here it is saved as follows.

Flow Label: Output Invoice Screen Flow

Flow API Name: OutputInvoiceScreenFlow

 

If a warning message appears, close it with an "X".

 

 

1. Top Screen

Click the "+" mark under Screen Flow.

*Place the cursor over the "" mark and the "+" mark (add element) will appear.

 

Select "Screen".

 

Set Screen properties.

Label: Top Screen

API Name: Top_Screen

Show Footer: check off

 

Click "Display Text" in the left component and set the properties.

API Name: dispConfirmMsg

Text: Are you sure you want to output the invoice?

 

Click "ofcForFlowScreen" in the left component and set the properties. After setting, click the "Done" button.

API Name: OFC

recordId: {!recordId}

save: Empty  *To save the file, enter "file" or "att".

template: OpportunityInvoice  *Enter the Template Api Name of the OFC_Template record.

Note: Select the variable {!recordId} from the candidate resources. In the same manner thereafter, settings of the form {!xxx} will be selected from the resources.

 

2. OFC error judgment

Click the "+" mark under Top Screen and select "Decision".

 

Sets the properties of the Decision.

Label: OFC has errors?

API Name: DecOFCError

[OUTCOME DETAILS] section

Label: Error

Outcome API Name: decOFCError_Yes

Condition Requirements to Execute Outcome: All Conditions Are Met (AND)

Recourse: {!OFC.isSuccess}

Operator: Equals

Value: {!$GlobalConstant.False}

 

Click "Default Outcome" in the left sidebar.

 

Set the properties of OUTCOME DETAILS, and Click the "Done" button.

[OUTCOME DETAILS] section

Label: Success

 

 

2e. Error Screen

Click the "+" mark under Error and select "Screen".

 

Set Screen properties.

Label: Error Screen

API Name: Error_Screen

 

Click "Display Text" in the left component and set the properties. After setting, click the "Done" button.

API Name: dispErrorMsg

Text: {!OFC.errorMessage}

*Set text color to red from the color palette.

*Select "errorMessages", not "errorMessages". "errorMessages" is the return value when outputting multiple files at once.

 

Click the "+" mark under Error Screen and select "End".

 

It is branched into two.

 

 

3. Update Invoice Output Date

Click the "+" mark under Success and select "Update Records".

 

Set the properties.

Label: Update Bill Output Date

API Name: UpdateBillOutputDate

How to Find Records to Update and Set Their Values: check on "Specify conditions to identify records, and set fields individually"

[Update Records of This Object Type] section

Object: Opportunity

[Filter Opportunity Records] section

Condition Requirements to Update Records: All Conditions Are Met (AND)

Field: Id

Operator: Equals

Value: {!recordId}

[Set Field Values for the Opportunity Records] section

Field: BillOutputDate__c

Value: {!$Flow.CurrentDate}

*A custom fields named Bill Output Date (API Name: BillOutputDate__c) is created in Opportunity.

 

After setting, close the properties screen by clicking the "X" button in the upper right corner of the screen.

 

Click the "Save" button as appropriate to save your edits.

 

 

4. Completion screen

Click the "+" mark under Update Invoice Output Date and Select "Screen".

 

Set Screen properties.

Label: Completion Screen

API Name: Completion_Screen

 

Click "Display Text" in the left component and set the properties. After setting, click the "Done" button.

API Name: dispCompleteMsg

Text: Completed.

 

Flow creation is complete.

 

Click the "Save" button.

 

 

Debug the Flow

Click the "Debug" button.

 

Enter the record Id and click the "Run" button. Enter the Opportunity record Id here.

 

The debug screen will appear. Click the "Next" button.

 

Confirm that the file is output.

 

Confirm the date is set to the Bill Output Date in the Opportunity record screen.

 

Click the "Activate" button on the flow. Close the Flow screen.

 

 

Create Custom Button

Create a custom button for outputting files to be placed on the record screen.

Open the target object from the Object Manager in Setup. Click "Buttons, Links, and Actions" in the left sidebar, then click the "New Action" button.

 

Set the Action Information. After setting, click the "Save" button.

Action Type: Flow

Flow: Output Invoice Screen Flow

Label: Output Invoice

Name: OutputInvoiceFlow

 

Click "Page Layout" on the left sidebar, place the Output Invoice button, and click the "Save" button.

 

 

Run Flow

Click the "Output Invoice" button on the record page. The Bill Output Date is blank before running the flow.

 

A pop-up screen will appear. Click the "Next" button.

 

The Running screen will appear. Outputting the file and updating Bill Output Date.

 

The completion screen will appear. Click the "Done" button to close the flow screen.

 

The invoice file is output and today's date is set as the Bill Output Date.

 

 

Copied title and URL