Answered

Im trying to build a skill matrix in gallery and want to do filters based on the dropdown selection

(0) Share

Report

Posted on by karthik26

101

i have created nested gallery, were in my main gallery items property i used a group by function . In My child gallery items property i used ThisItem.Data, and able to group the skills and skill level . But if i want to filter this , iam not able to filter it by skill or skill level.

Filter(Sort(GroupBy(AddColumns(Knowledge_matrix,"Email_TRDI",'Person _Name'.Email),"Email_TR","Data"),
SortOrder.Descending),
ThisRecord.Email_TRDI <> Blank(),
StartsWith(
Email_TR,
Name_txt_3.Text)).

iam using single sharepoint list as data source contains all data(email, skill, skill level). am i doing it right or is any other way to group it

Categories:

Building Power Apps

Screenshot 2023-0...

I have the same question (0)

All responses (8)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @karthik26 ,

Assuming Skill and 'Skill Level' are fields in your data source, they should be present in Data and therefore available in your sub-gallery. You should be able to have the Items of this sub-gallery filtered by those two fields

Filter( Data, Skill = YourChosenValue1 & 'Skill Level' = YourChosenValue2 )

or do the parent like this

Sort( Filter( GroupBy( AddColumns( Knowledge_matrix, "Email_TRDI", 'Person _Name'.Email ), "Email_TR", "Data" ), Skill = xxxxxx && 'Skill Level' = xxxx && Email_TRDI <> Blank() && StartsWith( Email_TR, Name_txt_3.Text ) ), SortOrder.Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
karthik26 101 on at

Like (0)

Report

In parent, skill and skill level is not recognising, because we grouped by email
2. In sub gallery the formula works, but while filtering the main gallery shows empty value is not filtering

i want to hide main gallery mail id if sub gallery values is blank

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@karthik26 ,

Did you see the second code I posted - I filtered before the GroupBy

Was this reply helpful? Yes No
karthik26 101 on at

Like (0)

Report

Yes , i tried using the formula
Sort(
Filter(
GroupBy(
AddColumns(
Knowledge_matrix,
"Email_TRDI",
'Person _Name'.Email
),
"Email_TRDI",
"Data"
),
Email_TRDI <> Blank(),
StartsWith(
ThisRecord.Email_TRDI,
Name_txt_3.Text
),Skill = Drp_tool_1.Selected.Value || IsBlank(Drp_tool_1.Selected.Value),
Skill_Level.Value = Drp_Skilllevel_1.Selected.Value || IsBlank(Drp_Skilllevel_1.Selected)
),
SortOrder.Descending
)

But getting this error

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@karthik26 ,

Second attempt - first one is incorrect

Sort( GroupBy( AddColumns( Filter( Knowledge_matrix, Len(Drp_tool_1.Selected.Value) = 0 || Skill = Drp_tool_1.Selected.Value, Len(Drp_Skilllevel_1.Selected.Value) = 0 || 'Skill Level'.Value = Drp_Skilllevel_1.Selected.Value, Len(Email_TRDI) > 0, StartsWith( Email_TRDI, Name_txt_3.Text ) ) "Email_TRDI", 'Person _Name'.Email ), "Email_TRDI", "Data" ), "Email_TRDI", SortOrder.Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
karthik26 101 on at

Like (0)

Report

Hi ,
if i include email in filter code is not working,execpt email it is working.
This is working
If i include email filter
Below error coming up

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
@karthik26 ,

Ver #3 below - you might try and spot the issue - it will help you in the future

Sort( GroupBy( Filter( AddColumns( Knowledge_matrix, "Email_TRDI", 'Person _Name'.Email ), Len(Drp_tool_1.Selected.Value) = 0 || Skill = Drp_tool_1.Selected.Value, Len(Drp_Skilllevel_1.Selected.Value) = 0 || 'Skill Level'.Value = Drp_Skilllevel_1.Selected.Value, Len(Email_TRDI) > 0, StartsWith( Email_TRDI, Name_txt_3.Text ) ), "Email_TRDI", "Data" ), "Email_TRDI", SortOrder.Descending )

Was this reply helpful? Yes No
karthik26 101 on at

Like (0)

Report

Thanks for your support. Works fine

Was this reply helpful? Yes No