Power BI and Power app Integration

[jaimonsk]

Hello Experts,
I have a Matrix view within Power BI like below. This data is coming SQL Server DB.

Full Name	Target	YTD	Variance	P1_1_23	P2_2_23	Total
A	60%	35%	25%	15%	20%	35%
B	50%	40%	10%	20%	20%	40%
C	70%	60%	10%	25%	35%	60%

Also,  I have  aPower app form integrated which Looks like this which looks like this

Name:  A
Period: P2_2_23
Comment: <User could fill>

Submit

Now, these are connected within Power app using formula 
Item = LookUp(<Sharepoint List Name>,'FULLNAME'=First(PowerBIIntegration.Data).'Full Name')
as we planning to keep the details captured on form within the sharepoint list.
With this change, the name is changing on user selection but the period is not changing. Could someone help me on this?

Thank you!

[Anonymous · Accepted solution]

Hi @jaimonsk,

I think this should more related to PowerApps design, you can try to post this to PowerApps forum to get better support. 

Building Power Apps - Power Platform Community (microsoft.com)

In addition, you can also take a look the following link about similar requirements if help:

Solved: Filtering data in PowerApps based on Power BI - Power Platform Community (microsoft.com)
Regards,

Xiaoxin Sheng