About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Jotform to SharePoint List Zap- Data not filling into columns

  • 21 July 2023
  • 6 replies
  • 97 views
chelzchan

Hi Zapier Team,

I'm having some trouble, per advice in my last post I have looked through some guides and created a Zap from Jotform to SharePoint so that when a form is submitted, a list item in SharePoint is created. The Zap is working correctly, however it does not fill into the columns and I'm not sure if this is possible? 

 

I've attached some screenshots below of what is happening. I'm assuming it's an issue with my Jotform titles perhaps? Since the form is a registration form and the list is connected to a powerapp for safety checks, not all fields need to be filled out, just the basic customer details. 

 

Thanks!

Chelz

icon

Best answer by SamB 12 September 2023, 17:17

View original

6 replies

chelzchan

Additionally I've searched the forums and seen suggestions to use the API Request (Beta). But am recieving the below error.

I've tried using the below URL formats but the are still not working, I've also tried using the actual URL as seen in the screenshot which is also not working.

https://{site_url}/_api/site

https://{site_url}/_api/web

 

 

 

 

 

 

chelzchan

 

shalgrim
Userlevel 6
Badge +8

Hi @chelzchan ,


Right now the Create List Item action for Sharepoint doesn’t allow you to set any fields other than the title. We do have an open feature request, and I’ve added your name as somebody who’s interested in it. I can’t say when it will get prioritized, but we do use these lists when prioritizing what to improve.

Since your name is on that list you’ll be the first to know when it gets released.

As for the API Request, that might be possible. The SharePoint API is quite tricky…

First, you’ll want to do a POST, not a PUT.

Second, the URL you’ll want to use would be: https://gfitdemo.sharepoint.com/sites/CaravanQLDSafetyForm/_api/web/lists('list_id_goes_here’)/items

Third, you don’t want to map those fields into Headers. Instead you’ll need to set up the Body to be the correctly formatted JSON. Something like:

{"__metadata":

      {"type":"SP.Data.Safety_x0020_FormListItem"},

"formValues": [

    {

        "FieldName": "Title",

         "FieldValue": "title_goes_here"

    },

    {

        “FieldName”: “Registration”,

        “FieldValue”: “registration_value_goes_here”

    }

  ]

}

Now, I’m not even sure that will work. But it’s where I’d start if I were trying to get this to work for my SharePoint. I’m making some guesses based on the documentation here.

Let me know if you have any more questions

SamB
Rank
Userlevel 7
Badge +11

Hello there friends! 👋

Good news! The feature request shalgrim mentioned has now been implemented! 🎉

The Create List Item action has been updated to allow the other fields on a list item to be populated, not just the title. There’s nothing extra you need to do to access this functionality, after selecting a list from the List field’s dropdown menu the additional fields for the list item will automatically load in the Zap. 

@chelzchan - not sure if you were able to get the API Request (Beta) action fully working? If you did, that’s fine, no need to change your Zap. But if not, you might want to update the Zap to use the Create List Item action instead which will allow you to populate the other fields for the list item. 

Happy Zapping! ⚡

J

this is still now working , i can see only title. 

shalgrim
Userlevel 6
Badge +8

Hi @Jai Patel ,

A couple of things to check:

  1. Is it possible you’re using an older version of the SharePoint integration? If you’re using an older version the step will look something like this (https://cdn.zappy.app/012651e7b2be1271009d82f922a85968.png) where it will have a number in parentheses
  2. Does the list you’re linking to have more than a Title field? Can you send a screenshot of the list along with the step in the Zapier editor?
  3. Can you try selecting a different list than switching back to the list you want to use to see if that refreshes the fields for you?

Thanks!

Reply


Terms & Conditions