Unanswered

ForAll Loops

(1) Share

Report

Posted on by JK-25091409-0

I don't understand how you can develop with being able to backup a table in Dataverse. I'm editing 500 rows but I can't backup the table first, I would have to restore the entire environment if something goes wrong. So I'll ask here first if this will work:

ForAll(L3ProcessMain,
Patch(ThisRecord, { Requirements: Concat(Filter(Requirements3S, Left(L3ProcessName,9) = Left(L3Process, 9)),ID,";") }))

L3ProcessName is a column in the Requirements3S table, L3Process is a column under "ThisRecord" in L3ProcessMain

Categories:

Power Platform Build Tools

All responses (3)

Answers (0)

JK-25091409-0 58 on at

Like (0)

Report

ForAll Loops

@NN_Henkel That's exactly what I'm looking for. Is that like a 'limit' in sql? How is that coded? I can't Google it.
NN_Henkel 9 on at

Like (0)

Report

ForAll Loops

Before I run an "ForAll", I always run "top 1" or "top 10", until I am sure :)
ronaldwalcott 2,268 on at

Like (0)

Report

ForAll Loops

You can backup a table by creating a copy of it or exporting the data.

In theory an update would work as its only 500 rows, if that is what you are asking.

If you mean syntactically then no, as you cannot Patch the table being looped.