Answered

Remove Items from more than one SharePoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I want to remove items from two SharePoint lists when a Delete icon is selected. I am able to do this for one SharePoint list using this formula: Remove('PO Log', Gallery1.Selected); If (IsEmpty(Errors('PO Log', Gallery1.Selected))

But also want to remove multiple items in another list (POOrderDetails). The column they both have in common is: PONumber. Does anyone know how i can adjust the above formula to do this? I have looked at the Remove function info page for PowerApps but am none the wiser as the examples used are only for one list.

Any help would be much appreciated

thanks

Mike

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

h-nagao 392 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi mike,
Your app already connected to ‘POOrderDetails’ ?
If so, could you try to add following formula after Remove(‘PO Log’...) ?

RemoveIf(‘POOrderDetails’,PONumber=Gallery1.Selected.PONumber)

RemoveIf function will remove record(s) from data source if satisfying condition.
In this case, remove records from POOrderDetail when their records have same PONumber as selected in Gallery.

Thanks, Hiro
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you also want to remove multiple items whose PONumber column value is equal to the PONumber value of the selected item in your Gallery1?

I have made a test on my side, please take a try with the following workaround:

Set the OnSelect property of the "Remove" button to following:

RemoveIf('POOrderDetails', PONumber = Gallery1.Selected.PONumber); /* <-- Add formula here. Please type this formula before the Remove('PO Log', Gallery1.Selected)*/
Remove('PO Log', Gallery1.Selected);
If(
IsEmpty(Errors('PO Log', Gallery1.Selected)),
...
)

Or

Remove('POOrderDetails', Filter('POOrderDetails', PONumber = Gallery1.Selected.PONumber)); /* <-- Add formula here. Please type this formula before the Remove('PO Log', Gallery1.Selected)*/
Remove('PO Log', Gallery1.Selected);
If(
IsEmpty(Errors('PO Log', Gallery1.Selected)),
...
)

More details about Remove function and RemoveIf function, please check the following article:

Remove function, RemoveIf function

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

thanks h-nagao that worked a treat!

appreciate your prompt resonse

Mike
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kris,

Yes your formula is smiliar to the one i applied, thanks for your response,

kind regards,

Mike