Multiple Value Patch new record and update existing record

[Anonymous]

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

[RandyHayes]

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

[Anonymous]

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

@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,
         }
)
)

[Anonymous]

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

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

[Anonymous]

@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       
        }
    )
)