Populate date from calendar view to custom form

Question

Populate date from calendar view to custom form

Jay Holman 61

I have a custom form for my SP list. I have created a modern calendar view on the list. When selecting +New on any given date, the custom form opens but does not populate the date selected. I noticed that the standard form does populate the date selected. Is there a parameter I can pass to the custom form so it defaults to the date selected?

Emily Du-MSFT 51,781 Reputation points Microsoft External Staff

2022-05-05T07:39:12.473+00:00

@Jay Holman

How did you design your custom form?

What does "populate the date selected" mean? Whether there is a date and time column with default value in the custom form and it does not populate default value in the calendar view?

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Jay Holman 61 Reputation points

2022-05-05T18:49:35.487+00:00

Custom form was built in PowerApps. Right now I have the date field as Today on a New form and Parent.Default on an Edit. When looking at the SP list using modern calendar view, I have the option to start a new form directly from any given date by clicking +New in the top right corner of the date box. In a standard form, the date of the box selected will populate to the form by default. I want to modify the custom form to do the same. When I open the standard form in PowerApps the date field is set to Parent.Default. I know the data exists, just don't know how to pull it into the custom form.
didytak-4460 10 Reputation points

2023-08-19T00:30:06.9+00:00

This is my exact problem, too. @Emily Du-MSFT do you have a solution?
Michele Imperiali 0 Reputation points

2024-12-03T14:19:29+00:00
Same issue here. Any update?
My PowerApp form has a default value of "Today()" and if the user creates a new item from the Calendar view in another day, the form still opens with date value equal to the current date, instead of the one selected by the user when clicking on the calendar.
For info this is my actual code:

If( AddTimesheetForm.Mode = FormMode.New, If( !IsBlank(SharePointIntegration.Selected.StartHour), DateValue(SharePointIntegration.Selected.StartHour), // Use StartHour field Today() ), Parent.Default )
Michele Imperiali 0 Reputation points

2024-12-04T10:11:44.66+00:00

Just to come back on this topic. After detailed debugging I can pretty safely confirm that this is a bug affecting the way the Calendar View communicates with a PowerApp form. The SharePointIntegration object that is supposed to carry out info such as the user selection on the calendar looks inexistent when accessing it from PowerApp (printing its value in a label field shows a NULL). Consequently I don't know if there's an alternative approach to get this working, other than reverting to the standard SharePoint form. In that case everything works. In my case this is not a valid option since I have some advanced logic in my form, that is not supported in the standard SharePoint form unfortunately. Let's hope Microsoft fixes this issue soon.

1 answer

Your answer

Emily Du-MSFT 51,781 Reputation points Microsoft External Staff

2022-05-05T07:39:12.473+00:00

@Jay Holman

How did you design your custom form?

What does "populate the date selected" mean? Whether there is a date and time column with default value in the custom form and it does not populate default value in the calendar view?

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Jay Holman 61 Reputation points

2022-05-05T18:49:35.487+00:00

Custom form was built in PowerApps. Right now I have the date field as Today on a New form and Parent.Default on an Edit. When looking at the SP list using modern calendar view, I have the option to start a new form directly from any given date by clicking +New in the top right corner of the date box. In a standard form, the date of the box selected will populate to the form by default. I want to modify the custom form to do the same. When I open the standard form in PowerApps the date field is set to Parent.Default. I know the data exists, just don't know how to pull it into the custom form.
didytak-4460 10 Reputation points

2023-08-19T00:30:06.9+00:00

This is my exact problem, too. @Emily Du-MSFT do you have a solution?
Michele Imperiali 0 Reputation points

2024-12-03T14:19:29+00:00

Same issue here. Any update?
My PowerApp form has a default value of "Today()" and if the user creates a new item from the Calendar view in another day, the form still opens with date value equal to the current date, instead of the one selected by the user when clicking on the calendar.
For info this is my actual code:

If( AddTimesheetForm.Mode = FormMode.New, If( !IsBlank(SharePointIntegration.Selected.StartHour), DateValue(SharePointIntegration.Selected.StartHour), // Use StartHour field Today() ), Parent.Default )
Michele Imperiali 0 Reputation points

2024-12-04T10:11:44.66+00:00

Just to come back on this topic. After detailed debugging I can pretty safely confirm that this is a bug affecting the way the Calendar View communicates with a PowerApp form. The SharePointIntegration object that is supposed to carry out info such as the user selection on the calendar looks inexistent when accessing it from PowerApp (printing its value in a label field shows a NULL). Consequently I don't know if there's an alternative approach to get this working, other than reverting to the standard SharePoint form. In that case everything works. In my case this is not a valid option since I have some advanced logic in my form, that is not supported in the standard SharePoint form unfortunately. Let's hope Microsoft fixes this issue soon.

Answer 1

Emily Du-MSFT 51,781 Microsoft External Staff

@Jay Holman

Per my test, default view and calendar view use the same custom form. You could design form as following picture shows.

Result:

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Emily Du-MSFT 51,781 Reputation points Microsoft External Staff

2022-05-10T02:22:18.507+00:00

@Jay Holman

I’m checking how the things are going on about this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.
Emily Du-MSFT 51,781 Reputation points Microsoft External Staff

2022-05-24T06:39:04.723+00:00

@Jay Holman

I am looking forward to your feedback if there is any update.

Please remember to update this thread if you have any progress.

Thank you for your understanding.
Jay Holman 61 Reputation points

2023-01-10T15:15:20.683+00:00

This did not answer the question that was asked. I do not want Today() as the default. I want the selected date as the default. It works fine in a standard form but for some reason not in a custom form.
Cindy A Desantis 0 Reputation points

2023-05-30T20:39:23.8333333+00:00

Was there an answer to this issue?
Nick Phillips 0 Reputation points

2023-07-25T14:06:24.99+00:00

Quite an obvious & simple request isn't it?
didytak-4460 10 Reputation points

2023-08-19T00:33:34.5033333+00:00

This is my exact issue, too. @Emily Du-MSFT do you have a solution for this problem?

Share via

Populate date from calendar view to custom form

1 answer

Your answer