Multiple Value Patch new record and update existing record

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi ,

I have an Excel Like Editable Grid that is using a PowerBIIntegration.Data as a data source,

Whenever user save the Gallery (this Data will store the record in another list) or

I want to update an Request_ID if it already exists

Here is what my logic looks like right now...

ForAll( 'Electrical-Gallery'.AllItems,
If(
 IsBlank(
 LookUp(
 'BSD CAD Tracker Electrical Mechanical',
 Request_ID = TextInput2_2.Text
 )
 ),
 Patch( 'BSD CAD Tracker Electrical Mechanical',
 Defaults('BSD CAD Tracker Electrical Mechanical'),
 { 
 Request_ID:TextInput2_2.Text,
 SAP_Part_Number:TextInput5_2.Text,
 Family_Code: ComboBox1.Selected.Family_Code,
 IEC_BLOCK: TextInput6_6.Text
 }
 );
 Notify("Data Saved Success",NotificationType.Success),
 Patch( 'BSD CAD Tracker Electrical Mechanical',
 { 
 Request_ID:TextInput2_2.Text,
 SAP_Part_Number:TextInput5_2.Text,
 Family_Code: ComboBox1.Selected.Family_Code,
 IEC_BLOCK: TextInput6_6.Text
 }
 );
Notify("Existing Data Saved Success",NotificationType.Success)
)
)

in this above code New Items saved successfully but Updated already Exists item not working it will create the Duplicates

I've been banging my head for weeks now, I don't know how to fix

Thanks

Ranga

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

To start, your formula has the ForAll backward. You are trying to use it like a ForLoop in some development language - which PowerApps is not. ForAll is a function that returns a table of records based on your iteration table and record schema.

It is more efficient to use the function as intended and will provide better performance.

Next, what is the primary key of your datasource and is your BI data providing that primary key?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@RandyHayes

Request_ID is the Primary Key

tried this code also but it's create the Duplicate Row items

Patch(BSD CAD Tracker Electrical Mechanical, ForAll( Filter(), { ID: ID, } ) )
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

So to be clear...this is NOT a SharePoint datasource!

If Request_ID is the primary key, then your formula should be:

Patch(BSD CAD Tracker Electrical Mechanical, ForAll( Filter(), { Request_ID: Request_ID, } ) )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

yes SharePoint is not my data source, for example purpose i have added ID:ID
but it's create the Duplicate Row items, if already exits Update the same row item how to i achieve this?

i tried this one ,
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Patch will do that automatically.

If the primary key is blank, then Patch will create the record. If the primary key has a value, then patch will find and update that corresponding record.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@RandyHayes

@Nogueira1306 can you please help me on this issue

It's not working , when I click save I'm getting error, before that no error

This is the code

Patch(BSD, ForAll( Filter(Gallery1_2.AllItems, Toggle1_1.Value=true), { ID: ID, Request_ID: TextInput1_2.Text, Family_Code: ComboBox4_2.Selected.Family_Code, SAP_Part_Number: TextInput2_6.Text, IEC_BLOCK: TextInput3_2.Text } ) )