Importing SMS text messages into SharePoint
Vladi Gubler
Vladi Gubler
January 08, 2021 | Products


Import component of Ultimate Forms allows you to set up an automated, background import process of data from a variety of external data sources into SharePoint. We support emails, various databases and Excel files, REST and SOAP web services and even text files. The process runs automatically in the background, looking for new and updated items and then using that data to create and/or update list items and documents in SharePoint.

More and more of our customers are incorporating SMS text messages into their business processes. It's a fast and reliable way of sending notifications and information to employees, customers and vendors. One of the recommended ways of incorporating SMS messaging is using Twilio, the world leader in SMS intergration. With their ease-to-use API, the integration is simple and fast. I already blogged in the past on how to use our Actions to send SMS messages through Twilio.

Now we are announcing a new feature, the ability to use Import to import messages sent and/or received via Twilio. You can now integrate incoming text messages in your business solutions, for instance, implement approvals via text messages.

Let me guide you through the integration steps. In this scenario we are simply going to import all messages from Twilio, incoming and outgoing. But of course, you can set it up in a much more sophisticated ways.

  1. First, let's create a list in SharePoint where we are going to store the messages. I'm using a simple generic list with the following columns:
    1. Body - this is the built-in Title column, I simply renamed it.
    2. From - single line of text, I will store the sender phone number here.
    3. To - single line of text, I will store the recipient phone number here.
    4. Date Sent - date/time, I will store the date/time message was sent.
    5. Direction - single line of text, I will store the message direction here (incoming or outgoing).
    6. Status - single line of text, I will store the message status here (success or error).
  2. You don't have to use an exact same list structure. Import allows flexible mapping of data as you will see later.
  3. Sign into Twilio. If you don't have an account yet, create one.
  4. Go to Settings and scroll down to API Credentials section. You are going to use Account SID and Auth token.
  5. Return to your SharePoint list and click on Design to enter Ultimate Forms.
  6. Click on Import under Import and export
  7. Click on Add new profile
  8. Enter profile title of your choosing.
  9. Start date value controls which messages will be imported. To be imported, message has to be received after this date. By default, the value is set to the current date/time. If you want your profile to import past messages, change the date to be earlier than the first message you want to import.
  10. Polling frequency controls how often the profile will automatically log into Twilio to search for new messages. The default is 15 min, but you can change it to any other interval, as well as None, which means the profile has to be executed manually. You can also contact us to sign up for High frequency polling option, a premium feature that sets the interval to 2 minutes.
  11. Switch to Data provider tab.
  12. Switch Type from Email to Application, then choose Twilio under Application type.
  13. Enter your Account SID and Auth token you copied from Twilio.
  14. You can limit the import to message only sent or received from a specific phone number. I'm leaving this field empty.
  15. Update date column controls what property we use to check the date on the item and only import new items during each run. We are leaving the default value here.
  16. Switch to Actions tab.
  17. Actions specify what we do with the messages that are being imported. You can use actions to create and/or update list items in SharePoint using the data from the imported messages.
  18. Create a new Create list item / document action, give it a title of your choosing.
  19. Map columns in the message to the columns in the list. In my case, I'm simply doing a direct one-to-one mapping. You can use our Value Builder to use expressions and functions to manipulate the values.
  20. Save the action, then save the profile.
  21. If needed, send or receive message in Twilio to ensure there is something to import.
  22. Wait for the profile to run automatically or click on Run now.
  23. You can open Import history to view the execution steps of the run.
  24. Once the profile is completed, go back to your list, you should now be able to see the newly imported items.

As you can see, it's a simple and straightforward process! You can add your own conditions, functions and mapping to ensure it integrates into your business logic. You can also add Alerts and Actions to trigger additional steps. Have fun exploring the possibilities!


Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to to open a support ticket.


Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!


Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

Related Topics

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!


There was an error processing your request.
Please contact us for further details.


Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions


Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.


There was an error processing your request.
Please contact us for further details.
Technical details:

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.