Unanswered

Error when trying to retrieve data from the network lookup field when not a system adminitrator role

(0) Share

Report

Posted on by TheKnight

I have published a power app that uses 3 tables. For one table I want to retrieve a column value by doing the following:

Coalesce (
 LookUp(
 'Schema.Table',
 Category = "String1" && ItemCode = VarM.Item.ItemCode
).ValueColumn,
"-")

I want to match the category column with a string value and the ItemCode with the Itemcode from the variable of the item that I am currently observing in the app.

The weird thing is that everything works fine when I assign the 'System administrator' role to a user. But when a user only has a custom role where he has all(!) the rights for these tables set to 'organiation', it doesn't work. In that case it gives the error 'Error when trying to retrieve data from the network'.

The table is a virtual table which retrieves data from an sql server.

I saw some posts saying that this error is due to performance of the lookup formula, but that does not match with the fact that it works when a user has the role system administrator. Does anyone know what the issue might be here?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

This will tell you almost for sure what the real problem is.

Steps:
1. With app not running click the Stethoscope in the top Right

2. Click on Open Monitor at the bottom

3. Once that loads up, go back to your App Tab and run it

4. Do ALL the steps right up until you want to click the button or whatever actions triggers the code above.
5. Swap to the Monitor and Clear all the current collected data

6. Then in the Monitor, Click Options top right and change Source Filter to Detailed
7. Now swap to your App and force the issue to happen. Soon as you do swap back to the Monitor and you will see lots of lines of stuff. It may lag, it might hang.. just wait it out.
Click on Filter and type Error
Look for the error that you are getting and look at the details. If its a security issue or something specific it will say. If you aren't sure how to read it please post the output here (not all lines just the error) and I can help.

Also you may filter on the command you did (patch, lookup etc, separately from the error search, which is the important part).

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
ofs 76 on at

Like (0)

Report

I have the same issue here and feel like I am wasting my time to search in the darkness after many trials...
the environment is quite similar to Mr. @TheKnight :
Powerapps requests LookUp to Sharepoint list, in non-admin user (who admin shared my app to)
I created brand new app & re-build the error situation. I confirmed what happened between 2 cases (using LookUp & not using LookUp) then this "Error when trying to retrieve data from the network" occurs when using LookUp.

I read many similar issue cases in this community and here's what I tried/already did:
- I don't have any lookup columns in any sharepoint lists of mine.
- already granted this user an "Edit" permission to sharepoint list at "permission for this list"
- Dataverse works fine, only Sharepoint lists are not working when using LookUp from PowerApps
- deleted all the sharepoint lists from the app then added again, no luck
- re-published & unshared/shared the app to this user, no luck

It was working brilliant until around April, but all of a sudden dragged me into all these frustrations around these months. My clients cannot process any work with my apps at this moment & I have no clue. Please HELP!😫

Was this reply helpful? Yes No