How to add permissions on a gallery.

[Anonymous]

I have a gallery that is currently using the below formula allowing me to select between different items depending on their status, as well as the ability to search through the search bar.

Search(AddColumns(

Filter('Hire Authorisation Submit',_requestTypeFilter = "All" ||

Status.Value = _requestTypeFilter),"Field5Text",Department.Value),

'Hire Authorisation Search Bar_1'.Text,"field_6","field_7","field_8","field_9","field_4","Field5Text")

I’m looking to add an additional item to this formula meaning users can only view the form responses that they’ve submitted and are linked to their email. What would I need to add to the above formula to make this work, please?

I've had a try with a few if and filter formulas but I can't seem to make them work within the above formula.

Data source: 'Hire Authorisation Submit'

Search bar name: 'Hire Authorisation Search Bar_1'

Column within the data source for email field: ‘email’ / “field_3”

[RandyHayes · Accepted solution]

@Anonymous 

Add that to your formula!

Example:

Search(
    AddColumns(
        Filter(
            Filter('Hire Authorisation Submit',
                 <yourUserCriteriaHere>
            ),
            _requestTypeFilter = "All" || Status.Value = _requestTypeFilter
        ),
        "Field5Text",Department.Value
    ),
    'Hire Authorisation Search Bar_1'.Text,
    "field_6","field_7","field_8","field_9","field_4","Field5Text"
)

I hope this is helpful for you.

[Anonymous]

Thank you @RandyHayes, really appreciate the help! I'm using the formula:

Search(
AddColumns(
Filter(
Filter('Hire Authorisation Submit',Email = User().Email
),
_requestTypeFilter = "All" || Status.Value = _requestTypeFilter
),
"Field5Text",Department.Value
),
'Hire Authorisation Search Bar_1'.Text,"field_6","field_7","field_8","field_9","field_4","Field5Text")

This seems to be working perfectly across the pending, approved and declined selections, however, no items are pulling through in the all selection (as the screenshot below shows). 

The error message is also in the screenshot. I've played around with a lot of alternatives as well as refreshing the data set, but still no luck. Do you have any ideas as to how I can solve this, please?

[RandyHayes]

@Anonymous 

Sorry for the delay in response.  I see you marked this as solved earlier.  Did you figure out your last question or are you still having that issue?

[Anonymous]

@RandyHayes No worries at all, I'm actually still having the same issue, I've deleted the status buttons for now. 

The below formula seems to be working perfectly across the pending, approved and declined selections, however, no items are pulling through in the all selection (as the screenshot below shows). 

The error message is also in the screenshot. I've played around with a lot of alternatives as well as refreshing the data set, but still no luck. Don't suppose you have any idea's, please?

I'm using the formula:

Search(
AddColumns(
Filter(
Filter('Hire Authorisation Submit', 'User Email' = User().Email
),
_requestTypeFilter = "All" || Status.Value = _requestTypeFilter
),
"Field5Text",Department.Value
),
'Hire Authorisation Search Bar_1'.Text,
"field_6","field_7","field_8","field_9","field_4","Field5Text"
)

[RandyHayes]

@Anonymous 

What kind of column is 'User Email' in your list? 

[Anonymous]

@RandyHayes A single line of text

[RandyHayes]

@Anonymous 

And this is a SharePoint list you are working with?

If so, then just to state what we are looking at...when you choose a status like "Pending" you see results and no error, but if you choose "All" you see no results and get an error.

Is that correct?

[Anonymous]

@RandyHayes yes correct, I can't for the life of me figure it out, all of the filters work individually, just the all section does not when they're all together.  Could the issue be with the below part?

_requestTypeFilter = "All" 

[RandyHayes · Accepted solution]

@Anonymous 

Let's provide some specifics for the formula...change it to the following:

Search(
    AddColumns(
        Filter('Hire Authorisation Submit', 
            'User Email' = User().Email &&
            ((_requestTypeFilter = "All") || Status.Value = _requestTypeFilter)
        ),
        "Field5Text",Department.Value
    ),
    'Hire Authorisation Search Bar_1'.Text,
    "field_6","field_7","field_8","field_9","field_4","Field5Text"
)