Announcements
i created variable context for each button , now i want to add one more button that should skip completed status details and show reaminings records in gallery
any idea?
Hi @justlearner1
Filter('SPList', IsBlank(varStatus) || varStatus = "All" || Status.Value = varStatus )
Thanks,Stalin - Learn To Illuminate
Hi please see the image, I need one more button that should display all status details by skipping completed status... I don't how to write context variable in it.
Hi @Ungarala1
Set the onselect property of the button to
UpdateContext({varStatus:"SkipCompleted"})
With ( {item: 'SPList'}, If( varStatus = "SkipCompleted", Filter( item, Status.Value <> "Completed" ), Filter( item, IsBlank(varStatus) || varStatus = "All" || Status.Value = varStatus ) ) )
Please let us know if anything needs on your post. We can help with this.Please mark the post as Solved If I have answered your question.Please give it a Thumbs Up if you find the suggestion helpfulThanks,Stalin - Learn To Illuminate
this is my existing code, after inserting your code it is not working
SortByColumns(Filter('SPTracker',
Program.Value = varproject || IsBlank(varproject) || varproject = "All",Status.Value = varStatus || IsBlank(varStatus) ||varStatus="All",'Task Type'.Value=vartask||IsBlank(vartask)||vartask="All",StartsWith('Task Number',searchbox1.Text)
),"ID",Descending)
Please try this
SortByColumns( Filter( 'SPTracker', IsBlank(varproject) || varproject = "All" || Program.Value = varproject, IsBlank(varStatus) || varStatus="All" || Status.Value = varStatus, IsBlank(vartask) || vartask="All" || 'Task Type'.Value=vartask, StartsWith('Task Number',searchbox1.Text) ), "ID", Descending )
where i need to add this
varStatus = "SkipCompleted",
Please try this with Skip completed one.
SortByColumns( With( {Item: 'SPTracker'}, Filter( Item, IsBlank(varStatus) || varStatus = "All" || (If( varStatus = "SkipCompleted",Status.Value <> "Completed", Status.Value = varStatus )), IsBlank(varproject) || varproject = "All" || Program.Value = varproject, IsBlank(vartask) || vartask="All" || 'Task Type'.Value=vartask, StartsWith( 'Task Number', searchbox1.Text ) ) ), "ID", Descending )
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
