Skip to main content

Notifications

How to Filter Gallery with SharePoint with Blank Values Without Delegation Warning

Introduction:


In this Blog we will see how to Filter Gallery with SharePoint with Blank Values Without Delegation Warning.


Implementation Steps:

 

In this Blog am using Back End as SharePoint.

 

1. Navigate to https://make.powerapps.com

 

2. Click Apps 

 

3. Select Canvas App and Select Type as Either Phone Mode or Tablet Mode and input Name

 

rampprakash_0-1675845894941.png

 

4. Click Create

 

5. Add Data Source (Here in my scenario am selecting Data Source as SharePoint)

 

rampprakash_1-1675846039989.png

 

6. Add Gallery and Select Items as SharePoint

 

rampprakash_2-1675846163653.png

 

7. Now Select the Items as SharePoint List

 

rampprakash_3-1675846208613.png

 

 

8. Now Consider I need to filter the Title as Blank without Delegation Warning

 

9. If i use IsBlank then it will cause Delegation Warning

 

rampprakash_0-1675849999563.png

 

 

Delegation Code : Filter('Account List - New',IsBlank(Title))

 

10. Based on Below Code we can avoid Delegation

 

rampprakash_1-1675850072560.png

 

 

Non-Delegation Code: Filter('Account List - New',Title = Blank())

 

That's it :slightly_smiling_face:


This was originally posted here.

Comments

*This post is locked for comments