Table of Contents

How To Automate PowerShell Script with Data Flow

Under this link you will find video that shows How To Automate PowerShell Script with Data Flow. Here you will find Documentation about used command.

Step by step

  1. Right-click the selected folder in the Solution Explorer to add a new item, choose Data Flow and Data Flow Iem:

pic

  1. Choose Run PowerShell Script from the templates in the toolbox and set up the Data Flow Item:

pic

  1. Set up parameters:

pic

  1. Define the _state variable in the Workbook interactions:

pic

  1. Set up Upload Completed event for the File Storage:

pic

  1. Set up Data Flow Arguments:

pic