EditForm update using patch and PowerBI Integration

[Anonymous]

I am struggling to save my EditForm update using a patch statement.

My data comes into PowerApps through PowerBIIntegration, it populates a form in edit mode, and the submit button has a patch statement - as follows:

Patch(DataTable, First(Filter(DataTable, Index = "Dropdown3.Selected.Result")), {AssignValue: TextInput1.Text})

The DataTable in PowerBI and PowerApps is the same Excel file on OneDrive.

The form populates correctly, and when I change filters in PowerBI this gets reflected in both the PwerApps display inside PowerBI and in the PowerApps session I opened through PowerBI.

Clicking the submit button nothing happens. What should I look at next?

[v-xida-msft]

Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to update the Edit form data within the embedded app using Patch function?

Based on the formula you provided, I think there is something wrong with it. I have made a test on my side, please consider modify your Patch formula as below:

Patch(
       DataTable, 
       LookUp(DataTable, Index = Dropdown3.Selected.Result), /* <-- Dropdown3.Selected.Result formula could not be wrapped with double quotes */
       {
         AssignValue: TextInput1.Text
       }
)

Note: The Dropdown3.Selected.Result formula could not be wrapped with double quotes.

More details about the Patch function in PowerApps, please check the following article:

Patch function

Best regards,

[Anonymous]

@v-xida-msft- thank you for your kind reply.

My scenario is as follows - read in a table from Excel into PowerBI - make a selection for a single row of the table in PowerBI Online report - display that row data in a form through PowerApps in PowerBI - then edit 1 field and submit back to the Excel table using the patch function

I have made the switch in the patch function from First(Filter to Lookup, as follows:

Patch(DataTable, LookUp(DataTable, Index = "Dropdown3.Selected.Result"), {AssignValue: TextInput1.Text})

outcome is the same - no response to clicking submit in the app.

What else can I look at to get the patch function to make the update.

[v-xida-msft · Accepted solution]

Hi @Anonymous ,

Based on the issue that you mentioned, I think you have some misunderstanding with the solution I provided above. The Dropdown3.Selected.Result is a formula in PowerApps app, which could not be wrapped with double quotes (""). Please type Dropdown3.Selected.Result within your formula directly rather than "Dropdown3.Selected.Result".

On your side, please type following formula:

Patch(
       DataTable, 
       LookUp(DataTable, Index = Dropdown3.Selected.Result), 
       {
         AssignValue: TextInput1.Text
       }
)

rather than following:

Patch(
       DataTable, 
       LookUp(DataTable, Index = "Dropdown3.Selected.Result"), 
       {
         AssignValue: TextInput1.Text
       }
)

Note: Please remove the double quotes ("") around the Dropdown3.Selected.Result formula.

Please note that the formula within an app could not be wrapped with double quotes (""), if you wrap the formula with double quotes (""), it would be acted as string value rather than expression.

Best regards,

[Anonymous]

@v-xida-msftthank for your kind message - dropping the double quotes worked for me to make the Patch statement work and write out items to the table.

I have marked as solution.

[LauraMay]

Hi, Would you be able to help me with a similar issue

I had great success using UpdateIf and Patch to bulk update a number of records in PowerApps.

I am now attempting to use the same solutions for a Power App embedded into a Power BI report as follows: -

1. Select Records in PowerBI

2. Show Records in PowerBI Gallery using PowerBIIntegration

3. I create a collection "KYCxCLCollection" from the gallery

   ClearCollect(KYCxCLCollection, GalleryPowerBIKYC.AllItems)

4. I use a checkbox within the NewForm to indicate where a user can update individual fields with a different value  before patching if they need to.

 If(CheckboxKycPackage.Value = true, UpdateIf(KYCxCLCollection, true, {'KYC Package Name': LookupKYCPackage_1.Selected.kycPackage}));
If(CheckboxAppliesTo.Value = true, UpdateIf(KYCxCLCollection, true, {'Applies To': ChoiceAppliesTo_1.Selected.Value}));
If(CheckboxRelatedParty.Value = true, UpdateIf(KYCxCLCollection, true, {'Related Party Name': LookupRelatedParty_1.Selected.kycPackage}));
If(CheckboxClause.Value = true, UpdateIf(KYCxCLCollection, true, {'Clause Name': LookupClause_1.Selected.clause}));
If(CheckboxListOfValues.Value = true, UpdateIf(KYCxCLCollection, true, {crb8f_kycpackagexclause_listofvaluesname: LookupListofValues_1.Selected.listOfValues}));

5. I create another collection from the initial collection but drop the IDs to ensure power Apps creates new records rather than updating existing records

ClearCollect(CopyMultipleKYCPackagesCollection, DropColumns(KYCxCLCollection, "crb8f_kycpackagexclauseid", "crb8f_kycpackagexclauseuid"));

6. But the final Patch statement, recognises the source being my inital CDS table "kycPackageXclause" does not seem to like this new Collection I have just created "CopyMultipleKYCPackagesCollection".

Patch(kycPackageXclause, CopyMultipleKYCPackagesCollection)

I can't understand why this works in a straightforward PowerApp, but doesnt work for a PowerApp reading from PowerBI. Any insight MOST HELPFUL, if you can understand everything I have written above!