AnsweredAssumed Answered

Member of Group and Formatting Rules

Question asked by hcait on Apr 13, 2015
Latest reply on Nov 10, 2017 by rhia

Hi All,


we have to disable controls on a form based on a status, e.g if the Status is <> "Draft" then disable few controls. Its easy, we can do it via the Formatting Rules. However, we want the controls to be remain enabled if the current user is a member of a certain SharePoint Group. e.g. say if the user is a member of HelpDesk group, we leave the controls enabled, so that they can change them.


We are not able to work out how we can use this combination. Under formatting rules, we don't get the option to check if the user is a member of a SharePoint Group. Not quite sure how to make use of the userprofilelookup function for this (if we can).


In one of the Discussion, it was suggested to use  "Yes/No" control and then use Expression - fn-IsMemberOfGroup("HelpDesk") for the Default Value. This worked fine, but the default value does not gets recalculated when another user opens the form. Say, if User A is a member of HelpDesk Group, the Default Value is triggered correctly and the Yes/No control is checked. The form is saved but when user B opens the form, the "Yes/No" control remains checked, even if the user is not a member of HelpDesk Group.


Not sure how we can achieve this ? Anyone can shed their experience in case they had a similar requirement ?