I am the beginner and have a problem with power apps app.
I have the Sharepoint list with particular dates that can be chosen in the app. User chooses the date, put data and everything appears on the sharepoint list. The problem is when I want to delete data. I put the button that sets variable, then the variable is used to change Yes/No button to "No", then other fields are cleared with IF function related with the variable.
The issue is:
1. Data do not vanish fron the sharepoint list. Only the "Yes/No" button changes:
2. When I use the button once, other records do not have the preview. All fields are empty in the application because Yes/No button is left to "No" while it is "Yes" on the sharepoint list
Can you tell me what to change to achieve my goal (delete data from the sharepoint)
In attachements you can find screens presenting the app and formulas
Solved! Go to Solution.
If you want to delete the item. simply have a button which delete said item by using Remove([DataSet],[Condition])
If you dont want to delete any item but rather filter out rows with false value simply adjust your Gallery / Items to: Filter([DataSet], ![yes/no column] ) or Filter([DataSet],[yes/no column] = false)).
If you are too stubborn and you want to delete items using Toggle:
Event: OnSelect → Remove([DataSet],ThisItem) //basically a button now
Event: OnChange → Remove([DataSet],ThisItem) // alt: Remove([Collection],Gallery.Selected.ID = ThisItem.ID)
Add OnChange of the toggle
I think I will use this solution and create the button inside the gallery. Tell me please how can I clear the column in the Sharepoint list when I have a dropdow there (everything else is working except the dropdown columns)
OK, I am assuming Typ_samochudo is a choice type column. If so, please do two things to allow clearing of that column within your Patch():