Set(varProvRecord, Blank()); <- This is giving me an error

[NitroPepsi]

Hello, the rest of the formula is coming back fine except when I do the Set command. Can anyone tell me why this is happening?

Set(varRecord, Patch('[incentive_test].[D_eTime]', Defaults('[incentive_test].[D_eTime]'),{PROVIDERNUMBER:"000000", Employee_Display_Name:"Please Select Provider", d_provider_ky:-1}));
EditForm(FormEdit);
Navigate(scnUpdate,None);
Set(varProvRecord, Blank());

[WarrenBelz]

Hi @NitroPepsi ,

That is because the structure of the Variable is a Record in the Patch and then a single value below, so you would need

Set(
   varProvRecord,
   Defaults('[incentive_test].[D_eTime]')
)

in the bottom item. But I have to wonder why you are setting a Variable, then immediately clearing it - why not set it to a blank record in the first place ?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps