Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Visible if item exists in list created by user + item created today/this week/this month

(0) ShareShare
ReportReport
Posted on by 30

Hello,

 

I have a form system that uses a sharepoint list as a data source. I'd like an icon to be displayed if the following is true, but I am having a hard time formatting it. Three icons in total:

1. Visible if Item exists in Sharepoint list made by current user AND item was made today/Date = today
2. Visible if Item exist in Sharepoint list made by current user AND item was made in current week (Sun-Saturday)
3. Visible if Item exists in Sharepoint list made by current user AND item was made in current month

 

Can anyone help me getting the syntax right for these? 

Categories:
  • WarrenBelz Profile Picture
    WarrenBelz 145,434 on at
    Re: Visible if item exists in list created by user + item created today/this week/this month

    @SamR ,

    I cannot see your model, but the principle is the same - you need to refer whatever record that is displaying to the logic I posted.

  • SamR Profile Picture
    SamR 30 on at
    Re: Visible if item exists in list created by user + item created today/this week/this month

    Thanks @WarrenBelz !

    I have one follow up question that I should have mentioned. These check marks are not associated with list items themselves. That is, they are on a "home page" that users can use to get to different sharepoint list form submission screens.

    My hope is that users can take a quick glance at the home screen and see a green check mark if that respective form has been submitted for the day. Is this doable somehow? Maybe another method?

    Home screen:

    SamR_1-1631548765342.png

    And then clicking on one of the items takes you to the respective form with it's own sharepoint list as it's data source:

    SamR_2-1631548859381.png

     

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 145,434 on at
    Re: Visible if item exists in list created by user + item created today/this week/this month

    Hi @SamR ,

    Today

    IsToday(Created}

    Current month

    Month(Today) = Month(Created) && Year(Today) = Year(Created)

    Current week

    DateDiff(
     Created,
     Today(),
     Days
    } < 7 && 
    WeekDay(Created) < WeekDay(Today())

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard