Answered

Checking If a Date Exists

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good Morning All,

For background: I have a SharePoint list that is updated by users once a week through a form I have created in Power Apps. If User A has already added numbers to a particular column in the list for today, then that input box is now only editable by User A. If nobody has made any inputs today, there will not be any items or records with today's date in it.

So, I have a column in the SP list called--(hold on to your hats)--Date.

How can I check if there is a record with today's date in the Date column?

If I do a line like this:

If(LookUp(Accomplishments, IsToday(Date) and User_Name = LabelCurrentUser, User_Name)<> LabelCurrentUser.Text, DisplayMode.Edit,DisplayMode.View)

If today's date is not in the SP list, it defaults to a fail. I need an If statement that checks if there are any records with today's date in the Date column.

Frank D. Puthuff
Dell Technology

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

You can determine this with:

With(_items: Fiter(Accomplishments, User_Name = LabelCurrentUser.Text)}, If(LookUp(_items, !IsBlank(Date), true), Edit, View ) )

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I basically need something that asks:
Is there a record with today's date?
or
Does today's date exist in the date column?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

There is some logic missing in what you are saying...

In your formula you are relating records to the user. How does that factor into what you are now saying?

Is there a record with today's date? for the current user??

or

Does today's date exist in the date column? for the current user??

Not clear on where that fits in.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Disregard current_user.

Does the today's date exist in the Date column.

I re-looked at my initial post and see that I asked this question, "How can I check if there is a record with today's date in the Date column?" 😉 With that one piece of knowledge, I should be able to build the rest of my logic.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Anonymous

Yes, so then just modify the formula to remove the user check:

If(LookUp(Accomplishments, IsToday(Date), true), Edit, View )

That should check to see if there is any record with today's date in it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
We're getting close. If I were to change the true to a false, like so:
If(LookUp(Accomplishments, IsToday(Date), false), Edit, View )
Would it do the Edit if there were no records with today's date?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I am going to call this a solution. You got me close enough, and with a little testing, I got it working like I needed.
I can't figure out how you create that blue box to write code in, but here is the code that is working for me on one of my rows.

If(LookUp(Accomplishments, IsToday(Date), false), DisplayMode.View, If(LookUp(Accomplishments, IsToday(Date) And (GSEP_CHG_Storage_Complete > 0 Or GSEP_CHG_Storage_Failed > 0), User_Name <> LabelCurrentUser.Text), DisplayMode.View, DisplayMode.Edit))

Thank you @RandyHayes

Was this reply helpful? Yes No