Duplicated Inputs in Excel from Microsoft Form

%3CLINGO-SUB%20id%3D%22lingo-sub-1443021%22%20slang%3D%22en-US%22%3EDuplicated%20Inputs%20in%20Excel%20from%20Microsoft%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1443021%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20Microsoft%20Form%20linked%20to%20Excel%20where%20users%20update%20KPI%20in%20daily%20basis%2C%20for%20some%20unknow%20reason%20some%20of%20the%20users%20inputs%20get%20duplicated%20in%20the%20excel%20file%2C%20with%20the%20same%20ID%2C%20I%20have%20detected%20that%20it%20happens%20when%20they%20use%20the%20form%20twice%20in%20less%20than%205%20minutes%2C%20the%20last%20record%20is%20the%20one%20get%20duplicated%2C%20do%20you%20have%20any%20idea%20how%20to%20fixed%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1443021%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445459%22%20slang%3D%22en-US%22%3ERe%3A%20Duplicated%20Inputs%20in%20Excel%20from%20Microsoft%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445459%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690228%22%20target%3D%22_blank%22%3E%40Zavalaher%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20interesting%20one%2C%20I%20wish%20we%20have%20some%20kind%20of%20validation%20at%20the%20form%20level%20itself%20not%20to%20accept%20the%20duplicate%20values%2C%20however%20if%20you%20have%20PowerApps%20in%20your%20Organization%20then%20you%20can%20configure%20the%20entry%20by%20giving%20such%20validation%20to%20the%20App%20itself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20best%20solution%20what%20I%20can%20advise%20you%20from%20my%20experience.%20We%20cannot%20control%20the%20user%20are%20the%20entry%20part%20and%20they%20keep%20doing%20such%20error.%20So%20educate%20them%20strictly%20not%20to%20enter%20duplicate%20records.%20Handling%20the%20situation%20at%20your%20end%20you%20can%20use%20Power%20Query%2F%20VBA%20to%20delete%20the%20duplicate%20records%20from%20the%20file%20if%20it%20exits.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20will%20ease%20your%20task%20%26amp%3B%20you%20will%20have%20clean%20report%20for%20data%20analysis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448327%22%20slang%3D%22en-US%22%3ERe%3A%20Duplicated%20Inputs%20in%20Excel%20from%20Microsoft%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448327%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20of%20full%20thank%20you%20very%20much%20for%20your%20quick%20response%2C%20We%20do%20have%20Power%20Apps%20in%20my%20organization%2C%20can%20you%20share%20how%20I%20can%20configure%20users%20entry%2C%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

 

I created a Microsoft Form linked to Excel where users update KPI in daily basis, for some unknow reason some of the users inputs get duplicated in the excel file, with the same ID, I have detected that it happens when they use the form twice in less than 5 minutes, the last record is the one get duplicated, do you have any idea how to fix it?

 

Thanks in advance.

2 Replies
Highlighted

Hi @Zavalaher,

 

This interesting one, I wish we have some kind of validation at the form level itself not to accept the duplicate values, however if you have PowerApps in your Organization then you can configure the entry by giving such validation to the App itself.

 

So the best solution what I can advise you from my experience. We cannot control the user are the entry part and they keep doing such error. So educate them strictly not to enter duplicate records. Handling the situation at your end you can use Power Query/ VBA to delete the duplicate records from the file if it exits. 

 

That will ease your task & you will have clean report for data analysis.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

Highlighted

HI @Faraz Shaikh 

 

First of full thank you very much for your quick response, We do have Power Apps in my organization, can you share how I can configure users entry, please?

 

Regards