Unanswered

multiple records update for CDS entity

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi ,

I am trying to update multiple CDS entity record using ForAll and Path and Lookup function.

I also tried with path function but its showing "Invalid argument type error"
Same code is working with SharePoint list but not with CDS entity.

Used below code updateif (Fuction):-
ForAll(ReassignUserCollection6,UpdateIf(ChemicalOrders,ChemicalOrderID="1", {OrderNumber:"order1"}))

used below code with Patch function:-
ForAll([RenameColumns(Filter(ReassignUserCollection6,IsChoosen=true),"crb05_chemical_id","crb05_chemical_id_new")], Patch(ChemicalOrders,LookUp(ChemicalOrders,Chemical_ID=crb05_chemical_id_new),{ OwnerID: "1"}))

Regards,
Lalit Kadam

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Modify the code:

ForAll([RenameColumns(Filter(ReassignUserCollection6,IsChoosen=true),"crb05_chemical_id","crb05_chemical_id_new")], Patch(ChemicalOrders,LookUp(ChemicalOrders,Chemical_ID=crb05_chemical_id_new),{ OwnerID: "1"}))

to

ForAll(RenameColumns(Filter(ReassignUserCollection6,IsChoosen=true),"crb05_chemical_id","crb05_chemical_id_new"), Patch(ChemicalOrders,LookUp(ChemicalOrders,'Chemical_ID'='crb05_chemical_id_new'),{ OwnerID: "1"}))

Or

UpdateIf( ChemicalOrders, 'Chemical_ID' in ReassignUserCollection6.'crb05_chemical_id', { OwnerID: "1"})

Hope this helps.

Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sik,

Thanks for quick reply.

I tried both code but it is still showing same error again. Please refer attached screen shot.

Regards,
Lalit Kadam

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The error shows the entity name ChemicalOrders is invalid.

Please check it in the left Data source panel.

Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sik,

The "chemicalOrders" entity is exists. Please find attached screen shot.

Regards,
Lalit Kadam

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

There is no need to use ForAll function. Just try to use UpdateIf function alone.

UpdateIf( ChemicalOrders, 'Chemical_ID' in ReassignUserCollection6.'crb05_chemical_id', { OwnerID: "1"})

Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi sik,

I have to update selected record from gallery. updateif function only updating single record from selected list. therefore I am trying with ForAll function.

Regards,
Lalit Kadam

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I don't agree with you.

UpdateIf function can modify one or more records that match the condition ( 'Chemical_ID' in ReassignUserCollection6.'crb05_chemical_id')

Please check: UpdateIf function

Sik

Was this reply helpful? Yes No