Update contact in outlook from excel

[LeeBee3]

Hi there,

I am trying to build a flow which updates an outlook contact from a specific row in excel. I have successfully created a flow that creates a contact in outlook from excel using Get a row - create contact. However, when I try to set up Get a row - update a contact it seems to be having trouble with the ID. The error returned is ID malformed.

I have tried putting in an ID column into excel and when I create a contact from excel putting that in the ID field but it doesn't seem to work.

Here is what I have done for update contact.

when I look at the successful create a contact flow it seems that although the ID is my given one on input it seems to change this on output to 'AAMkADUxNTdhN2EyLTRjZmQtNDdiMi1iNDUxLTVhOTdjMzc3YjczNgBGAAAAAABIFrRZXSUJQKCvdSOPjMMZBwAKUnvt7HqIRau4LSGYHAhUAAFHZKAWAAAKUnvt7HqIRau4LSGYHAhUAAFIr2bcAAA='

Any ideas? I can't seem to find a template

[abm]

Hi @LeeBee3 

I did created a contact and got a similar identifier (not identical) as yours but the total length was more than your id. 

Also I tried hard coded that Id to update the contact and it worked as expected.

Could you please hard code id you specified in your update step and see whether that works or not? 

Thanks

[LeeBee3]

Hi @abm,

Thank you for your response. Please can you explain what you mean by hard coding the ID?

[abm · Accepted solution]

Hi @LeeBee3 

Just paste your ID in your update action.

AAMkADUxNTdhN2EyLTRjZmQtNDdiMi1iNDUxLTVhOTdjMzc3YjczNgBGAAAAAABIFrRZXSUJQKCvdSOPjMMZBwAKUnvt7HqIRau4LSGYHAhUAAFHZKAWAAAKUnvt7HqIRau4LSGYHAhUAAFIr2bcAAA='

Thanks

[LeeBee3 · Accepted solution]

Hi @abm yes that has worked!

I've now updated the create contact to add in the id to a new column 'ID' which I have then linked to for the update contact and it works! Thank you @abm