My goal is to be able to display Status="Not Started", Status="In Progress", Status="Dead Deals", etc. based on button click.
On my Screen my OnVisible property is set to filter already to pull data for my pie chart:
If(!IsEmpty(Filter(Admin_LeadData,FullName=varUser)), ClearCollect(colDash_StatusTrack,{Status:"Not Started",Count:CountIf(Lead_Data,Status.Value="Not Started")}); Collect(colDash_StatusTrack,{Status:"In Progress",Count:CountIf(Lead_Data,Status.Value="In Progress")}); Collect(colDash_StatusTrack,{Status:"Dead Deal",Count:CountIf(Lead_Data,Status.Value="Dead Deal")}); Collect(colDash_StatusTrack,{Status:"Completed Deal",Count:CountIf(Lead_Data,Status.Value="Completed Deal")}), ClearCollect(colDash_StatusTrack,{Status:"Not Started",Count:CountIf(Lead_Data,Status.Value="Not Started"&&Or(AssignedTo.Value=varUser,LeadMember1.Value=varUser,LeadMember2.Value=varUser,LeadMember3.Value=varUser))}); Collect(colDash_StatusTrack,{Status:"In Progress",Count:CountIf(Lead_Data,Status.Value="In Progress"&&Or(AssignedTo.Value=varUser,LeadMember1.Value=varUser,LeadMember2.Value=varUser,LeadMember3.Value=varUser))}); Collect(colDash_StatusTrack,{Status:"Dead Deal",Count:CountIf(Lead_Data,Status.Value="Dead Deal"&&Or(AssignedTo.Value=varUser,LeadMember1.Value=varUser,LeadMember2.Value=varUser,LeadMember3.Value=varUser))}); Collect(colDash_StatusTrack,{Status:"Completed Deal",Count:CountIf(Lead_Data,Status.Value="Completed Deal"&&Or(AssignedTo.Value=varUser,LeadMember1.Value=varUser,LeadMember2.Value=varUser,LeadMember3.Value=varUser))}) )
My gallery Items property is set to filter my SharePoint list data based on the user logged in.
If(!IsEmpty(Filter(Admin_LeadData,FullName = varUser)), Lead_Data, Filter(Lead_Data, AssignedTo.Value = varUser || LeadMember1.Value = varUser || LeadMember2.Value = varUser || LeadMember3.Value = varUser || LeadMember4.Value = varUser))
What would be my best way to accomplish this without breaking the way my app is working aready? Is it possible? With this in mind I also want to next create a button on my red banner that will sort by the date created.
Solved! Go to Solution.
Hey @KimberlyM
@cwebb365 Thank you! I almost understand this (I am coming off of 3 day stomach flu and not feeling top game yet, couldn't remember my computer password this morning either...).
&& (statusColumn = TabSelected) what should statusColumn be referencing? I have tried to reference my column name (Lead_Data.Status as well as Lead_Data.Status.Value) and my gallery display label (Dash_Status as well as Dash_Status.Text).
On each of my buttons I have put this on my onSelect property:
Set(TabSelected, Dash_Status.Text = "Not Started")
Set(TabSelected, Dash_Status.Text = "In Progress")
Set(TabSelected, Dash_Status.Text = "Dead Deal")
Set(TabSelected, Dash_Status.Text = "Completed Deal")
Nothing on my Display All button as I haven't figured out how to show this yet.
Hi @KimberlyM
@yashag2255 Am I defining SelectedStatus somewhere? My brain is just not firing today. I am not understanding what I am missing.
Here is what I am seeing (screencap below) - SelectedStatus is unhappy. It keeps saying that it is not recognized. This is set on my gallery's Items property and on each of my tab buttons I have Set(TabSelected, SelectedStatus = "Not Started") respectively (tab button In Progress will be set to "In Progress", etc.) set on the OnSelect property.
Thank you so much for the time and help on this. I am so close but so lost at the same time right now!
So if I go with this:
If(!IsEmpty(Filter(Admin_LeadData,FullName = varUser)), Lead_Data, Filter(Lead_Data, (AssignedTo.Value = varUser || LeadMember1.Value = varUser || LeadMember2.Value = varUser || LeadMember3.Value = varUser || LeadMember4.Value = varUser) && (Status = TabSelected)) )
The = has the error "Invalid argument type." So my column is called Status in my SharePoint list and if I add the Lead_Data.Status (my sharepoint list name), or a collection I have being called as colDash_StatusFilter.Status I get delegation warnings. I 90% understand what I am doing but I get confused on what to call where yet. Hence my trying of various logical test equations.
User | Count |
---|---|
174 | |
116 | |
85 | |
44 | |
41 |
User | Count |
---|---|
238 | |
152 | |
131 | |
77 | |
72 |