Power Platform Community Forum Thread Details

Hi,

I am very new to Power Apps and am still wrapping my head around its functionalities.

I am trying to integrate into a Power BI report an app that allows users to add or edit comments. The source of the original data is coming from our Datalake so I've created a Dataverse table to house the comments.

I've successfully created the main building blocks of the app but what I'm struggling with is with creating comments for ID with entries that don't currently exist in the Dataverse table.

My button is running the following:

If(
 CountRows(Filter('Test Tables', ID = First(PowerBIIntegration.Data).'all_sessions.sid')) > 0,
 SubmitForm(Comments),
 Patch(
 'Test Tables',
 Defaults('Test Tables'),
 {
 ID: First(PowerBIIntegration.Data).'all_sessions.sid',
 'Series Name': First(PowerBIIntegration.Data).'all_sessions.name',
 Comments: Comments
 }
 )
)

The above works fine if there is an entry already has a comment, it updates perfectly. But it gives an error if there is no pre-existing comment.

Any help is appreciated.

Categories:

Building Power Apps