List rows present in a table - Cant connect as other user checked it out
I am connecting to an excel table on a Share point site that is shared with others. I use the 'List rows present in a table' function as below;
As you can see I get an error stating that I cant connect as it is already locked out. I checked the file on share point and right enough the file was checked out to someone else. This is a problem as we want to run a flow on the excel sheet (we are just reading it not updating it) with a recurrence set to every day, but still allow all the users to check out / check in etc.
Is there a way to connect but still allow users to update etc.
A further question - If my flow is turned on all the time and I have a connection to the Excel file on Share Point, does that mean that the file will appear as checked out to myself permanently? We did a check and noticed that every time I created a connection via the 'List rows present in a table' in my flow other people could not edit the file as it would appear checked out to myself. Just wanted to check if this was the case.