Announcements
Hi All,
I am encountering a problem within the application as I attempt to remove an entire row from the data source (Gsheets) based on a specific value selected in the gallery. I have included a Delete icon, and upon selection, the intention is to delete the entire row from the data source. However, I am receiving an error indicating that the remove function has an invalid argument. Attached is a screenshot displaying the error message.
Hi @Hit_23
Just try this
Select(Parent); Remove(skillsTable,ThisItem)
Thanks!
If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
@Rajkumar_404
Thank you for your reply. I have tried the same and got the same error.
Could you clarify if 'skillsTable' refers to the name of a collection or a SharePoint list?
I have connected Google Sheets (Data source) and Skill Table (Data Table)
Try this
Remove(skillsTable,LookUp(skillsTable,ThisItem.Value=Value));
"However, upon applying this formula, the primary data source data should be deleted."
So you should use collection to avoid this.
Thank you, Here
ThisItem.Value=Value))
Value refer the Column name , right?
Yes!
@Rajkumar_404 . Thank you so much!! It worked!!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 551
WarrenBelz 430 Most Valuable Professional
Valantis 298
