search and filter and if function on gallery iteam

[mbhatt]

Hello Everyone, i am trying to use filter function with if condition and also i want to search ticket id please suggest formula to can use all are in gallery items and also way to provide default value. i have table which is showcase the status of tickets i want to use this for admins only to can find the records and search bar too . now from user side i want they can able to see only own data without search function and filter table and admin can see all of this . please help a little bit as i solved  a filter part but search formula not working also filter table formula not working. with this formula user not able to see any records , any idea ? 

[mbhatt · Accepted solution]

fo i need to put any codes on app start or on visible property ? or default of gallery ??? because i believe that delegation warning comes ...also whats wFilter ?  this wFilter used for which parameters ? and why ? 

[mbhatt · Accepted solution]

@LuizVicente please suggest me what should i do in my case i have attached all screenshots of errors 

[WarrenBelz · Accepted solution]

@mbhatt ,

It is answering your original posted question (Items of a gallery).

[LuizVicente · Accepted solution]

---

@mbhatt wrote:

@LuizVicente please suggest me what should i do in my case i have attached all screenshots of errors 

---

It should work like this:

If(
    User().FullName = "Maulik Bhatt",
    SpCollection, // <-- You created this collection in App.OnStart.
    Filter(
        SpCollection,
        'Created By'.DisplayName = User().FullName Or ID = Value(TextInput6.Text)
    )
)

Also, there's one other thing I should point out:

The instructions below for creating the AdminID collection are mutually exclusive. It will just waste your app's resource that could go to another formula that is really important.

[mbhatt · Accepted solution]

Hello Sir , 

I used your solution but its look like this 

no data showing on my dashboard also i get another error on 2nd screen on 

please have a look 

[LuizVicente · Accepted solution]

Right.
You have to debug the app. Use this tool for that:

[mbhatt · Accepted solution]

Hello Sir ,

Thanks for the help but i am not familiar with this

could you please refer the formula if you can i am glad to having help from you.

[LuizVicente · Accepted solution]

No problem, however I suggest you start using it in future projects.

Anyway, we need to make sure there is data in the collection (mostly created by other users for testing purposes). I'm not sure if your collection will have the column 'Created' or 'Created By', it will probably have the column 'Author'. Test the filter with this column:

Author.Email = User().Email

[mbhatt · Accepted solution]

in my collection i have all column which is come from sp list but i could not see the data and one more thing that 

i set clearcollect spcollection with all column in onvisible property of screen however i also set clearcollect and collect formula in app onstart do i need to add another things ? i think so might this are not sufficient  maybe i have to also use loaddata and save data ??? so maybe this warning not throwing delegation or i think so in my collection nothing bcz its not save in my collection and before was show in my collection when i was not having clearcollect but was duplicate multiple data show so i add clearcollect 

suggest me something help me with this headech i m very curious to know different methods from your genius people skill  

[LuizVicente · Accepted solution]

We'd better go piece by piece.

Is 'HH Power App' your SharePoint list?

- If so, is there data there?

- Is the collection empty?