Answered

Sharepoint and powerapps calendar

(0) Share

Report

Posted on by Gene1

Hello I am trying to allow user to only submit Start date and time once. I am using SharePoint Calendar and submitting the form using powerApps

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Gene1

How do you want to submit the events? By EditForm or Patch function?
''I also would like to have the end date be the same as start date. However be able to put start time and date.' - What does this sentence mean?
If you want to use EditForm, try to add judgment condition to OnSelect property of submit button, if the schedule is repeated, show an error notification, else then submit the form.

ClearCollect(ColLocation,Filter('Calendar Name',Location =Location_DataCard1.Update ));If('End Time_DataCard1'.Update in Filter(ColLocation, 'Start Time'='Start Time_DataCard1'.Update).'End Time',Notify("Schedule Repeated",NotificationType.Error),SubmitForm(FormName))

Sik
Gene1 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Sik,

Thank you for this solution! It partially works, for example:
If I add 7am-8am and try to add the time again does not let me submit the form which is awesome. However, If I add 7am-9am and then 7:30am-8am let's me submit even though the 7am-9am time frame is already reserved.

Are you able to give a work around for this issue?

Thank you in advance @v-siky-msft
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Ok @Gene1
I have changed the logic, please try this:
ClearCollect(ColLocation,Filter('Calendar Name',Location =Location_DataCard1.Update )); Clear(ColTest); ForAll(ColLocation,If('End Time_DataCard1'.Update<='End Time' && 'Start Time_DataCard1'.Update >= 'Start Time', Collect(ColTest,true))); If(true in ColTest,Notify("Schedule Repeated",NotificationType.Error),SubmitForm(FormName))
Sik
Gene1 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, it is working well so far! Truly appreciate your help @v-siky-msft