Unanswered

Filter by Date Using Today

(0) Share

Report

Posted on by Cmastmaint

Hello, I need help trying to get a filter function work. I am trying to create a page that looks at a SharePoint named Daily Log. Individuals sign into this log and the Date and Time is captured with Now and stored into the Sharepoint Daily log as single line text consisting of date and time. What I would like to do is have a Gallery that populates showing only items on the list that are the current days date and allow them to sign out. Every attempt I have made has failed. Can I please get help with step by step instructions that tell my what to use, why to use that, and description of what it means. I am still getting used to making apps and using the correct syntax and things. Any help is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

mmollet 3,187 on at

Like (0)

Report

To do this what I did was added a column called IsCurrent. This menas that the user has 100s of login sessions but only one of them is "Yes" in the IsCurrent field. I use a lookup or filter to then grab that login from the SP List.
Filter(TimeLedgerV3, IsCurrent = "Yes") -> will give all the currently loggin in sessions in the list.
LookUp(TimeLedgerV3, IsCurrent = "Yes" And Name = User().FullName) -> this will return a users currently logged in session if there is one.

Is this kind of what you want to do or not? Here are my columns in the SP List although many of them are specific to the field this app was built for. (Auctioneering)

User's Name Start/End Times Hours Worked If current or not

Was this reply helpful? Yes No
Cmastmaint 57 on at

Like (0)

Report

I left out some context that may have helped someone help me. It may also be not that smart on how I built the app because it is only my second app and I am not a programmer nor am I familiar with Excel. No one actually logs in technically speaking. They enter their name, their company name, and the person they are here to visit and I have the app submit the current date and time. That field is from the Sharepoint named Daily Log and date and time is captured in a filed named Time In. What I would like to do is create a gallery that shows only who has visited today, who has not already left, and then update that sharepoint list with a Time Out. Similar to like a punch in and punch out time clock. Perhaps you already answered my question and I am not smart enough to apply it to mine LOL!! That is really all I want it to do. Show people by today's date only and then allow them to update the list with the time they leave. Far too many people who are random and forever changing to have logins.

Was this reply helpful? Yes No