Unanswered

ClearCollect for powerapps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hai,
I have 3 dropdown with a data table from excel.
I would like to filter data table based on the dropdown.
I want to create ClearCollect Header in OnVisible in the Screen but I unable to do. Plz suggest a way. Tq

To make header for datatable

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

First, is there any particular reason you need a collection for this? Your information looks pretty static. You can simply assign that record (the curly bracketed information) where ever you need it.

Next, I'm a little unclear on what you are asking - you mention three dropdowns, then filtering a data table, then headers. Can you please clarify what it is that you are trying to do with a little more detail?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
Below are the youtube link that I refer to do: I'm unable to Make header for gallery control which is to create a collection.
Create grid view with custom gallery control

1) Basically, I have a data table from excel. Meanwhile, I also have 3 dropdown to filter the datatable based on the selection in dropdown to edit the details in the datatable.

Sort, Filter in data table

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Yeah, I looked over the videos - not really the best way to go about what you are trying to do.

So, let's get a couple things cleared:

1) You mention DataTable - is that really what you are using, a DataTable control in your PowerApp, or are you using a Gallery?

2) You sited a video that uses a variety of odd ways to sort and filter the values in a Gallery - yet, you mention that you have 3 dropdown controls to filter. Is it that you want to do the dropdowns for filtering, or the sorting of the information, or both?

3) Based on the response to #1 above, what do you have so far as far as controls and formulas?

What you are looking to do is relatively straightforward and can be done much simpler than the advice in those videos, but I need some starting points in order to understand what you have and what you want.

Think through the above. Send me some detail and even a screenshot or two to understand your layout and format.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for your time and sorry for the unclear explanation.

1) Firstly I have created 3 dropdown which are team, subteam and allocationby to filter my data table(I had tried in two ways which are in gallery and datatable)
The code for 3 dropdown is
Distinct(SiteSupportProfile,Team)
Distinct(Filter(SiteSupportProfile, Team = Team_DataCardValue2_1.Selected.Result),SubTeam)
Distinct(Filter(SiteSupportProfile, SubTeam = DataCardValue4_1.Selected.Result),AllocationBy)

2) The contents for my datatable is ERPSite Name, Support Level and workload. After user select the 3 dropdown, the data in datatable will filter according to the selection. Now I unable to filter my data table. I use this code for item in data table:
Filter(SiteSupportProfile, Team = Team_DataCardValue2_1.Selected.Result && SubTeam= DataCardValue4_1.Selected.Result)&& AllocationBy= DataCardValue2_1.Selected.Result)

3)Only involve one excel file

Plz advise me on this. Tq

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

No problem, I always ask questions a few times to make sure I am clear. There is nothing more frustrating that providing you something that doesn't even come close to what you need. It's confusing and a waste of your time.

So, as I see your formulas, your requirement is pretty simple.

You have the three dropdowns that are cascading. Your data is in an Excel table called SiteSupportProfile. You have and EditForm with the three dropdowns named Team_DataCardValue2_1, DataCardValue4_1, and DataCardValue2_1

Your formula for the Gallery or Datatable (recommending Gallery over datatable for flexibility) will be:

Filter(SiteSupportProfile, Team = Team_DataCardValue2_1.Selected.Result && SubTeam = DataCardValue4_1.Selected.Result && AllocationBy = DataCardValue2_1.Selected.Result )

BUT...what I am not getting is the relationship of all of this to the original question you posted.

Is the above formula working well for you or do you have issues with it? Is it that you want some header over your Gallery or DataTable and are trying to create that?

I'm not sure where to lead you (and don't want to lead you wrong) as I am not clear on which part is or is not working.

Can you clarify what exactly you're having problems with?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It is already solved as I have some issue in filter code.

This is how my data table looks like. I need your suggestion on this.
1) Support level data in my data source is 0%, 5%, 50%,100% but in data table shows 1 and 5 which is not included zero. How to make the original data display on data table?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Sorry I didn't get back to this thread. I see you have this question in another post, so I will answer there.

Was this reply helpful? Yes No