Importing SMS text messages into SharePoint

Vladi Gubler
Vladi Gubler
January 08, 2021 | Products

Hi,

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!

Loading...

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 support@infowisesolutions.com to open a support ticket.

UltimateForms

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!

Cost-effective

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

Fantastic Support Team

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

support@infowisesolutions.com

Related Topics

Infowise logo
© 2021 - Infowise Solutions Ltd
Microsoft partner logo
GSA Schedule

What is right for you?

Sandbox

Get acquainted with UltimateForms from the end user perspective
  • No installation or registration required
  • Experience 14 pre-built business solutions
  • End-user access only, cannot modify settings
Let's go!

Online Trial

Create a trial site in our environment and explore features of UltimateForms
  • Full control of the site
  • Full access to all settings
  • Optionally pre-install one of our business solutions
  • Site provisioned automatically
  • Register for 30 day trial
Register Now

Installation

Get UltimateForms in your own environment
  • Start working with your real users and data
  • Install either on SharePoint Online or on premises
  • Register for 30 day trial
  • Trial can be converted to paid license
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.

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.