Power Platform Community Forum Thread Details

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

Quick Links

Leaderboard > Power Pages