patch not working Large Data Delegation - Lookup condition

[Anonymous]

Hi,

I try to patch the data into 2 different places first patch save the data to SQL it's works, 2nd patch Update the SharePoint list 

I have created lookup for ID check 

SharePoint list contains 18000 row, I'm getting delegation Warning,  data was not updated to SharePoint 

This my code

ForAll(
    Filter('Mechanical-Gallery'.AllItems, Toggle2_3.Value=true),
    Patch('cadtracker.Mechanical',{ID:Value(ThisRecord.ID)},
    {
            Model_Name: TextInput6_10.Text,
            Insert_from_CSYS:TextInput6_11.Text,
            Part_Type:TextInput6_12.Text     
    }
    );
    Patch('Parts requests', LookUp('Parts requests',ID2 = TextInput2_3.Text),
 {
            'Request status':Concatallstatus.Text,
            'MD Completed' :DateTimeValue(MDTime.Text)
    }
)
);

Delegation Screenshot

Could you please help me how I can solve this issue?

Thanks

[subsguts]

What type of column is your ID2?

I have the following code and it works and does not generate a delegation error.  So, I think it maybe that your ID is a number and you are comparing it to a Text value?  If that is the case, then maybe using Val command to change the Text into a numeric value?

Just suggestions, but please provide additional info and I'll try to assist.

Patch(
FeeRequest,
LookUp(
FeeRequest,
ID = varSelectedRequestID
),
{Description: txtDescription.Text},
{PlaceOfService: cmbPlaceOfService.SelectedItems},
{Groups: cmbGroups.SelectedItems},
{Systems: cmbSystems.SelectedItems},
{AdditionalCommentsInformation: txtAdditionalCommentsInformation.HtmlText}
));

[Anonymous]

@subsguts   

ID2 is Number column I tried  ID2 = Value(TextInput2_3.Text)   but I'm  getting Delegation warning and Data was not saved 

i try to patch multiple data into one click Excel like Editable gallery i have created

ForAll(
    Filter('Mechanical-Gallery'.AllItems, Toggle2_3.Value=true),
    Patch('cadtracker.Mechanical',{ID:Value(ThisRecord.ID)},
    {
            Model_Name: TextInput6_10.Text,
            Insert_from_CSYS:TextInput6_11.Text,
            Part_Type:TextInput6_12.Text     
    }
    );
    Patch('Parts requests', LookUp('Parts requests',ID2 = TextInput2_3.Text),
 {
            'Request status':Concatallstatus.Text,
            'MD Completed' :DateTimeValue(MDTime.Text)
    }
)
);

 There's two patch I have used,  first patch it's works,  but 2nd patch  i try to patch SharePoint list it's contain 18000 records  when I used other SharePoint list smaller data means it's works ,  large data SharePoint list data was not saved

Thanks

Rajesh

[subsguts]

Thanks for the key to your problem, 18000 records, I probably missed that in your original post.  Depending on your settings, the max from/to Sharepoint in a Patch is going to be 2000.  So,  you will have to right code to segment the 18000 into chunks of data < 2000 (assuming that's the max you've put in your setting, or less if you've have the default setting of 500).

So you'll have to figure out a method for breaking the 18000 into unique groups and then patch each of them. If you don't know how large that is going to be, then you'll need to account for that as well.  Not knowing your data I can't suggest what value to use to do this, but I am hopeful this allows you to develop a solution?

If you have questions about how to chunk out the data into smaller pieces, please provide me additional info and I'd be glad to help.