web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Same data in different...
Power Automate
Unanswered

Same data in different rows

(0) ShareShare
ReportReport
Posted on by 164

Hi all, i have all this data here and the data for rows 7-9 is the same. All this data here is being read row by row and written into the output file. However, how can i write the if else loop such that if it contains rows that have the same data, it will only read one row of it and skip the rest, and write into the output file?

 

Update: I have managed to do it in such a way that if rows 8 and 9 data is same as row 7, only row 7 will be written into the output file. However, i have another issue now. row 7, 8 and 9 have different data. Row 10 will have different data also. Row 11 have same data as row 7, similarly rows 12 and 13 have same data as row 8 and 9.

 

So, what i want is only rows 7, 8 and 9 will be written into the output file and rows 11, 12 and 13 will not be Written. How can i do that? please help if possible as i need it urgently. Thank you all

 

 

 

I have the same question (0)
  • Ezhilvannan_V Profile Picture
    178 on at

    Please take excel as a database, use distinct query.

  • Alphadrag Profile Picture
    164 on at

    Hi, what do you mean by that?

  • Ezhilvannan_V Profile Picture
    178 on at

    are you comparing input data with output file else you just need to update data into output file for example  if you have same 2 datarow in input excel but you have to update 1 row into excel ?

     

  • Alphadrag Profile Picture
    164 on at

    Yes, as long as i have rows that have the complete same data only 1 row will be written into the output file. Can you show me an example how to do it using PAD? 

     

    i am currently using loops but it only works when continuous data is the same. If it is not continously the same, it will not work. so im unsure whats the issue 

  • Ezhilvannan_V Profile Picture
    178 on at

    just try it

  • Ezhilvannan_V Profile Picture
    178 on at

    Ezhilvannan_V_0-1651842267477.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 921

#2
Valantis Profile Picture

Valantis 801

#3
Haque Profile Picture

Haque 588

Last 30 days Overall leaderboard