Answered

Galleries - hide a secret item

Like (0) Share

Report

Posted on 24 Mar 2020 14:12:58 by Community Power Pla...

Hello all! Is there a way to flag an item (which was registered by a Papps form) as secret, so it keeps stored in a sharepoint list, but a gallery can't find it?

Thanks in advance!

Categories:

General Questions

I have the same question (0)

All responses (6)

Answers (1)

Community Power Pla... on 25 Mar 2020 at 19:47:29

Like (1)

Report

Re: Galleries - hide a secret item

I've discovered the "||" (double pipe) and was able to merge both! But using "StartsWith" instead of "Search"

Filter(projetos_lista;top_secret = "NAO";StartsWith(Title;SearchInput1_1.Text) || StartsWith(codigo;SearchInput1_1.Text) || StartsWith(SRS_VIP;SearchInput1_1.Text))

Was this reply helpful? Yes No
Community Power Pla... on 25 Mar 2020 at 14:20:18

Like (1)

Report

Re: Galleries - hide a secret item

I've obtained success making the SP column as a single line of text and using your second function! Very thanks for that. But, as I use a Search function too, I'm having trouble merging both.

I've tried to put like this (currently using the portuguese version of the studio):

Filter(projetos_lista;top_secret = "NO");; Search(projetos_lista;SearchInput1_1.Text; "Title"; "codigo"; "SRS_VIP")

I have a text field that I use for search purposes.

Can I merge both like this?

Filter(projetos_lista;top_secret = "NO"; Search(projetos_lista;SearchInput1_1.Text; "Title"; "codigo"; "SRS_VIP"))

Was this reply helpful? Yes No
SkiDK 1,016 on 25 Mar 2020 at 13:49:14

Like (0)

Report

Re: Galleries - hide a secret item

yes
grts

Was this reply helpful? Yes No
Community Power Pla... on 25 Mar 2020 at 13:36:25

Like (0)

Report

Re: Galleries - hide a secret item

Inside the "items" property, you say?

Was this reply helpful? Yes No
v-siky-msft on 25 Mar 2020 at 03:58:45

Like (0)

Report

Re: Galleries - hide a secret item

Hi @Anonymous ,

Use Filter function to filter out the secret record, please try this code:
Filter('SP list", ID <> 1) // asume the secret record id =1

Hope this helps.
Sik

Was this reply helpful? Yes No
Verified answer

SkiDK 1,016 on 24 Mar 2020 at 14:45:19

Like (0)

Report
Re: Galleries - hide a secret item

I don't know whether you have a flag or some field in the SP list that shows if its secret or not?
In the control you can then filter on the SP list to show all non-secret items. Small examples below.
Filter(SP_List, not(IsSecret)); // if secret is a yes/no field in SharePoint Filter(SP_List, Secret = "Not secret"); // in case you're using a string

Was this reply helpful? Yes No