I have a list of staff members in a vertical gallery (Sharepoint)
Inside that gallery I have placed a horizontal gallery that is filtered so the items in the horizontal gallery match up with the respective items in the main gallery.
In the horizontal gallery are checklist items that are checked off when they are completed elsewhere in the app. the data for the horizontal gallery is structured like the image below
Instead of showing a gallery of what checklist items have been done, I want to show what's not been done
I have assumed in order to get this I will first need the static list of full check list codes in the app and then remove the items I have for that staff member stored in SP
(I have a collection of completed code in the on start)
ClearCollect(Clist,["PHO","APP","REF","PHS","RRS","PSA","RFA","IDR","VPD","VSS","VPC","CHI","CHS","CHC","RFI","VNO","VCO","VCH","COV","NOQ","SAP","CED","DSD","QUA","SOS","SMY","SHR","CSS"])
So i would like to start with this collection and take off the ones that are found for that person in SP
Filter(Demand_Checklist_Completed,Staff_Member=ThisItem.First_Name&" "&ThisItem.Last_Name1).Checklist_Item_Code
This is the formula i have at the moment which is just grabbing the items each staff member has.
how do I switch this up to show the items they don't have from the collection.
Thanks
🙂
