Answered

ForAll Patching records that do not exist

(0) Share

Report

Posted on by PeterOwen1

I am trying to build abut that takes the contents of a collection, checks to see if the record already lives in a sharepoint list and if not create a record for it.

Here's what I've got so far but im honestly lost for making it work:

ForAll(If(ShowColumns(CombinedRecords,"field_3" )=Filter(Live_User_Record, "PZINSKEY"),
"Do nothing",
Patch(Live_User_Record,Defaults(Live_User_Record),
{Title:User_idVar},
{LastChange:Now()},
{Changeby:User_idVar},
{PZINSKEY:ForAll(ShowColumns(CombinedRecords,"field_3" ))}
)
))

I would really appreciate any help anyone could give, I may be out of my depth here.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PeterOwen1,

Do you want to patch a not existing column from collection to SP list?

Could you please share a bit more about your scenario?

ForAll( ShowColumns(CombinedRecords,"field_3" ) As aPatch, With( { wItem: LookUp( Live_User_Record, PZINSKEY= aPatch.field_3).ID }, If( IsBlank(wItem), Patch( Live_User_Record, Defaults(Live_User_Record), { PZINSKEY: aPatch.field_3, } ) ) ) )

Was this reply helpful? Yes No
PeterOwen1 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry re-reading my post I didn't do a fantastic job of explaining.

The post came from a place of frustration and I have since re thought my logic, thanks for the reply this post is no longer relevant.

Was this reply helpful? Yes No