Update the row if not exist in excel but also creating duplicate values inside excel (Outlook Mail to One Drive Excel Flow)

[Anonymous]

Hi I am extracting the information from Outlook for Business and updating the excel file stored over One Drive for business, I am checking if the username is already exist in the excel row IF yes then just update the values if the username is not available in excel row then it creates a new username and add the values of it, but during this process I am able to update the row values and also create a new row if not exist but if the row is already available it updates the value and also creates a new row with duplicate values. Here is my flow.
The DataThe Flow

[tom_riha · Accepted solution]

Hello @Anonymous ,

this is caused by the 'Apply to each' on each row in the Excel file. The process will go as below.

first Excel row:
Name of Employee: Username1
Condition: Username1 is equal to Username1?
- update item

second Excel row:
Name of Employee: Username2
Condition: Username 2 is equal to Username1?
- create item

You should avoid processing all the rows in the excel file, or at least not add/update row for each of them. My approach would be to use 'Get a row' to get the specific row only instead of 'List rows present in table'.

Get a row: 'Name of Employee' Column with 'EmailStep2' Value
parallel branches with different 'run after'
- if action was successful, update the row
- if action failed (row doesn't exist), create new row and terminate the flow with status 'Succeeded' 

[Anonymous]

Hi Tom_Riha,

I am having a similar issue to the one described by anonymous. 

However, when I try to set up the flow as you suggest, the flow fails. 

Here is the outcome:

Ideally, I would like the flow to update a row if it exists, or create one if it doesn't. 

Should I add a conditions? How? 

Thank you very much in advance.

Ale

[tom_riha]

Hello @Anonymous ,

you're missing the 'Configure run after' setting on the 'Add a row...' branch - it should run only if the 'Get a row' has failed.

[Anonymous]

Thank you very much. It works!!! 

I don't have the button to accept this as a positive solution (probably because I am not the original creator of this post), but I can confirm that it does work.

Tks Ale