Timer not working

[steve_hendy]

I have a custom SharePoint form with a button and a timer set to 3s with the following code in both.  The timer auto starts and does run for 3s.

Set(
varlookupCourses,
LookUp(
'Work Activity Approvals',
ID = Value(DataCardValue8.Text),
Name
)
);
ClearCollect(
col_Courses,
LookUp(
'Courses Required for Work Activity',
varlookupCourses = Title
).'Courses Required'
);
Set(
varCourses,
col_Courses
)

If I press the button it works but when the timer finishes it doesn't work.  Why doesn't the timer code (OnTimerEnd) run?  I'm trying to do away with the button.

[RandyHayes]

@steve_hendy 

What is it that you are trying to accomplish with the timer?

Your formula can be refined to:

Set(
    varCourses,
    LookUp('Courses Required for Work Activity',
        Title =  LookUp('Work Activity Approvals', ID = IfError(Value(DataCardValue8.Text), 0), Name),
        'Courses Required'
    )

It seems that you are trying to also get a list of courses.  However, the LookUp function is only going to return one result.  

[steve_hendy]

The code works fine and returns 2 items in this case and without delegation.  Its a label, bottom row in my picture.  I want the label to display my variable when the form opens or if I make a change to another combobox.  As I said the button works but the timer doesn't and the same code is in both.  The form is the same form for new, edit and view.

[RandyHayes]

@steve_hendy 

Yes, so I am not sure of the purpose of the timer then.  If you want that value in the Label then you just need the formula on the Text property:

LookUp('Courses Required for Work Activity',
    Title =  LookUp('Work Activity Approvals', ID = IfError(Value(DataCardValue8.Text), 0), Name),
    'Courses Required'
)

What role does a timer play in your app?

[steve_hendy]

I have a formula in the label Concat(varCourses,Value,", ").  I tried pasting your formula there but it did not work, everything was red underlined.

For the second time, the purpose of the timer is to do away with the button.

[RandyHayes · Accepted solution]

@steve_hendy 

You don't need a timer to replace a button.  You simply need to put the formula in your control that you want.

If you are trying to get the value of a Lookup to a datasource in the label, then that is all you need in the Text property of the label.

Can you provide more detail on what the error was...not just that it was red underlined?  Knowing the error it is stating will explain what the problem is and will provide a clue for me as to what is going on.

However...making a guess by looking at your current formula in the label, and based on a statement I made previously in a response that it seemed you were trying to get a table of records...not a single lookup record.  You stated that you just wanted to display a variable that was created.  But in fact, you are using the Concat function on a variable...not just a variable.  

So, based on that, I am deducing that the 'Courses Required' column is a Lookup column in your datasource.

Also, I will be deducing that the error you are seeing when trying the formula is "expected text value" and not a record.

So, your formula in the Label then (based on all of those assumptions) is:

Concat(
   LookUp('Courses Required for Work Activity',
    Title =  LookUp('Work Activity Approvals', ID = IfError(Value(DataCardValue8.Text), 0), Name),
    'Courses Required'
   ),
   Value & ", "
)

Which...to reduce the trailing comma, can be changed to:

With({_v:
   Concat(
      LookUp('Courses Required for Work Activity',
       Title =  LookUp('Work Activity Approvals', ID = IfError(Value(DataCardValue8.Text), 0), Name),
       'Courses Required'
      ),
      Value & ", "
   )},
   Left(_v, Len(_v)-2)
)

The above will produce a formatted text value based on the Lookup to the lists you stated.

[steve_hendy]

Hi Randy Thanks for your help, This morning I used your technique and got it working. I ended up with this.

With(
{
_v: Concatenate(
Concat(
LookUp(
'Courses Required for Work Activity',
Dropdown1.Selected.Title = Title,
'Courses Required'
),
Value & ", "
),
Concat(
LookUp(
'Courses Required for Work Activity',
Dropdown1.Selected.Title = Title,
'Courses Required:Certificate'
),
Value & ", "
)
)
},
Left(
_v,
Len(_v) - 2
)
)

The final output looked like this