How to Get filtered value in gallary control in Canvas App

(0) Share

Report

Posted on by Prakhar_Gupta1

Hello,

I have Gallery control, which is connected with Collection,

& in the gallery, one is label control - which shows a status value from Sharepoint Datasource.

What I want is -

1. I want the pending requests should be visible on top or can be filtered with some kind of dropdown.

2. I am unable to achieve this functionality because - the Gallary item property contains a collection, & that label text is fetching value from SharePoint list.

PS: Attached the screen shot,

please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sid_98 103 on at

Like (0)

Report
Copy link

Link copied!

Hi @Prakhar_Gupta1 ,
You can add the status column in your collection based on the corresponding record and then you can use that filed in the label in your gallery. That would be easier for you to filter the gallery. Can you tell if the collection is created with SharePoint list data?

Was this reply helpful? Yes No
Prakhar_Gupta1 51 on at

Like (0)

Report
Copy link

Link copied!

Hello @Sid_98
Actually, i have 2-3 list in SharePoint, in which list_1 is the main list (That contains the status column) & list_2 contain some information with is linked(in a relationship) with list_1.
I am managing relations with the CI_ID column name.
1. now the gallary control item property is Collection that is linked with list_1
2. but the label inside that galley control is fetching its value directly from list_2(that also contains a status column).

now I want that to the user, pending requests should visible on top.

i tried:
1. i did writing filter in formula with collection itself, but that status is different from what i want.
2. i did writing filter with list_2, that also fails to give status because i want to show the list_1 data in gallary.

please help, let me know, if i am unable to explain, may be we can connect over call.
Attached is the example image

Was this reply helpful? Yes No
Sid_98 103 on at

Like (0)

Report
Copy link

Link copied!
As I have understood you have same status column in both the entities. I have tried to filter the gallery based on the dropdown selection. You can refer to the below code. See if it works.
If( Dropdown1.Selected.Result in test1.Status, Filter( test1, Dropdown1.Selected.Result = Status ), SortByColumns( test1, "Status", Descending ) )
Don't get confused by the naming of entity I used here.
Refer test1 is the collection I am using here and status is the status column in this collection i.e. test1. It might be different in your case.
How I created the collection is ClearCollect(test1(my collection), Test2(My data source which in your case is the list_1 or main list))

Was this reply helpful? Yes No
Prakhar_Gupta1 51 on at

Like (0)

Report
Copy link

Link copied!

hey,
i tried, the same way but seems like........
attached is the screen shot.

Was this reply helpful? Yes No