Unanswered

Problem with sharing app (Excel list as Database)

(0) Share

Report

Posted on by tdzevad

Hi,

I'm having the problem with sharing the app with my community, actually the users are getting error that, the specified record was not found.

I've developed the app, which uses Excel Tables as Database (hosted on my OneDrive for Business), but users cannot use it.

All Excel files and other lists have already shared with users, and they can open it, but when they try to use the app, they are getting the following error. (attached picture)

The users are external users, already added in the tenant as a guest user.

I hope someone has any advice, what I'm doing wrong.

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

BCBuizer 22,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @tdzevad ,

Please try some of the proposed actions from this post:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Failed-to-load-Data-from-Onedrive-for-business-to-PowerApp/td-p/729796

Was this reply helpful? Yes No
meelamri 468 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I recommend moving your Excel file to SharePoint. Indeed, there is a limitation in the One Drive For Business connector. This one does not allow access to files that are shared between different tenants. You can refer to the following documentation: "Accessing shared files across tenant hostname boundaries is not supported. Example: a user in contoso-my.sharepoint.com cannot access a file in microsoft-my.sharepoint.com"

https://docs.microsoft.com/en-us/connectors/onedriveforbusiness/#known-issues-and-limitations

Please tick Accept as solution if the answer is useful.

https://xrmtricks.com/

Was this reply helpful? Yes No
tdzevad 46 on at

Like (0)

Report
Copy link

Link copied!

That could be a solution, but now I'm confused with so many errors after migrating to the Sharepoint lists.
The app is working normally with the Excel sheets, but after I migrated it to lists, there are over 300 Formulas errors.
What can be a problem with it?

Was this reply helpful? Yes No
meelamri 468 on at

Like (1)

Report
Copy link

Link copied!

No need to migrate everything to a SharePoint list. Just move your Excel file to a SharePoint Site and use the Excel Online (Business) connector.

Was this reply helpful? Yes No
tdzevad 46 on at

Like (0)

Report
Copy link

Link copied!

Good, that works, thank you so much!
But is there any solution to move from excel to lists, and avoid editing 500+ formulas?

Was this reply helpful? Yes No
meelamri 468 on at

Like (0)

Report
Copy link

Link copied!

After checking, I am afraid that even this approach will not work. External users cannot access the excel file via Power Apps. Could you please confirm?

Was this reply helpful? Yes No
tdzevad 46 on at

Like (0)

Report
Copy link

Link copied!

Correct, the only way I managed to use it was to migrate from excel to MS Lists. But I had to edit each Form etc...
Thanks for help!

And just one question, 😄 is it possible to define Email address which will be used for sending emails from App. e.g. booking@domain.com?

Current settings:
Office365Outlook.SendEmailV2(EmailTO.Text, "Buchung abgelehnt", AbgelehntManagerhtml.HtmlText, { Cc:"user@domain.com "});
But it is using user's Email address.

Edit! I've found a solution, not popular, but it is what it is. I have to add permissions for each user that can send from a defined address, or there is any other way to do it?

Thanks!

Was this reply helpful? Yes No