updating sharepoint tables(patch?)

(0) Share

Report

Posted on by Marcsiegel

Is patch my best choice , what other options do i have?

Situation

I have a number of tables in sharepoint.

For argument lets call them Dog, Cat, Bunny, Animals

I have a form in powerapps, The main data source is a table called Animals depending on what the user inputs

i want to write to one of those three tables, as well as write to the master table called Animals

Is the patch command my best option or are their other choices.

is their an easy way to map it. As in the long run I can see alot of if statements

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Marcsiegel very much depends on what you're trying to do.

Fortunately you have many options. Patch, Update, and UpdateIF, as well as Power Automate are ideal when dealing with multiple tables.

In addition, you can even use a Patch command to Submit different forms based on conditions. e.g.

Switch( varRecord.ID, 1, Patch( Dog, {ID: 1}, Form1.Updates ), 2, Patch( Cat, {ID: 1}, Form2.Updates ), 3, Patch( Bunny, {ID: 1}, Form3.Updates ) )

You can find a wealth of materials online and in this forum, to identify the method which best suits your needs.

I personally think Alireza Aliabadi provides the most succinct tutorial on the differences here:

https://www.youtube.com/watch?v=GQT3JuClUJc

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like (1)

Report
Copy link

Link copied!

i could think of two ways.
first way if the child table has same columns in dog,cat,bunny. you can use two forms
FormA:Master table
FormB: for child tables(this will be hidden here what you can do is change datasource based on the selection in master table and also whatver values you want to copy ex: Place . you will have it in masterfrom so default of place formb placedatacardvalue will be forma placedatacardvalue)

or
second way is to submitform and use formupdates in patch function for child table.
instead of multiple if you can use Switch

Was this reply helpful? Yes No