cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
praneshJ
Helper III
Helper III

why web Template not returning any data from adx_entitypermission Table?

Hello Experts,

 

I have requirements from clients that, based on privileges(Read, Create, Write, Append etc) from table permission hide and show content through custom code(JavaScript).

So, I have created web template to read the data from table "adx_entitypermission" but this web template is returning no data although there is data present in the table "adx_entitypermission".

 

I am not sure why its not returning the data. 

Is there any other way to read the privileges from the table "adx_entitypermission" and its values?

Please refer the web template code below 

{% fetchxml ResultData %}

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="adx_entitypermission">

<attribute name="adx_append"/>

<attribute name="adx_appendto"/>

<attribute name="adx_write"/>

<attribute name="adx_entityname"/>

</entity>

</fetch>

{% endfetchxml %}

{% if ResultData.results.entities.size > 0 %}

{

“results”:

[
{% for Data in ResultData.results.entities %}

{

"adx_append":  "{{Data.adx_append}}",

"adx_appendto": “{{Data.adx_appendto}}”,

"adx_write":  "{{Data.adx_write}}",

"adx_entityname": “{{Data.adx_entityname}}”

}

{% unless forloop.last %},{% endunless %}

{% endfor %}

]

}

{% else %}

No data found.

{% endif %}

 any quick help is really appreciable.

 

Best Regards,

Pranesh 

1 ACCEPTED SOLUTION

Accepted Solutions
praneshJ
Helper III
Helper III

This issue is resolved,

There was missing table permission for table "adx_entitypermission" and privilege(Read) because of this it was not returning any data.

 

Thanks,

Pranesh 

View solution in original post

3 REPLIES 3
praneshJ
Helper III
Helper III

This issue is resolved,

There was missing table permission for table "adx_entitypermission" and privilege(Read) because of this it was not returning any data.

 

Thanks,

Pranesh 

View solution in original post

v-albai-msft
Community Support
Community Support

Hi @praneshJ ,

Glad that you have found the solution and thanks for your sharing!

Best regards,

Allen 

OliverRodrigues
Super User II
Super User II

Have you tried using the Liquid Object for table permissions? 

https://docs.microsoft.com/en-us/powerapps/maker/portals/liquid/liquid-objects#table-permissions

 




If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Power Apps Portals Super User


Oliver Rodrigues


 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,064)