Answered

Update SP List with values from same list using Patch

Like (0) Share

Report

Posted on 19 Aug 2023 02:49:21 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

I have the same question (0)

Summarized by AI

All responses (3)

Answers (1)

hroudaadam 22 on 19 Aug 2023 at 06:42:21

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" ) )

Was this reply helpful? Yes No
nvpc on 19 Aug 2023 at 21:45:18

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

Was this reply helpful? Yes No
Verified answer

nvpc on 20 Aug 2023 at 00:14:49

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

Was this reply helpful? Yes No