Answered

Check for Duplicate Form Response Before (or After) Importing to Sharepoint List

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have an existing flow that is working where it imports responses from a Microsoft Form to a Sharepoint list. However I would like to add a condition within the flow to check for duplicate entries before (or after) importing to sharepoint list.

Is this possible to do within exisiting flow without creating a separate flow? @ekarim2020 @eliotcole @Pstork1 appreciate any advise please. Thanks.

Import Form Responses to SP List.png

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,739 Most Valuable Professional on at

Like (0)

Report

It depends on what you mean by Duplicate Responses. Are these Responses from the same user? If so that would require that the form not be filled out anonymously. Or is there some specific question that has a unique answer for each responder? In short, yes its possible to look for duplicates while importing them but how depends on what a duplicate is?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Pstork1 apologies for not clarifying. A duplicate would be defined based on 2 columns i.e. 'Date' and 'Delivery Branch'. So if date and delivery branch are the same, then delete response. Hope that helps.

Was this reply helpful? Yes No
Pstork1 68,739 Most Valuable Professional on at

Like (1)

Report

Two things.

1) You are using an older form of the Forms Trigger. The current one fires for each Response that is submitted so you don't need the apply to each loop.

2) The best way to do this is to use a condition between Get Response Details and Get User Profile. If the Response being checked is already in the SharePoint list then don't add the new one. You can check if its in the list by doing a Get Items filtered by your two fields or just a Get Items and then Filter Array. If the length of the output array is greater than 0 then the response already exists and shouldn't be added.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Does this look right? It saved successfully but haven't tested it...
Fyi here's the condition I used for length of outputs

lengthoutputs('Get_response_details')?['body/value']

Was this reply helpful? Yes No
Verified answer

Pstork1 68,739 Most Valuable Professional on at

Like (0)

Report
YOu need to filter the Get Items call and then do the length of that so it should be

length(outputs('Get_items')?['body/value'])

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Sorry I don't quite understand...are you able to provide screenshots please?

Was this reply helpful? Yes No