Sort Column from Different Datasource in Gallery

(0) Share

Report

Posted on by zmansuri

6,048 Super User 2024 Season 1

Gallery item Code:

SortByColumns(
Search(
AddColumns(
Filter(
Zishan_ITPathFinderCandidate,
Status.Value = drpStatus.Selected.Value || drpStatus.Selected.Value = "All",
Technology.Value = drpTechnology.Selected.Value || drpTechnology.Selected.Value = "All",
Created >= DateFrom.SelectedDate && Created <= DateAdd(
DateTo.SelectedDate,
1,
Days
)
),
"AssignToTxt",
AssignTo.Value,
"StatusTxt",
Status.Value
),
SearchBox.Text,
"FirstName",
"LastName"
),
varColumn,
If(
varSort,
Descending,
Ascending
)
)

Code on Sorting Arrows:

UpdateContext({varColumn :"AssignToTxt"});
UpdateContext({varSort:false});

Code on Total Submission Colum:

CountRows(Filter(Zishan_ITPathFinderSubmissionDetail,CandidateParentId=ThisItem.ID))

I can sort this gallery from all values except Total Submission. Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@zmansuri

Please consider changing your Formula to the following:

SortByColumns( Search( AddColumns( AddColumns( Filter(Zishan_ITPathFinderCandidate, Status.Value = drpStatus.Selected.Value || drpStatus.Selected.Value = "All", Technology.Value = drpTechnology.Selected.Value || drpTechnology.Selected.Value = "All", Created >= DateFrom.SelectedDate && Created <= DateAdd(DateTo.SelectedDate, 1, Days) ), "AssignToTxt", AssignTo.Value, "StatusTxt", Status.Value, "SubmissionRecs", Filter(Zishan_ITPathFinderSubmissionDetail,CandidateParentId=ID) ), "SubmissionCount", CountRows(SubmissionRecs) ), SearchBox.Text, "FirstName", "LastName" ), varColumn, If(varSort, Descending, Ascending) )

Change your Formula on the Total Submission label Text property to:

ThisItem.SubmissionCount

Change the Formula on the sorting arrow for the Submission Count column to include "SubmissionCount" as the value to assign to the varColumn variable.

I hope this is helpful for you.

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Above code doesn't give any error. But, doesn't sort. Also "Thisitem.SubmissionCount" doesn't show the value. Which was showing before.
Gallery's Data source is "Zishan_ItPathFinder_Candidate"
and Submission data source is "Zishan_ItPathFinderSubmissionDetails".

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

Like (0)

Report
Copy link

Link copied!

@zmansuri

I'm confused... I provided the Gallery Items property in the last post, but you are stating that the Items property is Zishan_ItPathFinder_Candidate

Can you expand on what you are stating?

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

There are 2 gallerys and 2 data source.
gallery1: Candidate Gallery.
gallery1.Datasouce: Candidate_Datasource.
gallery2: Submission Gallery
gallery2.Datasource : Submission_Datasource.

one candidate can have multiple submission.

There is a ParentID column in Submission table which links to ID column of the candidate table.

The gallery you are seeing in below picture has "Candidate" as datasource. But this particular label i rounded takes data from submission table match it with Candidate_ID clolum and shows me the total number of submission count of that particular candidate. I can sort all other columns in the gallery because they are from the same data sources as mentioned in the item property of that gallery. But somehow can't sort "Total Submission" because it's coming from another data source.

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

Like (0)

Report
Copy link

Link copied!

@zmansuri

I understand the two datasources, but I provided you with a formula for the Items property of the Gallery...what have you done with that? That is key to getting what you want.

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Below is the code of Gallery Item Property.
SortByColumns(
Search(
AddColumns(
AddColumns(
Filter(Zishan_ITPathFinderCandidate,
Status.Value = drpStatus.Selected.Value || drpStatus.Selected.Value = "All",
Technology.Value = drpTechnology.Selected.Value || drpTechnology.Selected.Value = "All",
Created >= DateFrom.SelectedDate && Created <= DateAdd(DateTo.SelectedDate, 1, Days)
),
"AssignToTxt", AssignTo.Value,
"StatusTxt", Status.Value,
"SubmissionRecs", Filter(Zishan_ITPathFinderSubmissionDetail,CandidateParentId=ID)
),
"SubmissionCount", CountRows(SubmissionRecs)
),
SearchBox.Text,
"FirstName",
"LastName"
),
varColumn,
If(varSort, Descending, Ascending)
)

Below is the Label's Text Property. There is no data if i use "Thisitem.Submission"

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

@zmansuri

Very good!

So what kind of column is CandidateParentId in your list?

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

ParentIdSubmission is in Submission Data source. It takes it value from ID column of Candidate Datasource. So, it links which submission belongs to which candidate.

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

Like (0)

Report
Copy link

Link copied!

@zmansuri

Yes, but I was asking about the CandidateParentId column in the Zishan_ITPathFinderSubmissionDetail datasource. How is that defined? That seems to be where the error is coming into play.

Was this reply helpful? Yes No