Hi:
We have an app that we are using the customize form function of a SharePoint 365 list. When the user picks some dates for scheduling an event we would like to do a lookup to see if the combination of those dates already exists for this facility. We can get the lookup to work in either a label control or a text input control. Within the ON CHANGE method of the text input control we would like to set a variable like Set(varError, false); Set(varError,, true).; The variable does not change. tried Reset(control name) and the value does not change, which we would then use in the Coalesce function below where we would change the control to:
Coalesce(Parent.Error,
If(varError = true,
"Schedule conflict" ),
"")
Would actually prefer to do the following but does not seem to work, throws a circular reference error. We use a lookup on the text method of the TextInputCanvas1 control and it does return either a value or blank using the following:
Lookup(ROOMSV7,
(dtestartdate.SelectedDate = StartTime
&& Value(StartTimeHour.Value) <= Value(dtestarthour.Selected.Value)
&& Value(EndTimeHour.Value) >= Value(dtestarthour.Selected.Value)
) , StartTime)
THEN tired the below in the error property of one of the date controls on the form:
Coalesce(Parent.Error,
If(!IsBlank(TextInputCanvas1.Text) ,
"Schedule conflict"
),
"")
This throws a circular error when we used it in the above code.
Thank you
Chuck
