I have an issue and I cannot find out how to solve it.
Here it is:
I have a sharepoint excel file which I donwload woth GET FILE (sharepoint activity) to my desktop. The withEXCEL APPLIACTION SCOPE I do some changes in the file. Than with UPLOAD FILE (sharepoint activity) I upload the updated file back to sharepoint.
The issue is that once I open the uloaded file on the sharepoint the excel sometimes does not contain those changes and tells me to “refresh” by saving as a copy…unfortunately this does not happen always, only from time to time.
I noticed with the SharePoint activities that you must refresh the SharePoint site of the file, before the changes are displayed online (if e.g. the file was already open in SharePoint Online).
So do you check the changes within the file, while the file is still open in SharePoint online, or do you only open the file, after the upload?
You say, that the issue only happens sometimes. Can you see any difference in the files when the problem occurs? Maybe the filename contains special characters (that sometimes caused problems). Maybe the file is bigger in the cases the error occured? Maybe something else?
I guess that it is probably because the name of the file contains special character.
I guess that we will probably have to live with that and my colleagues will have to click discard the changes to see what the robot did.