@SYED_786 - you can use the Add Columns and the Lookup function to "transform" the data source used by your Gallery.
In the below example, I have created two collections with a common reference (Sample ID and ID).
ClearCollect(
mySampleCollection,
{SampleID:1, Project: "Project A"},
{SampleID:2, Project: "Project B"},
{SampleID:3, Project: "Project C"}
);
ClearCollect(
myOtherSampleCollection,
{ID:1, Status: "Not Started"},
{ID:2, Status: "In Progress"},
{ID:3, Status: "Complete"}
)
Then we add the following expression to the Items property of the Gallery. We create a "virtual" column (called "_status") which looks up the data we need in the other data source. We then we run a Filter on the output.
Filter(
AddColumns(
mySampleCollection,
"_status",
LookUp(
myOtherSampleCollection,
ID = SampleID,
Status
)
),
_status = "Complete"
)
Note despite the lack of a warning, the Add Columns function is not delegable.
Further reading: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-table-shaping
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
