Power Platform Community Forum Thread Details

I created a Power Fx Function, added it in a solution and using it in a custom page. To use the function, I connected to the Environment table. Everything works fine.

However, when I publish the solution to our production environment, users are not able to access the Power Fx Function. They are getting an error like below:

Environment.<name of my function> failed: {"error": {"code":"0x80040265","message":"Plugin failed with: Error attempting Query Microsoft.Xrm.Sdk.Query.QueryExpression returned nothing. Principal user (Id=xxxx..., type=8, roleCount=2, privilegeCount=465, accessMode='0 Read-Write', AADObjectld='xxxx...', MetadataCachePrivilegesCount=5701, businessUnitld=xxxx...), is missing prvReadCustomAPI

It seems that the users are missing priveleges to access the function. I have a security role created which has read/write to all the tables the function is using. I cannot add the Environment table to the security role because that table does not show up in the roles configuration.

So, I'm at a loss and don't know how to grant permissions to the Power Fx function for all the users. It works for me because I have elevated priveleges. I know that the Power Fx Functions are still in Preview so this could be something not thought of or implemented.

If any of you have any advise, I would greatly appreciate it to hear about it.

Categories:

Microsoft Dataverse with Power Apps