Using O365 Append Range in multi bot environment

Help Studio
1

Hi

We have multiple bots appending the data in sharepoint excel using o365 append range activity. It is authenticated through MS Graph API.

when multiple bots, at least 2 bots appends the data in excel at the same time, one of the bot information is dropped (blank rows) and other bot data is appended.

How to solve this concurrency issue?

I am using O365 Activities 1.9.0 in studio 21.4.3

Thanks
VJ

2

Hey @vijayakumarkj

Thanks for sharing the necessary info.

When you say the data is getting dropped, is it due to some file lock or the other bot overwrites the data itself.

Kindly confirm.

Thanks
#nK