Send api to save data in Microsoft sharepoint list including uploaded file in form

By: André Hoeven | Asked: 10/24/2024
ForumsCategory: General questionsSend api to save data in Microsoft sharepoint list including uploaded file in form
André Hoeven asked 6 days ago
To save the data in a Formidable form (including uploaded file) in a Microsoft Sharepoint list, 
I want to use the send data API. (or any other solution that works).
In Azure I created an app registration including client secret to process the send API data, I created a powerautomate that "captures" the data.
When I submit a form, nothing happens.
5 Answers
Victor Font answered 6 days ago
How are you sending the data from Formidable to Microsoft?
André Hoeven answered 6 days ago
I use the send api option in Formidable (if there is a better way just let me know ;-). In powerauto"mate  I have make a "when a HTTP request is recieved
Victor Font replied 5 days ago

Are you sending RAW JSON? Did you test the API process with POSTMAN before adding your JSON to the API add-on?

André Hoeven answered 5 days ago
Victor, Thank you for the time and effort. I didn't know the postman tool. Now that I use this I see an error message that I did not get back from powerautomate. So the problem is not solved yet, but I now know where to look. Thanks again!
Victor Font replied 5 days ago

If you haven't done so, use Formidable's log add-on. It captures messages from API interactions. One of the most common issues you'll find with API integrations is sensing the data in the exact format the receiving system requires. Dates are often the fields that fail because of formatting.

André Hoeven answered 2 days ago
If I set up the send data api in formidable, I think I should use the post option. However, I then get the error message that a Get is expected. I don't understand that. I still want to send the data to Powerautomate, not receive it.  
Victor Font replied 2 days ago

GET and POST both send information. GET formats details like a query string and can only send a limited amount of data. POST places the payload in the REQUEST header.

You are getting the GET error because that is what Powerautomate expects. GET Requests are usually limited to 2,048 Characters.

Victor Font replied 2 days ago

You will always get errors if you don't send the API the data it expects in the format is expects using the transfer protocol it expects.

André Hoeven answered 2 days ago
Do you think someone ever made a manual  for using send data api combined with Powerautomate ?
Victor Font replied 2 days ago

The only manual you should need is the Powerautomate API documents. I've been answering questions about Formidable in the forums for over a decade. There are many questions asked about APIs. Yours is the first time that I can recall anyone asking about Powerautomate. So no, I don't think there's a manual. From your questions, you don't seem to have a grasp on the complexities of API integration. I suspect you'll either have to figure it out on your own or hire someone to help you.

This may be a good place for you to start: https://forwardforever.com/how-to-use-an-api-with-power-automate/

Victor Font replied 2 days ago

Here's another resource for you: https://learn.microsoft.com/en-us/power-automate/

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right