I have the following situation:
I have an Excel file with 2 columns:
From another file I read data for B and C column.
On Column B I have dates like 2/25/2021.
On Column A I have a formula =Text(B1, “MMMM”) // should return the name of the month - February.
My workflow is like this:
dtSource = readRange from source file;
writeRange on col B,C in destination file; // writes all data on col B and C
assign colAFormula ="=Text(B1, ““Mmmm””)";
buildDataTable (Culmn A as string) as tempTable
addDataRow activity colAFormula to tempTable;
writeRange A1 tempTable;
autofill A1:A1 as Source => A1:A100 as destination;
when I run the project from uipath studio it works fine; on Column A I have January;
when I run the project from the orchestrator on Column A I have number 100 instead of January.
Your reference: \\uipathserver01.company.intra\UIPath\uiPathFiles\autofill-sources\source.xlsx looks to me more like a SharePoint address and, for this you should have something like: ...\DavWWWRoot\... within the syntax
It is a SharePoint.
But I am able to access the file.
The formula is written in excel file, but when I open the excel file it instead January I see 100 on column A.
In this case do you think DavWWWRoot is the issue?