FetchXML not working to show edit option for particular record

[gopika_G]

Hii,

I need to show edit option in the list only for the record with particular stage(Datatype-choice).I used the following fetchXML

<fetch version="1.0″ output-format="xml-platform" mapping="logical" distinct="false">
<entity name="crbcd_ma_requestdetails">
<filter type="and">
<condition attribute="crbcd_requeststage″ operator=”eq” value=”16” />
</filter>
</entity>
</fetch>

But the edit option is available to all records. Do I need to do any other configuration apart from adding fetchXML in filter criteria? and also when I click advanced find It says no tables in portal management is that also a reason?

Waiting for your response. Thanks in Advance.

[OliverRodrigues]

I have an article on that topic that might help. See if the steps you followed are the same: http://oliverrodrigues365.com/2020/04/26/power-apps-portals-entity-list-conditional-action/

[gopika_G]

Hi @OliverRodrigues ,

Thanks for the reply I have followed the same steps, but still, I have edit option for all records.

[Fubar · Accepted solution]

I am assuming "crbcd_ma_requestdetails" is the entity used for the List, and that after making any updates you have Synced/Cleared the Portal Cache.

Verify the query is valid by trying it in XrmToolBox fetchxml tester or builder.

Try just putting the <filter> block in (List does not usually need the full FetchXML, whereas Subgrids do need the full FetchXML)

[gopika_G]

Thank you @Fubar 

The problem is with the code, I checked the fetchXML in https://www.ashishvishwakarma.com/FetchXmlTester/

and made changes now it's working fine.