Power Utilization report with ability for management to comment on

[jaimonsk]

Hello experts,

I am pretty new to the power platforms and I have a task to complete which I would appreciate your help.

There is a Power BI based dashboard which takes data from a database and calculates utilisation per person on a weekly basis. An example would be like this

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%

Now the ask is that there should be a hyperlink besides every week or something such that when a user clicks on them, the user should be able to see the name, week selected, and then a comment box which the user could update based on the user selection. Upon clicking Submit the results will then be stored back in the database.

Could somebody help me in how to start and proceed with this?

Thank you!

[jaimonsk]

Hi,
So I working on the power app as in the video.
But I keep getting error like  
Server response: Table1 failed: File size above allowed value. File size:2626087, AllowedFileSize (in Bytes): 2000000 clientRequestId: 82915846-1f6f-4e17-b184-d383b1acf466 serviceRequestId: 82915846-1f6f-4e17-b184

What I did is that I created a form and used the lookup fomula to connect the form with power BI data.

The thing is that my PowerBI data does not have any key columns. May be a combination of Name and period could gather relevant information which I donnow how create in Power app

Formula I used in the app to link the form is LookUp(Table1, First(PowerBIIntegration.Data).Name)
 Could you help me how to link between the two?

[Idrissshatila · Accepted solution]

Hello @jaimonsk ,

If you want to build something like this then you should use power apps in power BI.

check this out https://youtu.be/uPHwjPRnRwE

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin