Answered

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

(0) Share

Report

Posted on by SamR

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,408 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
SamR 30 on at

Like (0)

Report
Copy link

Link copied!

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:
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:

Was this reply helpful? Yes No
WarrenBelz 153,408 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No