cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hong_yip
Helper III
Helper III

excel identify duplicate items and combine then upload to sharepoint list

we have record (below) can power automate identify duplicate items and combine it 

 

before

Invoice Dist Description
SR-0298, HELLO
SR-0297, TESTING 
SR-0297, TESTING 
SR-0297, TESTING 
SR-0296, TESTING 
SR-0296, TESTING 
CR-001266, TESTING 
CR-001266, TESTING 

 

after

Invoice Dist Description
SR-0298, HELLO
SR-0297, TESTING / TESTING
SR-0296, TESTING / TESTING
CR-001266, TESTING  / TESTING
4 REPLIES 4
CFernandes
Super User
Super User

Hey Mate,

 

Easiest option would be to use Excel Script - 

 

Script below 

function main(workbook: ExcelScript.Workbook) {
	let selectedSheet = workbook.getActiveWorksheet();
	// Remove duplicates from range A:A on selectedSheet
	selectedSheet.getRange("A:A").removeDuplicates([0], false);
}

 

You can then use the Run Script action -

 

CFernandes_0-1633930823017.png

 

To know more about excel script see my video -https://www.youtube.com/watch?v=4Xzobptejp4 

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

 

thx  

but  I do not have license to enable  this feature

 

if this record already upload into sharepoint list, then work a solution at power automate is it any possible way ?

Hey @hong_yip 

 

You will need to try - I had a look at the blog and it looks promising(Use arrays to compare if data already exists) https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Delete-duplicate-records-items-fro... 

 

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,738)