Unanswered

Filter a Data Source based on Second Data Source Condition

(0) Share

Report

Posted on by klinha

Hi All,

I have an app that displays items from PowerBI in my gallery with a filter for just the selected quarter. Users can then go in and write a comment for each item in the gallery which then gets saved to SharePoint in a column called "Comment".

What I am trying to do is filter my gallery which currently displays the code below to only show items where Comment is not blank.

Filter(
 PowerBIIntegration.Data,
 'Quarter Year' = 'Selected Quarter'
 )

When users submit a comment, I create a unique ID for each submitted comment that concatenates all the columns that make that row unique. Do I have to also create an ID for the Power BI columns I am pulling in? I am struggling to find a way to filter my gallery which is connected to Data source 1 based on a condition in Data source 2.

Any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @klinha ,

If there is any unique column in Power BI dataset, you can concatenate it a value of this column with a special separator like "|" at the very front of comments. When selecting an entry in SharePoint, use Split function to save this value into a variable:

Set(varUniqueValue, First(Split(SharePointComments.Selected.Comments, "|").Result)

Then filter can use this variable as its criteria:

Filter( PowerBIIntegration.Data, UniqueColumn = varUniqueValue )

Best regards,

Was this reply helpful? Yes No
klinha 10 on at

Like (0)

Report
Copy link

Link copied!

If I do not have a unique column coming from Power BI dataset - is there a way I can do this in Power Apps without having to create an additional column in PowerBI?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @klinha ,

You can do it as above mentioned, but the results will be multiple entries. So, if you can handle it and find the record you want, it's OK to go with it.

Best regards,

Was this reply helpful? Yes No