You’re offline. This is a read only version of the page.
Announcements
8
I’m working on a PowerApps-based ticketing system where users submit service requests stored in an Excel file. Power Automate is used to send email notifications when a new request is created.
Initially, I stored the Excel file in OneDrive and connected it to PowerApps and Power Automate. However, I ran into a major issue. When Power Automate runs, it locks the Excel file, preventing users from submitting new tickets in PowerApps. I have to wait for a while before I can create a new request. It seems like PowerApps and Power Automate can’t access the Excel file at the same time.
To fix this, I moved the Excel file to SharePoint and used the Excel Online (Business) connector in PowerApps. But using SharePoint is not that effective as OneDrive, since while using SharePoint, I am getting warnings that certain operators might cause issue when large data is there
This was not there when using OneDrive, but now it’s happening with SharePoint.
1️⃣ Is there a way to prevent the Excel file from getting locked in OneDrive while Power Automate is running?
Share
Report
All responses (
Answers (
