Combining two statements

(0) Share

Report

Posted on by send2mark

505

Using a Gallery how do I combine these two statements?

Items=Filter('Site Pages','Folder path' = "SitePages/Folder1/Folder2/")

Items=Choices('Site Pages'.Category)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@send2mark

Like this...

Choices( Filter( 'Site Pages', 'Folder path' = "SitePages/Folder1/Folder2/" ).Category )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
send2mark 505 on at

Like
a
(0)

Report
Copy link

Link copied!

It is returning the following error.
The function 'Choices' has some invalid arguments.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@send2mark

I'm looking at your original question a little more closely and I'm finding the request to combine both statements does not make sense to me. Why? CHOICES will always return the same values no matter what. Filtering the result of CHOICES would have no effect.

Are you trying to find the unique values in the categories column? If yes, please try the DISTINCT function.

Distinct( Filter( 'Site Pages', 'Folder path' = "SitePages/Folder1/Folder2/" ), Category.Value )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
send2mark 505 on at

Like
a
(0)

Report
Copy link

Link copied!

I am returning file properties from a library that is two folders deep and grouping them by a column name of Category. Maybe it would be easier to go a different route other than using the 'Folder path' option? Maybe one of the Categories could be called "NoGroup" and I could exclude it. What do you think?

I should have added this in the first place. What I am doing is step 4 from this site.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@send2mark

Hello there Mark! Perhaps the best approach here would be to post some sample data. Then show me what the result should look like. You can do this by copying and pasting data from Excel if necessary.

The link to Yammer doesn't work for me but that's OK. I'd prefer to hear you explain the problem anyway.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
send2mark 505 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm sorry, I must have had that link on my clipboard without realizing it. Here is the correct link.
https://www.c-sharpcorner.com/article/expand-and-collapse-view-using-nested-gallery-powerapps/

In this image, Admin is a value in a column in a Site Pages library called Category. Those below it called Topic of Training TEMPLATE and Training Content are pages within that library at the root of the library. I do not want anything in the root.

Item=Choices('Site Pages'.Category) is what displays my groups Admin, Analytics, Back-up and Retention, etc.

Was this reply helpful? Yes No