I have a gallery with a checkbox based on a sharepoint list. All I want to do is remove the selected items from the sharepoint list - which then in turn will update my gallery list.
I can use this:
This only removes 1 item - I cannot find the syntax for RemoveIf which seems it should run through the records and compare to a value in the list - problem is I want to just compare to the checkbox if it is true or not which is not in the list
I looked at ForAll but I get an error stating I cannot use the same data source i the forall as the remove option which makes me think I need to create a temporary collection and add items in to it on check and then delete them all
I am hoping I do not need to do this - this is supposed to be a powerusers app - not a programmers app and many workarounds I am finding for many things seem to make me think this is not being built with power users in mind.
If anyone can tell me how this can be achieved it would be appreciated.
If CustomerDeviceList was a collection, this formula works. I hope its the same for the sharepoint list.
Be careful, ColumnName should have unique items for that record. A GUID for example, that is not the same on a different record.
I have not had a chance to test this yet as I had to fisrtly get a unique ID to the field to be deleted - this was achieved today and I now need to test this further.
Although I still think as a Power Users tools this is overkill to achieve what should be a simply request using RemoveIf
I agree with you.
There may be an easier way of doing what you need. If you find it, I will use it, too. Please let me know.
this worked for me - no need for a collection - much simpler.
I need to get my head around the @Fields but it works a treat 🙂
I found it here
It is not the solution on the page but the best approach, it was posted by Steelman a bit down the 1st page.
Perfect. Your formula is indeed much simpler.
I also need to understand, how we should use @Fields.
I understand the idea but I have problems using it. The documentation could be better if it had examples.
Thank you Gargoolgala 🙂
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.