cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wilfordm81
Helper II
Helper II

Disabling a Button based on a Date Column in Dataverse Table.

Hi All,

 

I'm at a loss, as I've tried what feels like every combination under the sun, to disable a button based on a date in my Dataverse Table.

 

I've tried if/lookup combinations, I've tried if statements on their own, I've tried countrow formulas. None of them work 🤯😫

 

I have an app which requires users to input data on a daily basis. High priority, includes a RecordDate, and a Company - amongst other float-type data.

 

To prevent duplicates from happening, I want to disable the button which disables the form navigation button for each specific title, of which there are three, based on data that already exists.

 

So far, I have tried (also without the "DateValue()":

 

If(

Title2.Text = varCompany in MyRecordTable.Company

&&

DateValue(Date1.Text) = varDate in MyRecordTable.RecordDate,

Disabled, Edit)

 

I've also tried a Lookup against a specific button:

 

If(

LookUp(

            MyRecordTable, RecordDate = Date1.Text, CompanyID) = DateValue(varDate)

            &&

            MyRecordTable, Company = Title2.Text, CompanyID) = varCompany

            Disabled, Edit

)

 

I get a delegation warning against the equals where datevalue(varDate) because the data types arent the same. And the same warning occurs if I use the Value() function instead.

 

Can anybody see where I'm going wrong, as it's driving me crazy 😅

 

Please and thank you in advance.

 

W.

 

0 REPLIES 0

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,135)