Patching an existing record in a Dataverse table from within a Forall

Like (0) Share

Report

Posted on 15 Apr 2022 19:42:31 by MF-11091236-0

I have a collection from a Dataverse table; 'Tickets'

ClearCollect(col_TicketsToBeRedeemed,
FirstN( Sort( Filter( Tickets, Redeemed_Date = Blank() And Ticket_Owner = "John@Smith.com"),
Issued_Date, Ascending), 1 ));

With this collection 'col_TicketsToBeRedeemed', I need to loop through each individual record and update a field called 'Redeemed_Date' in the DB table.

ForAll( col_TicketsToBeRedeemed, 
 Patch( Tickets,
 LookUp( Tickets, ThisRecord.Id = col_TicketsToBeRedeemed[@Id]),
 { Redeemed_Date: Now() }
 )
);

The initial collection 'col_TicketsToBeRedeemed' was created from the same table I am attempting to Patch to. 'Tickets'

The column headers in the collection and table are the same.

The field 'Id' is a Autonumbered field type.

There is a Unique Identifier field 'ticketsid' which I've also attempted to match on but no luck.

I have tried many many different iterations of this in hopes of getting to work without success.

Any assistance would be much appreciated.

Categories:

Connecting to Data

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

MF-11091236-0 41 on 16 Apr 2022 at 12:48:53

Like (0)

Report
Re: Patching an existing record in a Dataverse table from within a Forall

@MichelK I figured out it. The column names causing the grief and by correcting I was able to successfully get to work.
ClearCollect(col_TicketsToBeRedeemed, FirstN( Sort( Filter( Tickets, Redeemed_Date = Blank() And Ticket_Owner = varCustomer.Email ), Issued_Date, Ascending), varCustomer.QuantityToRedeem ) ); ForAll(col_TicketsToBeRedeemed As Row, Patch( Tickets, LookUp( Tickets, Id = Row.Id), { Redeemed_Date: Now() } ); )

Was this reply helpful? Yes No
MichelK 120 on 16 Apr 2022 at 10:06:05

Like (1)

Report
Re: Patching an existing record in a Dataverse table from within a Forall

Deal
Then can you try the following?

ClearCollect(col_TicketsToBeRedeemed, FirstN( Sort( Filter( Tickets, Redeemed_Date = Blank() And Ticket_Owner = "John@Smith.com"), Issued_Date, Ascending), 1 )); UpdateIf( col_TicketsToBeRedeemed, true, { Redeemed_Date: Now() } ); Patch( Tickets, col_TicketsToBeRedeemed ); //Could be Collect instead of Patch, forgot which one does the job

Was this reply helpful? Yes No
MF-11091236-0 41 on 16 Apr 2022 at 02:55:54

Like (0)

Report

Re: Patching an existing record in a Dataverse table from within a Forall

I appreciate the response, the FirstN is intentional. There could be multiple rows matching but only need to tag 'x' number as being used. In the filter provided some of the data is hardcoded where otherwise it would be dynamic.
The goal of the filter is to retrieve 'x' number of the oldest rows for an individual.
I have attempted the UpdateIf but unable to get 'x' number of rows which is important.

Was this reply helpful? Yes No
MichelK 120 on 16 Apr 2022 at 00:29:03

Like (0)

Report
Re: Patching an existing record in a Dataverse table from within a Forall

Hello @Slevin3900 ,
First of all, in the following expression :
ClearCollect(col_TicketsToBeRedeemed, FirstN( Sort( Filter( Tickets, Redeemed_Date = Blank() And Ticket_Owner = "John@Smith.com"), Issued_Date, Ascending), 1 ));
The FirstN( Collection, 1 ) returns only one record. So if the objective is to update just the first one, there would not be a need for a ForAll, and you would just use the following code:
Patch(Tickets,First( Sort( Filter( Tickets, IsBlank(Redeemed_Date) And Ticket_Owner = "John@Smith.com"),
Issued_Date, Ascending))), {Redeemed_Date : Now()});
However, if you need to update all the matching records and the FirstN was unintentional, you could use an UpdateIf :
UpdateIf( Tickets, IsBlank(Redeemed_Date) And Ticket_Owner = "John@Smith.com", {Redeemed_Date: Now()});

Let me know if this helps!

Was this reply helpful? Yes No