Answered

Update SP List with values from same list using Patch

(0) Share

Report

Posted on by nvpc

the patch is working but only updates yellow part from table a to the VACANCYID. How can I add the blue part from table b the VACANCYID also, i.e. IT0820230002.

ClearCollect(colTableA, Filter(TableA, Import = "Yes"));

ForAll(colTableA,
Patch(TableB ,LookUp(TableB, Available = "Yes"),
{ Title: colTableA[@PO].Value,
VacancyNumber: Concatenate(colTableA[@POSID], TableB.BillID), // this is not working, reason I don't know how to reference TableB fields

VacancyNumber: Concatenate(colTableA[@POSID], "test"), // works
Available: false
}

)
)

Categories:

Using Apps Using Formulas

All responses (3)

Answers (1)

Verified answer

nvpc on at

Like (0)

Report

Re: Update SP List with values from same list using Patch

I managed to get this to work using the ForAll see bellow;
before running code
after running code
ClearCollect(colImportedRecords, Filter(tableA, import = 1000));
ForAll(colImportedRecords,
Patch(TableB ,LookUp(TableB, AVAILABLE = true),
{ PO: colImportedRecords[@PO],
VACANCYID: Concatenate(colImportedRecords[@POSID], LookUp(TableB, ID = colImportedRecords[@ID]).BILLID),
AVAILABLE: false
}
)
)
nvpc on at

Like (0)

Report

Re: Update SP List with values from same list using Patch

Thank you for your reply, I've tried using your code and is not working.
this first error (1st circle) says "A column name "VACANCYID" already exists, so I renamed it "VACANCYID1"
I also change the PO (two other circles) to ID as PO is not unique. This cleared the errors and I was able to run but no results, see below
hroudaadam 22 on at

Like (0)

Report
Re: Update SP List with values from same list using Patch

Hi there!

First of all - do not use Patch + ForAll -> you can Patch multiple records at once (see https://www.matthewdevaney.com/patch-multiple-records-in-power-apps-10x-faster/).

Now to your problem... I am no sure I understand you data. However here's an solution that comes to my mind...

// patching multiple records at once Patch( TableB, // when patching multiple record you only need columns with changes and with unique key ShowColumns( // add new column calculated from current and related collections AddColumns( colTableB, "VACANCYID", Concatenate( LookUp(colTableA, PO = ThisRecord.PO).POSID, ThisRecord.BILLID ) ), "ID", "VACANCYID" ) )