Block automation - copy file to sharepoint error

[random_user_3869]

Hello everyone,

I have face the issue on the copy to sharepoint block ?

Anyone know how to correct this issue ?

Thanks

[Madhushree_BP]

Hi @random_user_3869 ,

Could you please check if the source file input is passed with the correct filename?
Use the "Open file" block before the copy file block.

Thanks

[AfeefaTk]

Hi @random_user_3869 

Could you please share the screenshot of the input section that is being sent to the block?

I suspect the issue is with the 'Source File' input parameter, where you might be sending a null / incorrect value. As mentioned in the field description you should use the block "Open file" first and then select the file from this dropdown field as an input to the 'Source File' input parameter

Also if you could share the whole workflow, maybe a screenshot or automation JSON file would help us further troubleshoot the issue

Thanks!

Afeefa TK

[random_user_3869]

Hello everyone, 

Here is the screenshot

[random_user_3869]

Hello,

I don't really understand what you say by using the open file on microsoft sharepoint first.

I usually generate report then copy the output file to the sharepoint.

By placing open file in beetween what i understand is that this block will search a file in sharepoint folder.

And what i want is :

1. Generate the report

2. Use the output from 1 and copy it to sharepoint

[AfeefaTk]

Hi @random_user_3869 

Sorry for the confusion here
If you are using the "Generate Report" block, you can exclude the "Open file" block from the workflow.

You can simply select the "Generate Report" block output from the dropdown of the 'Source File' input parameter and that should work

Thanks!

[AfeefaTk]

Hi @random_user_3869 

From the screenshot you have shared, As mentioned before I see the source input parameter value is null because of which you are getting some error

What is the output from the "Generate Report" block?

Are you able to see the "Generate Report" block as a dropdown in the "Source File" input parameter

Thanks!

[random_user_3869]

Hello,

Here is the json.

Thank you.

Because i don't understand at to process the issue

[AfeefaTk]

Hi @random_user_3869 

Thanks for sharing JSON file

It seems you have properly mapped the Generate Report block to the Source file input parameter. 

Could you please send screenshot from the chronological overview that contains both the inputs & the outputs of the Generate Report block?

Something like this :

It seems you have set the automation to continue and ignore errors for Generate Report block. It could be worth checking if the 'Generate Report' block itself is failing, hence causing Copy file block to fail 

In order to stop automation if the block fails, change the 'On error' settings of Generate Report block and select option "Stop - Stop Automation and set to failed"

Please let me know if this helps to identify the issue

Thanks!

[AfeefaTk]

Hi @random_user_3869 

Adding to my previous comment
If you are still not able to point out the root cause, Could you please share failed job run log file

You can get it by navigating to specific failed job run history, click on the Export this run button, save it as JSON file and share the JSON file

Thanks!