Unanswered

How to have gallery only display certain documents

(1) Share

Report

Posted on by Fredemanze

Hi everyone

I am trying to make a gallery that only displays certain documents in my powerapp. I know that all name for that files I want to display will always start with '6' and have a '-' at the 8th position in the string.

I have tried different variations of what is seen in the photo above thus far, it keeps giving me an error.

Any help with this would be much appreciated

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report
value is not a correct syntax in Power Fx,

It has to be an uppercase V,

Value

try that see if it helps

Like the below:

Value

See if this helps @Fredemanze

Was this reply helpful? Yes No
Fredemanze 18 on at

Like (1)

Report

Thank you @poweractivate , that worked for hiding these. However the lines where these were are now just blank, is there any way to make it so these disappear completely?

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report

@Fredemanze
Yes try going into the Height property of especially the Rectangle2 (probably only that one) and try using same formula you used, except instead of true, false, use (whatever was there before), 0

Was this reply helpful? Yes No
Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report
Instead of using the child controls of Gallery, see if changing the Items property to below formula may be a better approach for you, then leaving the child controls untouched.

Try with a new Gallery and see if the below formula works for you:

You place the below formula in the Items property of the Gallery:

Filter(yourDataSource, StartsWith(Name, "6"))

Replace yourDataSource in the above with the actual name of your data source.

If approach above doesn't work for you, you can continue the approach you were doing.

However, above may be a better approach for you.

I intentionally do not use Left, Value, etc. in the above Filter as these are likely not delegable.

However its seems you simply want to check if the Name starts with a "6" so the above filter may work, as it's not important if the value type is a number or not, just seeing if the name starts with "6" in particular may suffice and may be fully delegable as well.

See if it helps @Fredemanze

Was this reply helpful? Yes No
Fredemanze 18 on at

Like (1)

Report

Yes this worked much better for me. Thank you @poweractivate !

Was this reply helpful? Yes No