📊M365 Excel (.gov.sg Agencies only)
Last updated
Last updated
Please make sure to read through this entire document as there may be restrictions that could affect your operations.
There is a cap on total disk space and Excel actions across all Plumber users. Please exercise prudence when using this action. We maintain a Excel action queue to ensure fairness. If there are many users at the same time, your pipe may not execute immediately. To prevent choking of the system, the Plumber team reserves the right to pause you or your pipe from using Excel if:
Your pipe exceeds a large amount of actions in a short span of time.
You are storing large files in your folder.
If your use case requires large files (>50 MB), or more than 100 Excel actions per hour, please contact us at https://go.gov.sg/plumber-support to avoid any disruption to your workflow.
M365 Excel is only available for agencies that can access the SG Govt SharePoint. Or, you may try to access this link on your GSIB, if you're able to access, it means you'll be able to access the integration on Plumber. If your agency can access this SharePoint, but you are unable to see this app in Plumber, please contact us at https://go.gov.sg/plumber-support
To get started, you need to perform a one-time configuration to connect your Plumber account to M365. This will create a shared folder, known as your "Plumber folder," where you can place Excel files for Plumber to access.
Follow the steps below to set up the configuration.
Select “FormSG” as the trigger and connect a new FormSG. You can design this FormSG any way you want; it’s just to allow you to test our excel actions after setting it up.
Expand the 2nd step
Select “M365 Excel” action
Then select the “Create row” action
Finally, click on the “Continue” button
Expand “Choose connection” and select “SG Govt”
Click on “Connect” and wait for the connection to complete.
You should see this when the connection is done. We’ll come back to “Set up action” later.
Go to your onedrive on the SG Govt SharePoint, and click on the “Shared” link
You will see a new folder named with your email. The subtitle of that folder will be Plumber (OGP). Any Excel files placed in this folder can be processed in a plumber pipe. We recommend that you star this folder for easy access.
You can create a new excel file via the “Add New” button, or move an existing excel file to this folder.
CAUTION: If you want to move files into this folder, make sure that “Keep sharing with the same people” is selected! Otherwise, existing users will lose access to that file!
Plumber does not automatically refresh changes to your excel file. If you make changes (e.g. creating a new table / renaming a column), you need to manually trigger a data refresh. To do this:
After editing your excel file, please wait 2-3 minutes for Microsoft servers to sync
Navigate to your Plumber pipe and expand the appropriate drop down menu (e.g. if you added a new table, expand the “Table” menu)
click on the “Refresh Items” button at the bottom of the menu.
This action allows you to add rows to an Excel table.
You’ll need a table to use “create table row”. Please refer to Microsoft’s video here for instructions on creating a table.
Please do NOT edit the excel table unless you un-publish your pipe first! Editing the table while the pipe is running will result in data corruption!
Expand the “Choose app & event” section, and select “Create row” in the “Choose an event” dropdown.
Expand the “Set up Action” section
In the “Excel File” dropdown, select the file that you want plumber to edit.
In the “Table” dropdown, select the excel table you want plumber to add rows to.
In the “Values” section, input the columns you want to add your data to.
When you are done, click “Continue” and test your step to ensure you have configured it correctly.
This action allows you to find a single table row by looking up a column value.
Find Table Row only supports tables that are smaller than 50,000 rows or 100,000 cells.
It will also use the first table row whose lookup column matches the lookup value.
Expand the “Choose app & event” section, and select “Find table row” in the “Choose an event” dropdown.
Expand the “Set up Action” section
In the “Excel File” dropdown, select the file that you want plumber to edit.
In the “Table” dropdown, select the excel table want to lookup from.
In the “Lookup Column” section, select the table column you want to look up.
In the “Lookup Value” section, input the value you want to look up.
When you are done, click “Continue” and test your step to ensure you have configured it correctly.
This action allows you to update a single table row whose column matches a lookup value
Update Table Row only supports tables that are smaller than 50,000 rows or 100,000 cells.
It will also update the first table row whose lookup column matches the lookup value.
Expand the “Choose app & event” section, and select “Update table row” in the “Choose an event” dropdown.
Expand the “Set up Action” section
In the “Excel File” dropdown, select the file that you want plumber to edit.
In the “Table” dropdown, select the excel table want to lookup from.
In the “Lookup Column” section, select the table column you want to look up.
In the “Lookup Value” section, input the value you want to look up.
In the “Columns to update” section, input the columns and values that you want to update.
When you are done, click “Continue” and test your step to ensure you have configured it correctly.
This list was last updated on 27 June 2024.
If you're user with the email domains "x.gov.sg" and you're not able to access M365 app, please raise a ticket with us at https://go.gov.sg/plumber-support
| Approved government email domains | Disallowed government/org email domains |
|---|---|
@tech.gov.sg | @schools.gov.sg |
@sport.gov.sg | @defence.gov.sg |
@mom.gov.sg | All .edu.sg |
mindef.gov.sg | All healthcare institutions |
@nlb.gov.sg | |
@mnd.gov.sg | |
@singstat.gov.sg | |
@wsg.gov.sg | |
@bca.gov.sg | |
@spf.gov.sg | |
@thedigitalacademy.tech.gov.sg | |
@mas.gov.sg | |
@nea.gov.sg | |
@hdb.gov.sg | |
@moh.gov.sg | |
@mlaw.gov.sg | |
@judiciary.gov.sg | |
@nyc.gov.sg | |
@moe.gov.sg | |
@pub.gov.sg | |
@customs.gov.sg | |
@iras.gov.sg | |
@msf.gov.sg | |
@htx.gov.sg | |
@scdf.gov.sg | |
@mci.gov.sg | |
@mha.gov.sg | |
@stb.gov.sg | |
@jtc.gov.sg | |
@lta.gov.sg | |
@vital.gov.sg | |
@pris.gov.sg | |
@caas.gov.sg | |
@hsa.gov.sg | |
@gra.gov.sg | |
@ssg.gov.sg | |
@ica.gov.sg | |
@pa.gov.sg | |
@acra.gov.sg | |
@mfa.gov.sg | |
@cpf.gov.sg | |
@pmo.gov.sg | |
@toteboard.gov.sg | |
@csa.gov.sg | |
@hpb.gov.sg | |
@mddi.gov.sg | |
@mpa.gov.sg |
Why are only ".gov.sg" email domains given access to M365? This restriction is in place because the ".gov.sg" email domains share the same system on SG SharePoint, which is the only system integrated with the product. The other domains reside on a separate SharePoint system to which the product does not have access.
What is the meaning of disallowed email domains? Users will not be able to use the M365 excel integration on Plumber. The reason is because the users are not able to access SG sharepoint.
Will the team work towards opening M365 to everyone? Currently, it is not in the roadmap, so users may have to use "Tiles" in the meantime.
Why does my response take a while to appear? We have implemented a queuing system to ensure fairness. If there are many automations using M365 running at the same time, your request may not execute immediately. Please allow around half an hour for your response to show up. The response ultimately resides on FormSG. Alternatively, you may also set up Tiles in your action.
Can I use macros along with this integration? No, it is not possible to use macros with this integration. Plumber will not be able to detect the excel sheet if it's macros-enabled.
How do I know if I am able to access M365 integration on Plumber? You can try to access the link gccprod-my.sharepoint.com with your GSIB. If you're able to access it, you should be able to use the integration on Plumber.
Why do I see a 504 gateway timeout error?
You most likely have a long-running formula in your excel sheet, please make your formulas manual instead of automatic to prevent issues with creating a table row. To do so, click on Formulas -> Calculation Options-> Manual
