Answered

Static data source update

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community,

I need some help with updating the static data used from an excel.

I have a powerApp that takes data both from powerBI ([@PowerBIIntegration]) as well as a static excel data. The static file gets updated every month and is manually updated. So when being in use on a PowerBI dashboard, this app takes name of the person selected on the dashboard through PowerBIIntegration data, filters the name from the static data, and returns the name of courses completed by that person in a html text.

Below is the code for the html table.

"
<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>
 " & "
 <tr style='background-color:#efefef' >
 <td> Course Name </td>
 </tr>
 " & Concat(Sort(Distinct(Filter(Table1_1,Full_Name in [@PowerBIIntegration].Data.Full_Name), FullNameOfCourse), Result),
 "
 <tr>
 <td>" & Result & " </td>
 </tr>
 "
 ) & "
</table>
"

But when I am updating the static data in exact same format with exact same names for the columns and changing table name (Table1_1) in the html text, it is giving the errors as in the screenshot.

Can anyone please suggest where I am getting wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

1) No error is shown in either screenshot that we could find.

2) This

[@PowerBIIntegration].Data

is special read-only Collection which holds the context passed in from the Power BI Report.

You must instead Lookup the corresponding record in Data Source and modify it there. We are not aware of any workaround which could force [@PowerBIIntegration].Data to be modified directly - that specific Collection only can be modified in the way it is intended - from the outside i.e. from doing something in the Power BI Report where the Canvas App is embedded on, because the point of [@PowerBIIntegration].Data is to be read-only and to hold the information about what is being passed in from the Power BI report, and it changes and updates along with what is selected or applicable in the Power BI report from outside, etc.

.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@poweractivate My apology for the wrong screenshot. I just updated it. Please take a look.

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

In this case we would suggest you try this only as troubleshooting step to start from simpler statement like:

& [@PowerBIIntegration].Data.Full_Name &

See if just this gives an error first. If it does, please give details what the error was even for just the simple statement above.

If the above gives no error, then try to gradually build back up the other nested statements until you get no error and the desired result. In the moment a simpler statement results in error, it may be easier for you to figure out what the problem is yourself - but if you still cannot figure it out even after that, reply here with details about it.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. Actually the issue was with the static data. It resolved after correcting the data from the source.

Was this reply helpful? Yes No