Answered

Issues with connection DocuSign-Excel

(0) Share

Report

Posted on by Community Power Pla...

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.

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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Unknown geen idee 1,757 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Unknown geen idee 1,757 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you very much 🙂
Ale

Was this reply helpful? Yes No