Answered

Remove Items from more than one SharePoint list

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

h-nagao 392 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thanks h-nagao that worked a treat!

appreciate your prompt resonse

Mike

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Kris,

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

kind regards,

Mike

Was this reply helpful? Yes No