User Profile
chudson002
Brass Contributor
Joined 5 years ago
User Widgets
Recent Discussions
BUTTON LOADING EMPTY RECORDS INTO COLLECTION - ONLY ONE RECORD IN LIST
Good morning, Have an app where a collection is loaded on the click of a button. There is only one record in the SharePoint list. When button is clicked, it loads not only the one record, but it also loads empty records. What could be causing the empty records to load? Thanks, V/R chudson002DATEDIFF DILEMMA
Happy New Year Community, Need to calculate the number of days between Closed Out and Due AND calculate the number of days between Today and Due when Closed Out is Blank. If(ThisItem.Timely = 0, (DateDiff(Today(), ThisItem.Due, DateDiff(Today(), ThisItem.Due)))) The code does not error out, but it does not return the number of days for each formula. If(ThisItem.Timely = 0, (DateDiff(Today(), ThisItem.Due) Or DateDiff(Today(), ThisItem.Due))) Thanks in advance for assistance. V/R chudson002FILTER GALLERY NOT BY LIST
Happy Holidays Community, Two requirements needed: (1) Need gallery dropdown to displaydistinct namesfrom the GalleryNOTthe SharePointlist: dd = Distinct(Timeoff, Employee.Displayname). List = Timeoff Gallery = TimeoffFY22 The above works great, but pulls in names that do not need to display based on User. (2) Need names to reflect only individuals for which User() is the Supervisor of the Team... (5 Teams). The app has multiple galleries incorporating data from various lists. The common column in each list is Team. The number of employees are 62. For example, the list has 62 records and the User only needs to see the records where the Team name is the same for the User. FYI. Have an app utilizing Lookup... when the Team is selected the Supervisor name appears. Seen a lot of examples IRT filtering, etc., but, doesn't get the result needed. Any recommendations on logic? V/R CarlaICON VISIBILITY
Good Day Community, Have an icon that needs to be visible if two conditions are met in the gallery. The below code does "not" show any errors in the formula bar, only on the gallery item. If(ThisItem.Division = "Sales" && ThisItem.Days > 145, true, false) Recommendations? V/R chudson002GALLERY COUNT
Good Day. Was wondering if anyone could assist. Have 2 galleries, when status is selected (top), it should filter the gallery below. (1) The count and items are correct, but when selecting the status, i.e Pending, gallery does not filter. Count - Text: CountRows(Filter(TrainingTravel_1, Status = ThisItem.Filter && SupvrEmail = varUser.Email)) Items:Table({Filter: "Pending"}, {Filter: "Approved"}, {Filter: "Disapproved"}, {Filter: "All"}) Gallery:Sort(Filter(TrainingTravel_1, SupvrEmail = varUser.Email), Start, Ascending) (2) Filtering works when selected, but cannot get the count for "All" (same for above) Text: CountRows(Filter(TrainingTravel_1, Status = ThisItem.Filter && 'Created By'.Email = varUser.Email)) Items:Table({Filter: "Pending"}, {Filter: "Approved"}, {Filter: "Disapproved"}, {Filter: "All"}) Gallery: Switch( SelStatus_3.Selected.Filter, "All", TrainingTravel_1, "Pending", Filter( TrainingTravel_1, Status = "Pending" ), "Approved", Filter( TrainingTravel_1, Status = "Approved" ), "Disapproved", Filter( TrainingTravel_1, Status = "Disapproved" ), Sort(Filter(TrainingTravel_1,'Created By'.Email = varUser.Email), Start, Ascending)) Thanks you for any assistance you can provide. V/R chudson002
