web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Stop a Patch if a Drop...
Power Apps
Unanswered

Stop a Patch if a Dropdown Variable That Already Exists has been Chosen

(0) ShareShare
ReportReport
Posted on by

Hi guys, Im trying to create a company time sheet. This involves the user choosing the week ending date from a dropdown and filling out their hours. 

 

laurak230_0-1621345204133.png

However, when they hit save and its patched into Sharepoint, we don't want them to be able to make another timesheet with the same week ending date. So I guess that I need an error code if they choose a "week ending date that has already been used one in of their previous timesheets. Or alternatively an IF statement that will pull up text saying they have already submitted a timesheet for that date

 

I have no coding background so I just cant wrap my head around how to go about it. Anybody wanna have a go? Cheers guys

Categories:
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @laurak230 

    I would start at the dropdown.  How are you populating values in that?  That seems to be where the user would choose the weekending.  So, that would be where I would focus on making that list only show weekending dates that are valid (not completed).

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @laurak230 

    Were you able to work through your issue or do you still need help?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 283

#3
Mohsin Ali Profile Picture

Mohsin Ali 221

Last 30 days Overall leaderboard