Set up your SDS Flow
Prerequisites
Make sure you have the Flow app enabled
- Go to Office.com and sign in with your Global Admin Account.
- Select on Admin tile.
- Select on Users, then Active Users.
- Search for your Admin account in “Search users” box.
- Select on your account.
- Find Product Licenses and select Edit.
- Ensure "Flow for Office 365" is enabled.
Important
The File System connector can only be set up or modified from within the template creation process. If there is ever any changes needed to the File System; including Username, Password, or Folder location, you will need to recreate the Flow entirely.
Step 1: Set up your Template
Launch a private browser and go to Office.com. Then sign in with your Global Admin Account. Your account should be the same as the one you used to set up the gateway on Step 1-5 of Configuring CSV File Location.
Once logged in, navigate to the Templates tab on the left side and search for School Data Sync.
- Choose the School Data Sync Template to automate CSV file upload. Not the SFTP template.
- Select Create for the File System connector. This will prompt you to set up a new File System connector.
Note
If you already have a File System available, you will need to click on the ellipsis and choose to create a new connector.
!Select on the ellipsis and choose to create a new connector.](images/set-up-your-microsoft-flow-for-sds-2.png)
- Select Create to begin the creation process. This will use the Data Gateway and the Local Service Account sign-in credentials to access the CSV file folder location.
Name the Connection however you choose. It's recommended to name it something related to its function.
In the Root Folder, enter the path to your CSV File Folder you've created previously. In our example, we're using "C:\CSV_Files".
Authentication Type should be set to Windows by default.
Username is the Full username for the Service account created previously including the machine name. Our example is using DESKTOP-SD85O7N\SDSServiceAccount.
Enter the Password for that local service account.
Select the Gateway that was set up previously.
Select create.
- Select Continue to begin the Flow Creation/Customization process.
Step 2: Get the SDS Profile ID
Go to the SDS portal at sds.microsoft.com. Select on the profile you want to use. If you haven't yet created a profile, follow the relevant instructions on the How to Deploy SDS by using CSV files.
At the bottom of your Profile page, you'll find the Profile Id/Instance ID, which in our example is e37e90dd-f495-4420-bd80-4b98d9922c36. Copy it so it can be used in Step 3.
Step 3: Setting up Flow
Go back to the Flow website where we left off.
If desired, change the "Trigger: Recurrence Frequency" for the specific time of day and how often you wish the sync to run. We recommend running the flow no more than once per day. Below example will run at 2 am CST every day.
- Paste in the Profile/Instance ID into the Value area of the next function.
- Place the full file path within the Folder area of the "List files in folder" block that is within the "Upload Files" section. To verify the connection is correct you can select on the Folder image at the end of the box, and then the arrow. This should only have the text "No Items" within it.
- Select save and then test the connector by selecting Test on the top right of the page. Choose "I'll perform the trigger action" then save and test. Finally confirm by selecting "Run Flow" to test your flow.
- Ideally, the flow should run and you should see all green check marks stating that everything was successful. If there are issues, reach out to SDS Support or your deployment manager.
Note
This only uploads the files to the SDS Profile. It does not verify that the upload was successful. Please check your SDS profile to confirm that the validation and sync process continues normally.