André Hoeven asked 4 months 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.
André Hoeven answered 4 months 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
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 4 months 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!
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 4 months 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.
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.
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 4 months ago
Do you think someone ever made a manual for using send data api combined with Powerautomate ?
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/
Here's another resource for you: https://learn.microsoft.com/en-us/power-automate/
Please login or Register to submit your answer
