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
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 🙂
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications