Answered

Remove function errors for OnSelect

(0) Share

Report

Posted on by Mer-Petti

I have a SharePoint List ('Programs and Projects') feeding my Power App form. I want to Remove the selected SharePoint Record when the Trash Icon is selected. So in OnSelect I have the following formula:

OnSelect = Remove('Programs and Projects', ThisItem)

This basic formula should work and I have seen it demonstrated in multiple videos but I get the following error.

"Name isn't valid, the identifier is not recognized."

Why does my Power App not accept these values and/or how do I identify the offending (Name) data attribute?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Mer-Petti

Try

Remove('Programs and Projects', Lookup('Programs and Projects', ID=ThisItem.ID))

Was this reply helpful? Yes No
Mer-Petti 91 on at

Like
a
(0)

Report
Copy link

Link copied!

I get the same error:

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

What is the Item for the form. For a test try put that in the bit where it says thisitem e.g.

if your forms item is gallery1.selected put in Remove('Programs and Projects', gallery1.selected)

if your forms item is a lookup put in the same place. let us know how that goes.

Was this reply helpful? Yes No
Mer-Petti 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried SharePointForm1.Selected and FormScreen1.Selected. Still getting the same error. 😕

Was this reply helpful? Yes No
Verified answer

Mer-Petti 91 on at

Like
a
(0)

Report
Copy link

Link copied!

So I continued to play around with it and THIS is what worked.
Remove('Programs and Projects',SharePointIntegration.Selected)

It tested out twice and I was able to recover the file from Recycling.

So the solution is to pull in the "SharePointIntegration" terminology with the Selected attribute.
Thank you,
- Merry

Was this reply helpful? Yes No