Hi, Kinda new to Power Automate but have already made many flows
I have 2 workbooks lets call them A & B.
A is always being updated with new data and B is reading A's data. B has various conditional formats which activate a True or a False.
Power automate picks up the True and runs an email. All working ok
However, Workbook B doesn't read the updated figures in A without it being opened and resaved first. (I can't power automate from A BTW)
I just want Power automate to Open, Save and Close B workbook. I have set this in PA but it wont' run as I get the message
xxxx.xlsb is open in another application. Please close it and try again. WHY IS IT SAYING THIS ?
Both A & B are on a Share point (Onedrive)
Thanks in advance
