Issues with connection DocuSign-Excel

[Anonymous]

Hi there,

I have built a flow to ensure new starters receive the appropriate reviews by their line managers. 

The flow works by detecting the subject of the email sent by DocuSign and according to that it either "Add a row on a table" in Excel, or "Update row" for existing rows.

The final goal is to have a table with the name of the employee and various columns (e.g. 2 weeks, 1 month, 2 months, etc.) where the management can monitor if the performance reviews have taken place.

The flow it's actually working, but I keep receiving "Failed" messages. I wonder if anyone could help me understanding why.

Here is the flow:

Now more in detail

Where:

Compose 2 = outputs('Compose')?['Co-worker Name']

Compose 5 = outputs('Compose')?['Co-worker ID']

Compose 3 = outputs('Compose')?['Line Manager']

Compose 4 = outputs('Compose')?['Unit Number']

The Switch function will then define the "Email Subject". This will then trigger the below actions:

- 2 weeks review = "Add row in table"

- 1 month review = "Update row in table"

- 2 month review = "Update row in table"

And so on.

And so on.

When I run the flow I get the following error message:

But the flow itself has worked, as you can see here below:

I am still relatively new to Power Automate and really not sure why I get this error.

Thank you very much to anyone who is able to help. 

Ale

 

[Koen5]

Dear alessiom2003,

The error message is caused by a mismatch between the formatting of the target and the value you try to push there (update). For example, if the target cell is formatted to only accept 'Integer' (int) values, then a text string will not be accepted. 

Your solution lies in ensuring that the formats match up. You could either do this by re-formatting the target to accept any kind of format you define (set in Excel as 'General') or amend the value you are trying to write into the target format. This usually can be done via an expression.

Hope this helps you along the way, if so, please indicate in the thread as solution.

Happy flowing,

Koen

[Anonymous]

Dear  Koen, 

Thank you for your reply. I have followed your suggestion and I have formatted the table in Excel as "General", then changed the outputs without Int.

I stop getting errors, however, for some reason, I now get 2 rows instead of just one. Here is an example:

Do you have any idea how can I stop this from happening? 

Thank you very much 

Ale

[Koen5 · Accepted solution]

Dear alessiom2003,

Happy to hear this has helped, please indicate in the tread as 'Solution' for other users of the forum.

Suggest that you check the flow input/output for the various actions, especially the Apply_to_each loops.

I cannot imagine that the flow generates 2 rows within the same 'Add a row' action, so probably before this your Apply to Each loops picks up additional lines to process, producing additional rows.

Happy flowing,

Koen

[Anonymous]

Thank you very much 🙂

Ale