Answered

Check if a Record is already exits Update Multiple items using patch function else Create New Row in SharePoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have an Excel Like Editable Grid that is using a PowerBIIntegration.Data as a data source. I have a save button on a screen, and when I click save (Multiple Items to Update Existing or Create Multiple item)
I want to update an Request_ID if it already exists in SharePoint else Create New item in the SharePoint list. .
Here is what my logic looks like right now...

ForAll(
 Filter(
 Gallery1.AllItems,
 Toggle1.Value = true
 ),
 Patch(
 BSD,
 {
 Request_ID: TextInput1.Text,
 Family_Code: ComboBox4.Selected.Family_Code,
 SAP_Part_Number: TextInput2.Text,
 IEC_BLOCK: TextInput3.Text,
 JIC_BLOCK:TextInput4.Text,
 IEC_ETAG:ComboBox4.Selected.IEC_ETAG,
 JIC_ETAG:ComboBox4.Selected.JIC_ETAG,
 Electrical_Status:ComboBox4.Selected.Electrical_Status
 }
 ))

Condition

If(
 IsBlank(
 LookUp(
 'BSD',
 Request_ID = TextInput1.Text
 )
 ),

check condition request ID exists

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Here is some guidance on structure - you will probably get a Delegation warning on the Lookup, but that cannot be avoided

Patch( BSD, ForAll( Filter( Gallery1.AllItems, Toggle1.Value ) As aPatch, With( wID: Lookup( BSD: Request_ID = aPatch.TextInput1.Text ).ID ), { ID: If( wID > 0, wID ) Request_ID: aPatch.TextInput1.Text, Family_Code: aPatch.ComboBox4.Selected.Family_Code, SAP_Part_Number: aPatch.TextInput2.Text, IEC_BLOCK: aPatch.TextInput3.Text, JIC_BLOCK: aPatch.TextInput4.Text, IEC_ETAG: aPatch.ComboBox4.Selected.IEC_ETAG, JIC_ETAG: aPatch.ComboBox4.Selected.JIC_ETAG, Electrical_Status: aPatch.ComboBox4.Selected.Electrical_Status } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No