Answered

If else function and duplicate data did not appear

(0) Share

Report

Posted on by nraindmia

Hi all,

I'm new to Power Automate Desktop,

I created this if else flow. But the result in excel did not appear if the employee number is duplicate. Supposedly it will appear either "Matched", "Transferred" or "Terminated". why did in the excel did not appear any status if the number is duplicate? I want to make the status appear even though the data is duplicate.
eg:

1001: Matched

1078: Transferred
1056: Matched
1078: Transfered

Thank you 🙂

Categories:

Power Automate Desktop

All responses (25)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @nraindmia

Could you show me the entire code for this and share what you are trying to do here to get an idea around the flow 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
nraindmia on at

Like
a
(0)

Report
Copy link

Link copied!

Sure !

For now, when they found the duplicate data, they will not put any status inside the column because the status has been write for the previous data. I want the status to be write for all even though it is duplicate data and has been written the status before. I don't want the status to be empty.
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

That is because you are using the Find and replace cells in Excel worksheet to only return the first match. Enable the "All matches" toggle to find all duplicate values:

Note that this will return a data table of matches, called %Cells%, instead of two separate variables for indexes. You will need to loop through this data table to handle each match separately.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
nraindmia on at

Like
a
(0)

Report
Copy link

Link copied!

can you show me which line to toggle it on for find and replace? I have 3 find and replace. do i need to toggle for all 3?
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The way I understand your issue, is that you need it for the last line (line #20). Not sure if you need it for the others, as you're not really using the other indexes to write anything, and just to read data.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
nraindmia on at

Like
a
(0)

Report
Copy link

Link copied!

I change into cells and it appear this error :
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

As mentioned, %Cells% will now be a data table with multiple row and column indexes. You need to build a loop on it and process each value individually.
nraindmia on at

Like
a
(0)

Report
Copy link

Link copied!

How to build a loop on it and process each value individually? sorry 😞
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Do a For each loop on %Cells% storing the current item in %CurrentCell%.

When you do that, you can use %CurrentCell['Row']% to get the row index and %CurrentCell['Column']% to get the column index. You might need to use Convert text to number to convert those indexes to integers, as they are usually stored as text by PAD in tables for some reason.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
nraindmia on at

Like
a
(0)

Report
Copy link

Link copied!

I don't really get what to do actually, still got an error. or you can show me a simple example of how to do it?