For All Checking and Updating SharePoint List

(0) Share

Report

Posted on by 4wordsback

Hey All,

I am having trouble getting this to work.

I have a SharePoint list that i am updating/adding contents to depending of whether or not the content is already present.

However I keep getting an error on the second lookup Function

ForAll(colApr,If(IsBlankOrError(Filter(LAST_ORDER_PO,ITEM_SKU).ITEM_SKU),
Patch(LAST_ORDER_PO, Defaults(LAST_ORDER_PO), {
Title:ITEM_SKU,
ITEM_SKU:ITEM_SKU,
QTY:Value(TextInput2.Text),
DATE: Now()

}),

Patch(LAST_ORDER_PO, LookUp(LAST_ORDER_PO,ITEM_SKU = ThisRecord.ITEM_SKU), {
QTY:Value(TextInput2.Text),
DATE: Now()

})

));

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@4wordsback

There are some issues with your formula.

1) ForAll is a table returning function, not a For/Loop like in a programing environment.

2) Your Filter in the first part is going to return a table, not an individual item.

3) Your lookup at the end to patch a record is going to always pick just the first item it finds. If I look at your formula properly, I suspect you might have more than one.

Please consider changing your Formula to the following:

Patch(LAST_ORDER_PO, ForAll(colApr, { ID: ID, Title: ITEM_SKU, ITEM_SKU: ITEM_SKU, QTY: Value(TextInput2.Text), DATE: Now() } ) )

If your colApr collection contains the ID of the original record or a Blank ID if it is new, then the above will do what you need.

First, ForAll will return a table of records. Each record will have the values you want, but more significantly, will have the ID of the original record. That ID will (should be) blank if it is new.

Next, this table is passed to Patch which will patch the entire table to your list. Patch is smart enough to know that if the primary key (ID in this case) is blank, then it will create a record. If it is not blank, then it will update the existing record.

Nothing more needed!

I hope this is helpful for you.

Was this reply helpful? Yes No
4wordsback 46 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you!

Was this reply helpful? Yes No