Community
Select to view content in your preferred language

Survey123 Power Automate Error 'GetWebhookPayloadSchema' is too large

101
3
Thursday
RickeyFight
by MVP Regular Contributor
MVP Regular Contributor
Thursday

My fire department wants to have a survey123 checklist for each vehicle for daily, weekly, and monthly check in.
We have 12 vehicle  surveys each with a quite a few questions. We are running Enterprise 11.1 and these were made with survey123 connect.

What they now want is a way to get an email if something is missing from a vehicle (example Medication).
I have used power automate in the past and thought this would be perfect. Sadly it is not working. Due to having too many fields. Is there another way to get an email? I also cannot auto make reports either. I need those generated every day.  In my research I have found that there might be a way to limit the schema down for just the yes no questions for the output to power automate but I am not sure how to do that. If I scale down the power automate it will not help me in the report because I need all questions.

Basically the survey is a bunch of yes no questions and if the answer is no there is a comments box that appears. Then each section has an option for images.

Here is my error:
The dynamic schema response from API '***' operation 'GetWebhookPayloadSchema' is too large, only schemas with at most '1024' properties are supported.

Any advice would be appreciated. 

@IsmaelChivite

0 Kudos
3 Replies
abureaux
by MVP Frequent Contributor
MVP Frequent Contributor
Thursday

Have you tried disabling "include submitted record" yet?

abureaux_1-1736453713387.png

You can also specify this in the Webhook in the Surveys Site:

abureaux_2-1736453773329.png

 

DavidSolari
by MVP Regular Contributor
MVP Regular Contributor
Thursday

If @abureaux's idea doesn't work and you have to pare the schema down, you can replace all those yes/no questions with one select_multiple question where each choice is a former yes/no. The downside is everything outside of Survey123 will see a field with a bunch of tiny codes with a comma in between so you'll need to document things in your metadata, use Arcade to extract legible yes/no answers etc. etc. Still, a bad fix is better than no fix at all.

0 Kudos
RickeyFight
by MVP Regular Contributor
MVP Regular Contributor
Friday

I was able to get the survey to generate a report but I cannot seem to get it to save yet. Thank you for your input. It is a start. I need to be able to run yes no query and I am not sure that will work without the submitted record.

0 Kudos