Learn how to configure an on-demand News Sync flow to sync SharePoint News to Staffbase.
The on-demand News Sync flow allows you to sync SharePoint News to a Staffbase news channel based on a manual trigger event. This flow is ideal if you want to migrate your news creation from SharePoint to Staffbase.
- You have imported the on-demand news sync flow to Power Automate.
- You have created a SharePoint connection.
- You have created an article news channel in the Staffbase Studio and then copy its ID.
- In Power Automate, navigate to My flows.
- Select the on-demand news sync flow you imported.
- Click Edit to configure the news sync flow.
The on-demand news sync flow opens.
You have opened the flow. Now, you can configure the steps in the flow.
- In the flow, open step 2 to configure the SharePoint connections.
- Add the connection that you created for SharePoint to map the connection to the trigger.
The Get files from SP dialog opens. - In the Site Address dropdown field, select a SharePoint site that has news content you want to sync.
- In the Library Name dropdown field, select Enter custom value, and enter Site Pages.
SharePoint News content is selected from the library to be synced to Staffbase. By default, this action will return 100 news items based on the news ID field, including folders in ascending order. Learn more about how to configure advanced options for this action.
Define the process to indicate whether you want to sync news drafts.
- In the flow, open step 3 to define whether to include drafts in the syncs.
- In the Value field, add dynamic content.
The Dynamic content dialog opens. - Switch to the Expressions tab and add one of the following functions:
- true if you want the flow to sync news drafts
- false if you do not want the flow to sync news drafts
Define the process to indicate if you want the flow to override already copied news in Staffbase Studio. This is useful in case you want to run the migration again in cases you missed or overlooked something during the first migration.
- In the flow, open step 4 to define whether to overwrite existing news content.
- In the Value field, add dynamic content.
The Dynamic content dialog opens. - Switch to the Expressions tab and add one of the following functions:
- true if you want the flow to overwrite already copied news
- false if you do not want to skip already copied news
Configure the details of the hosting infrastructure for your Staffbase platform.
- In the flow, open step 5 to configure the Staffbase platform details.
- In the Value field, enter one of the following depending on where your Staffbase platform is hosted.
- US: If your Staffbase platform is hosted on the US infrastructure, enter: https://backend.staffbase.com/api/
- Europe: If your Staffbase platform is hosted on the German infrastructure, enter: https://de.staffbase.com/api/
Define the Staffbase channel to which you want to sync your SharePoint News.
You have the ID for the Staffbase News channel to which want to copy the SharePoint News content.
- In the flow, open step 6 to define which Staffbase news article channel you want to display copies of synced SharePoint News content.
- In the Value field, enter the channel ID you copied from the Staffbase Studio.
Define the default language for news content.
- In the flow, open the step 7 to configure the Staffbase platform details.
- In the Value field, enter your default language locale.
For a list of supported languages and locales, see Languages and Locale Codes .
Some steps can still miss a mapping connection leading to errors. You need to fix those errors before saving the flow.
- In the flow page, click Flow checker on the top toolbar.
The Flow checker dialog opens. - Click on an error.
You are redirected to the step in which the configuration is incorrect. - Provide the correct details.
- Click Save after fixing all the errors.
After saving the flow, you can test the flow to ensure that it works as expected.
- In the flow page, click Test on the top toolbar.
The Test Flow dialog opens. - Click Manually.
- Click Save & Test.
You have tested the flow and if you have not encountered any errors, you can run the flow. If you encounter any errors, fix them, and test the flow again.