You’re offline. This is a read only version of the page.
Dear all,
I have been trying so hard to understand and fix the issue I encountered when trying to connect with an Excel file on OneDrive business. I formatted the table and followed the instructions but when the connection finished, the data was not loaded. I only see the title of the table - please see the screenshot below.
Can you please let me know what I did wrong here? Thank you so very much for helping me out with this.
Thu
Hi @Thu_Roberts ,
Glad to see you solved the problem.
You could mark your answer as a 'solution' to close the case.
Best Regards,
Charlie Choi
Dear all,
I worked it out now. The issue is I kept the Excel open while connecting in PowerApps. When I closed the Excel file, I worked perfectly. Thanks for your help with this - I was quite desperate!
Thank you for looking into this for me so quickly.
I think I formatted the table correctly as PowerApps could recognise it. However, you raised a good point - whether the table contains Data, then I'm unsure and I also don't know how to check it.
When I try to add a record, here is the error message:
"the requested resource is locked. Server response: Employee failed. Cannot write file to filesource. File is being locked".
Thank you.
@Thu_Roberts Are you sure that the "Table" you connected to contains Data? Are you connected to the correct Excel/Table?
What happens if you try to add a record? how does the EditForm looks like. Could you provide a screenshot of that screen?
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (