Button function to disable and enable based on SP values

(0) Share

Report

Posted on by Chwilkinson

125

Hello Everybody,

I'm trying to right some code that only lets the user fill in a form once each week. Once the form is submitted to SP the button will be disabled until the next working week.

Each button is associated with a different business area, The function is looking up for a match on the list of the business area and the week number to match the current week, that that is true the button is disabled, if false the button is enabled.

I'm getting no errors in my code yet its not working, the button remains disabled even when the week numbers do not match.

Can anybody spot what I've missed here and help me understand how to correct it?

Thank you

If(
LookUp(
ScoreSheetCollection,
Title = "Business Area" && Value("WeekNumber") = ISOWeekNum(Today()),
true),
DisplayMode. Disabled,
DisplayMode. Edit
)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report
Hey @Chwilkinson

Your LookUp formula is the culprit here - you have the third parameter, the reduction formula, set as true, meaning that regardless of what returns, it returns true.

You can modify your query to the following to get the desired result:

If( //Here we check if the title returned by the lookup is not blank //If that is true then there must be a record there already, so disable !IsBlank( LookUp( ScoreSheetCollection, Title = "Business Area" && WeekNumber = ISOWeekNum(Today()) ).Title ), DisplayMode. Disabled, DisplayMode. Edit )

Cheers,

Sancho

Was this reply helpful? Yes No
Chwilkinson 125 on at

Like (1)

Report

Hello @iAm_ManCat (Sancho)
Thanks for the quick response, I've just tried this code in the button display mode but its coming up with the following error -
The LookUp function has some invalid arguments
Invalid number of arguments: received 3, expected 1
Any suggestions?
Thanks
Chris

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Apologies, yes I left in the comma from your previous code, have amended my example code above 🙂

Was this reply helpful? Yes No
Chwilkinson 125 on at

Like (1)

Report

Thanks @iAm_ManCat , (Sancho)

Its almost working now.
The only issue I'm getting now is that it says Value("Week Number") cannot be converted into a number. Types are incompatible.
But my SP list column is a number column. I'm not sure what's happening here.
I've tried
Value("Week Number")
"Week Number". Value
"Week Number"
"WeekNumber" - As displayed in list settings

Thank you
Chris

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report

If it's a number column then we should be able to reference it directly as WeekNumber, have updated my code response 🙂

Was this reply helpful? Yes No
Chwilkinson 125 on at

Like (1)

Report

Hi @iAm_ManCat ,(Sancho)
Ha that's the only configuration I didn't try. Thank you its working now.
Thank you for your help on this, I've banked some more knowledge!!
Thanks,
Chris

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Cheers, happy to help share the knowledge Chris, hope you have a good day!

Was this reply helpful? Yes No