Survey123 Responses into a SharePoint List using Power Automate

[SophiaRecca1]

Hello. I'm looking to use Power Automate's template for "Track Survey123 responses in a SharePoint List." The connections to the Survey and List look good, but every time I test submitting a response, the survey data does not convert to the list (although an entry is made, it's just all blank). I have not adjusted the default parameters in the template. Any tips or tricks out there? 

[abureaux]

Can you add some screen shots of what is going on?

This particular operation I have quite a lot of experience/success with. However, I've never seen or touched Power Automates default templates as I prefer to make my own from scratch.

[SophiaRecca1 · Accepted solution]

Apologies for the delay in response. I didn't realize I needed to apply dynamic content to each field in my sharepoint list. I've attached what that looks like for other newbs like me.

I have run into another glitch, which perhaps you might be able to assist with based on your experience (and perhaps I would need to make a flow from scratch like you vice using the template):

In Survey123 under Settings - Webhooks, I have edited the webhook with Power Automate so there is a trigger for when an existing record is edited. However, the second part of the flow - Create Item - does not seem to be compatible with this and I get the error: "Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'The template language function 'div' expects its first parameter to be an integer or a decimal number. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#mul for usage details.'." I've attached the first part of the code view in case that's helpful.

[SophiaRecca1]

@abureaux  I'm marking the original question as answered, but I will repost my follow-on question should you think you might be able to assist! Thanks for reaching out in regards to the original post.

[abureaux]

All math operations in Power Automate which include "div" always require a number. If you feed it a null, you get the error as shown. If the number field in S123 allows for nulls, you need to use an IF() statement in Power Automate to account for those nulls. Something like this would work:

if(equals(<your number field in S123>,null),'',<your math operation here>)