DateTime for Sharepoint + Outlook

[thsteh]

Hello,

i want to patch a sharepoint list + create outlook element using one date/Time Value,

following code creates a datetime value from date picker +  Timepicker(dropdown) and works fine:

UpdateContext(
    {
        VarCalStartTime: Text(
            dte_Abw_Startdate.SelectedDate + Time(
                Left(
                    dte_starttime.Selected.Value;
                    2
                );
                Right(
                    dte_starttime.Selected.Value;
                    2
                );
                "00"
            );
            "yyyy-mm-dd HH:mm:ss"
        );
        VarCalEndTime: Text(
            dte_Abw_Enddate.SelectedDate + Time(
                Left(
                    dte_endtime.Selected.Value;
                    2
                );
                Right(
                    dte_endtime.Selected.Value;
                    2
                );
                "00"
            );
            "yyyy-mm-dd HH:mm:ss"
        )
    }
)

Result is following Format: 2023-08-24 00:00:00 --> Outlook Element gets created in the correct way..

for Patching the SharePoint List is use this:

                Start_Abwesend: DateTimeValue(VarCalStartTime);
                Ende_Abwesend: DateTimeValue(VarCalEndTime);

This Format gets created: 24.08.2023, 00:00:00

Sharepoint List Format seems to be: 24.08.2023 00:00   (no comma and no seconds)

the Date always gets patched correclty, but time value nut - anyone got an idea how i can change the code?
its mandatory keep VarCalStartTime + VarCalEndTime for both "jobs"

thanks

Thomas

[WarrenBelz · Accepted solution]

Hi @thsteh ,

Why not keep it simple and not convert date/time to text and back again (while still retaining your Vaiables)

With(
   {
      _Start:
      dte_Abw_Startdate.SelectedDate + 
      Time(
         Left(
            dte_starttime.Selected.Value;
            2
         );
         Right(
            dte_starttime.Selected.Value;
            2
         );
         0
      );
      _End:
      dte_Abw_Enddate.SelectedDate + 
      Time(
         Left(
            dte_endtime.Selected.Value;
            2
         );
         Right(
            dte_endtime.Selected.Value;
            2
         );
         0
      )
   };   
   UpdateContext(
      {
         VarCalStartTime: Text(_Start; "yyyy-mm-dd hh:mm:ss");
         VarCalEndTime: Text(_End; "yyyy-mm-dd hh:mm:ss");
         VarStart: _Start;
         VarEnd: _End
      }
   )
)

Then your Patch

Start_Abwesend: VarStart;
Ende_Abwesend: VarEnd

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.

MVP (Business Applications)   Visit my blog Practical Power Apps

[thsteh]

Hi Warren,

thanks for your response, this looks way cleaner,

i placed your code on a button to test, and but 4 labels for the 4 variables, there it works fine.

but in the function i use for patching it varStart and VarEnd are giving errors:

it says varStart and VarEnd not recognized, any idea?

thanks

[thsteh]

Never mind, this was just a bug.. i cleared all start/End date declaring values i use for patching and reassigned with varStart and VarEnd - no more error message...

@WarrenBelz:

anyways, SharePoint list still isn't patching right! 😞

i selected:

Start 21.08.2023 - 08:15

End  21.08.2023 - 23:59

Sharepoint list gets patched with 21.8.2023 02:00 as Start and as End.. 

also when patching a duration of several days it patches 02:00

any additional idea?

[thsteh]

One additonal information, what i just tried - pulling data from sharepoint list gives just the date, not DateTime.

DateTime is activated in SharePoint List setting...

[thsteh]

Also this was just a Powerapps Bug 💩