Conditionally Hide Menu Options in Subgrid

[CassandraG]

Hi,

I feel I'm close, but I'm not a pro dev, and I'm a little stuck figuring out the custom javascript for this.

Within a form, I want to allow users to edit the related record, if the related record is one status ("Revise and Resubmit"), but I want to hide the dropdown if the status is null or "Approved." 

Here's the custom javascript:

$(document).ready(function() {
    var entityList = $(".entity-grid").eq(2);
    entityList.on("loaded", function () {
        entityList.find("table tbody > tr").each(function (index, tr) {
            var td = $(tr).find('td[data-attribute="cjg_justificationstatus"]');
            var statusCell = $(tr).find('td[data-attribute="cjg_justificationstatus"]').text()
            console.log(statusCell);
            console.log(statusCell == "Approved")
            if (statusCell == "Approved") {
                //(td).css("font-wight", "bold");
                console.log("is bold!")
            }
        })
    })
});

I feel like the answer is within this, but not sure how to put them together: Power Apps Portals – Entity List: Making the entire row clickable – Oliver Rodrigues (oliverrodrigue...

I also tried this, and couldn't get it to work for me (might be missing something): Power Apps Portals – Entity List: Conditional Action – Oliver Rodrigues (oliverrodrigues365.com)

I have another use-case where I need to hide/show menu options based on the information within the record (e.g. hide "edit" if approved; show "View Contract" if there is a file loaded." So, I'm thinking I could modify and re-use the solution above.

[OliverRodrigues]

Hello, the 2nd blog post of mine that you shared should have solved your problem, did you add the FetchXML or how far did you get with that solution?

[CassandraG]

I did try the filtering and think that'd be best if I can make it work. I copied/pasted the code, updated the entity and attributes, and it seems to have no impact on the list. Do you know what I could be missing?

[fm_skeller]

Using the filtering option is the way to go and it looks as though it should work. Did you refresh the portal cache after you change? And also, it might be that the filter is the wrong way around? I would expect the first row in the screenshot to not have the option in this case?

[CassandraG]

I'm definitely refreshing the cache. Regarding the filter being the wrong way around, the idea is that if there isn't a file, they shouldn't be able to upload another file (so hide the menu option to upload a resolution file). So hypothetically, I should be able to substitute emailaddress1 with the logical name of my column for the contract file. Unless files don't work with that operator "not-null"?

[fm_skeller]

So just to be sure - for  ("Revise and Resubmit"), but I want to hide the dropdown if the status is null or "Approved."  the filtering is working - just not for the file column?

[fm_skeller]

Is this (kind of) what you are trying to achieve? I've create two Item Actions that are shown/hidden based on the file column having an associated file.

using either the "null" or "not-null" operator on the file column:

<fetch top="50">
  <entity name="bp_defaultapplication">
    <filter>
      <condition attribute="bp_fileupload" operator="not-null" />
    </filter>
  </entity>
</fetch>

[CassandraG]

Thanks! That's exactly what I'm trying to do. It's just not working on my end. 

<fetch version="1.0″ output-format="xml-platform" mapping="logical" distinct="false">
    <entity name="cjg_waiverapplication">
        <filter>
            <condition attribute="cjg_contractfile″ operator="not-null" />
        </filter>
     </entity>
</fetch>

(The buttons with contract files also display "upload resolution," so I'd think if the filter was doing something one or the other wouldn't show. "Test #" is just additional assurance it's updating from Portal Management.)

Is there some other setting in the list in Portal Management or some setting with the View in Dataverse that could be preventing this from working? 

[fm_skeller]

I can't think of a any setting - other than that the file column support is a fairly recent addition to Power Pages. What is the portal version and the version of the portal solution(s) you are using?

[OliverRodrigues]

I replied days ago here but my answer never went through 😢.. apologies for that
I tested this on the enhanced data model using a file column and got it working as expected, so not sure what the issue is here.

<fetch top="50">
  <entity name="account">
    <filter>
      <condition attribute="cr0ea_filecolumn" operator="not-null" />
    </filter>
  </entity>
</fetch>