I'm trying to create a staff course app
I have created a collection of users based on Office 365 group members
Then I have SharePoint lists :-
I linked the course registration collection to the users list collection using
selectedGroup As groupRecord,
mail = attendee_email
Under Search, I have a list of course checkboxes along with an expiry input box that populates a selected course collection with
Course Title & Expire
I then build another collection based on the courses selected using
selectedTraining As tlist,
tlist.selected_course in Training.course_completed,
DateTimeValue("21/05/18"),//replace with user course completion
) < Value(tlist.expires),// if datediff < entered days
Which filters users based on selected courses.Now I want to filter out expired/close to expiry
The problem I am having is targeting the completion date within Training > user course collection.
I have manually entered a date to get it working I need to replace this with Training.completed_date
I have a feeling I need another ForAll(
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!