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

I have the same question (0)

All responses (4)

Answers (1)

v-siky-msft on at

Like (0)

Report
@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

Was this reply helpful? Yes No
Gene1 7 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
Gene1 7 on at

Like (0)

Report

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

Was this reply helpful? Yes No