Unanswered

Error retrieving data from Power Apps network in power apps and dataverse

(0) Share

Report

Posted on by siforibo

hello,

I create an app with power apps with sharePoint list, it has worked perfectly (so I am asserting that the code is good). I changed sharePoint list to Dataverse I create the tables and related it with power apps,When I tested the app in navigator, it worked, but when I share it, and tested it on mobile, return this error "Error retrieving data from Power Apps network in power apps". To check if the app gets the tables, I created a gallery and related it to the Dataverse table, I find that the app gets the tables with success.
But always it show the same error "Error retrieving data from Power Apps network"

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @siforibo ,

If you moved the data to Dataverse tables, did you create security roles for the tables and assign these security roles to your users so they can access the tables? If you do not do this then the users will not have security to work with the data.

https://learn.microsoft.com/en-us/power-platform/admin/database-security

Specifically: https://learn.microsoft.com/en-us/power-platform/admin/database-security#create-or-configure-a-custom-security-role

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

Just to make sure - do you have Power Apps Premium licenses assigned to your user account? I know that you can create and test it from the maker portal just fine, but it seems like sharing a 'published' version doesn't work so perhaps a license check is preventing you or your users from accessing it?

Was this reply helpful? Yes No
siforibo on at

Like (0)

Report
Copy link

Link copied!

hi @dpoggemann
yes i created the users role ,but the execute is not the same, it worked in power app web.

Was this reply helpful? Yes No
siforibo on at

Like (0)

Report
Copy link

Link copied!

hi @ivan_apps yes i have a Premium licenses, and To check if the app gets the tables, I created a gallery and related it to the Dataverse table, it shows me the error ,after the app gets the tables with success.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @siforibo ,

So the canvas app works in the web when you share and the users can utilize but not from the mobile app?

Was this reply helpful? Yes No
siforibo on at

Like (0)

Report
Copy link

Link copied!
hi @dpoggemann , I analysed the application and found the cause of the problem .the problem is in two patrie :
the first error when I use this code (it worked in the web and it get all data, but when I use the app it get an error)
ForAll( Filter( pos; 'id-pos' in collpossuperviseur.id_pos ); 'id-pos' );
it work with this code,( 'id-pos' is a text column in Dataverse) .
ForAll( Filter( pos; Text('id-pos') in collpossuperviseur.id_pos ); 'id-pos' );
But it didn't return all id-pos (there are over than 10000 pos) it was showing me delegation warning.
The second error it when I patch the images
Patch( reclamation; Form1.LastSubmit; { photo_num_serie: {Value:Image2.Image;Full:Image2.Image}; photo_produit: {Value:Image4.Image;Full:Image4.Image}; photo_produit_arriere: {Value:Image5_1.Image;Full:Image5_1.Image}; photo_produit_face: {Value:Image6.Image;Full:Image6.Image}; /* photo_num_serie: Image2.Image; photo_produit: Image4.Image; photo_produit_arriere: Image5_1.Image; photo_produit_face: Image6.Image; */ } )

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @siforibo ,

You are tying to filter the rows from pos table where the value of the id-pos text field matches a field value entered in the canvas app or are you trying to match to specific value that is entered or where the supervisor is populated with that value? My thought here is to get rid of the For All if possible.

Filter based on exact value:

filter(pos, id-pos = formVariable.Text)

Another example where you can do an "in" type of response that looks at the field based on a value you have and returns all from Dataverse table that matches the value

search(pos, txtInputSearch.Text, "id-pos")

Both of these can be delegated where the first one will filter based on the value matching exactly a field value you pass in and the second one searches within the field for partial matches.

Here is the link to the delegation rules for Dataverse:  https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-common-data-service#power-apps-delegable-functions-and-operations-for-dataverse

Please let me know if this is what you are trying to do.

Was this reply helpful? Yes No