patch records in another dataverse table from one table

(0) Share

Report

Posted on by Matbrown

Hi All,

I am trying to patch records from one dataverse table to another table using forall but its not working

so i have two table table one and table 2 and code is unique value for both tables and i want to update description and user from table one to table2 when i select multiple items from a gallery using a checkbox

Here is the formula i am using:

Patch(
Table2,
ForAll(
Filter(
gal_start.AllItems,
galcheckbox.Value = true
),
{
Code: lbl_codeVal.Text,
Description: lbl_Name.Text,
User: LookUp(
Users,
'Full Name' = drpdownuser.Selected.'Full Name'
)
}
)
) is this the correct way to do update records within dataverse tables or should i use power automate please suggest?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Matbrown

ForAll( Table2, UpdateIf( gal_start.AllItems,galcheckbox.Value, {Code: lbl_codeVal.Text, Description: lbl_Name.Text, User: LookUp(Users,'Full Name' = drpdownuser.Selected.'Full Name' ) } ) )

Was this reply helpful? Yes No
Matbrown 34 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp this formula is giving error that the first argument of updateif should be a collection can you please help?
forAll(Table2,
UpdateIf(
gal_start.AllItems,galcheckbox.Value,

{

{Code: lbl_codeVal.Text,
Description: lbl_Name.Text,
User: LookUp(Users,'Full Name' =
drpdownuser.Selected.'Full Name'
)

}
))

Was this reply helpful? Yes No
Matbrown 34 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp any help?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Matbrown

If you have as the OnSelect of the checkbox, Collect(coltable, ThisItem) and for the UnSelect: Remove(coltable,ThisItem) you will create a collection of the checked items in your gallery as you go. You can then simply patch Table2 with the coltable collection in a button with OnSelect

Patch( Table2, ID = coltableID, {Code: lbl_codeVal.Text, Description: lbl_Name.Text, User: LookUp(Users,'Full Name' = drpdownuser.Selected.'Full Name' ) } )

Was this reply helpful? Yes No