You’re offline. This is a read only version of the page.
39
Hello,
I've been wracking my head regarding this, I'm trying to format some buttons (left side) consisting of a gallery using ThisItem.ActionCategory from a collection (colActionCategoryTable) grabbed from my main Sharepointlist (Text column).
Right now I use the buttons to set a variable to ThisItem.ActionCategory which I then use to filter the main gallery (sharepoint list with mostly simple columns) based on the ActionCategory column, it also highlights the selected category i.e. what button I've pressed.
However I would like to add some more formatting, namely that all buttons changes colour etc if there are any actions overdue in their corresponding ActionCategory, I suspect the criteria are the following:
If the Column StatusDate is equal or less than todays date
AND Status is set to "Open" OR "New Action"
AND Action Category corresponds to the ThisItem.ActionCategory
I assume I'd need to collect and evaluate these three columns using ForAll( in the OnStart property but I cant get anything to work.
So far I've managed to grab the 3 columns in question but have no idea how to get it evaluated smoothly and returning something I can add to e.g. Switch( or similar...
Here's the collection I managed to grab
Am I way of here?
As you don't have too many Action Categories, you can achieve this using nested gallery on the left side.
Within your left gallery (gal_leftNav_Parent): You already have a button control.
Now add another gallery control (gal_leftNav_Child) within the parent gallery?
This sub-gallery (gal_leftNav_Child) will be of width=1, height=1.
It will not have any controls, just the item property
The item property of sub-gallery will Filter your master SP List based on your business logic for ThisItem.ActionCategory
Now, within your main gallery (gal_leftNav_Parent), you can format button based on AllItemCount of the sub-gallery
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.
Share
Report
All responses (
Answers (
