You’re offline. This is a read only version of the page.
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"
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:
Share
Report
All responses (
Answers (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.
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;
*/
}
)
Hi @siforibo ,
So the canvas app works in the web when you share and the users can utilize but not from the mobile app?
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.
hi @dpoggemann
yes i created the users role ,but the execute is not the same, it worked in power app web.
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?
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
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
