Survey123 - when a survey response is edited only update edited attributes in excel table

[SunshineK]

Hi Team, 

I have create a flow where when a survey is submitted (survey123) it adds a row to a table in excel. 

Currently when I edit and resend the survey it adds another row which I do not want to do.

Is there a way that I can edit and resend the survey with it only updating changes I made from the initial survey response? 

ie. if I change a response for colour from blue to red, it keeps all the other data in place but only changes the colour attribute to red? 

I am wanting to do this across a number of excel spreadsheets so be super keen to get this sorted. 

Thanks, 
Summer 

[v-alzhan-msft]

Hi @SunshineK ，

Could you please share the screenshot of the configuration of the flow?

You could add a Condition to check if the row is exists in the table when a survey response is created or edited, if the row isn't exists in the table, add the row, or if the row is edited, update the row.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SunshineK]

Hi team,

What I have found - I needed to create a unique ID firstly for each survey submission.

This can be done one of two ways that I am aware of:

1) using the objectID in the survey

2) using uuid() in the calculation field of the xlsx form for the survey 

Whatever option - add the column to your excel spreadsheet so you can set condition. 

Thanks Alice for your response. 

I keep coming up with error:  The API 'survey123' returned an invalid response for workflow operation 'When_a_survey_response_is_submitted_for_Intelligence_Noting' of type 'OpenApiConnectionWebhook'. Error details: 'The API operation 'AddData' requires the property 'body/feature/result/objectId' to be of type 'String' but is of type 'Integer'.'

Thanks Summer

[SunshineK]

hi Alice, @v-alzhan-msft 

How do I go about this but from a survey123 to a sharepoint list? 

The flow is successful however it is not doing what I want it to do. It adds a new item. I want it to as mentioned above to replace the edited attributes in that item. 

Have also tried this - works for 'Create New Item' but not for 'Update Item'

It comes up with this error: The 'inputs.parameters' of workflow operation 'Update_item_2' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'id')

Note: i have used the Unique ID i created in the survey123 using uuid() as the 'ID' in sharepoint list. 

Any advice?

Thanks very much. 

[SunshineK · Accepted solution]

My solution: 

I used the uuid() in the calculation field of the xlsx form for the survey.

Flow is as follows:

Cheers