Static data source update

[Anonymous]

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?

[poweractivate]

@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.

. 

[Anonymous]

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

[poweractivate]

@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. 

[Anonymous · Accepted solution]

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