Update 2 share point lists (List A,List B)) at a time using a single form with is connected to List A in PowerApps.

[ravi123]

Hai @WarrenBelz , @Amik 

Good morning

I have a situation where i have to update a 2 SharePoint Lists at time from Power App.

List A: Contains all the Unique Machine details with Columns :  Machine name, Machine MaintenanceStatus, Machine maintenence Date etc.

List B: Contains almost similar columns what LIST A had.

I have connected to List A from power app form to alter the Machine MaintenencStatus & MachineMiantenence Date as per my maintenance schedule. When ever i do that, ListA will get updated but i don't have any data collected to see the history of changes.

So i have created LIST B to maintain the historical changes of Line items in LIST A.

Please help me with the Solution  how to Patch to LIST A & List B at a time from a form with is connect to List A.

or suggest me any better way to do this !..

Hope you understand my Problem, if you need any further details i will provide you.

Awaiting for your reply.

Regards.

[vkondreddygari]

When you SubmitForm to save changes for LIST A, onSuccess property of Form control, you can use patch function to insert row into LIST B with required values(with use of Form.LastSubmit) 

[Amik]

@ravi123 - On the OnSucess property of your Edit Form control, you can use the Patch function to create a new record in List B if any of the Controls in any DataCard are changed from their default values. Assuming the data types are the same across both lists, a simple way to do this is to leverage the Update property of the DataCard.

Example below:

Patch(
    'List B',
    Defaults('List B'),
    {
        Title: Title_DataCard1.Update,
        'Column 1': 'Column 1_DataCard2'.Update,
        'Column 2': 'Column 2_DataCard3'.Update
    }
);
Notify("List B Updated",NotificationType.Success)

[ravi123]

Hi Amik

Thanks for your reply!

As you said, I have written Patch function to create a new record in List B to Onsuccess property of Edit form which is connect to ListA. But after submitting my form i see the updates in ListA but no record is created in ListB. Even i dont see any errors in the Formula. 

My List B attributes are as follows. same as ListA. 

Even i tried to use this Patch function in submit button of form control (List A),but it's thrown me an error called "Network error when using patch function. the request operation is invalid."

 I don't know where i went wrong, could you please assist me.

thanks. 

[Amik]

@ravi123 - for an Edit Form control you need to use the SubmitForm function to create/update the record in List A. You will only use the Patch function on the OnSuccess property to create a record in List B.

[ravi123]

Hai @Amik 

Even after using Patch function on the OnSuccess of List A to create record in List B still I'm getting an error called The Request Operation is Invalid.

Can you please help me further to get it done.

My form Submit button.

Thanks!

[Amik · Accepted solution]

@ravi123 - firstly please remove one field from the Patch and then click the SubmitForm button again, keep doing this until there is no longer an error message. You can then identify which field or fields are causing the problem (looking at your code, I suspect it is the "MaintenanceStatus" field).

[ravi123 · Accepted solution]

Hai @Amik 

I got the Solution. i have tried the below patch( logic) and it's worked for me.

Now i'm able to patch all the required columns to the ListB Using a form control with is connected to the ListA.

Thanks for your Suggestions giving so far.

Note: I got this logic from ChatGPT.

[Amik]

@ravi123 - I am surprised you have marked your own response as the solution here. The answer to your question is to apply a Patch function to the OnSuccess property of your Edit Form control (which you did not know to do
until I advised you).

The Patch function not working for you is an entirely separate problem.

Please be mindful of this in future, because you are effectively getting solutions from community users but then taking the credit. This can discourage other community users from offering their expertise.

[ravi123]

Hai @Amik 

Good Morning

Since i'm literally new to this community, i thought accept as a Solution means what is the logic that worked for me in our entire conversation. May be in future someone faced the same issue and if they search here and get into appropriate solution as marked by me or you . this is only the intention behind marking as a solution. 

Believe me , i really don't know what credit i will get by clicking on Accept as a Solution.

i'm very happy that the help you did for me, hope i will continue to get support from this community.

Thank you @Amik !!