Forum Discussion

YannDevo13's avatar
YannDevo13
Copper Contributor
Aug 10, 2023

Calendar List in Sharepoint - Default item values

Hi all, 

 

I hope you're all doing good. 

 

I am doing an office attendance calendar from a sharepoint list in order to enable my coworkers to state when they are coming at the office. 

The list only have 3 values :

-The user

-The date 

-Other (Mandatory column of the list i couldnt delete)

 

With the calendar view, this is what it looks like : 

 

And this is the form

 

 

In order to increase user exp, I wanted to set the user per default so he doesnt have to select himself by using this code in power apps form as defaultselecteditem value :

{
DisplayName:User().FullName,
Claims:"i:0#.f|membership|" & Lower(User().Email),
Email: User().Email,
Picture:""
}

 

But by changing that, the name directly display itself. 

But unfortunately, when clicking direclty on the calendar on the + button, the date doesnt set itself by default anymore (while it did in the before the change).

 

 

It is as the Parent.Default function doesnt work anymore... 

 

 

Can someone explain me what is happening here and how to solve that ? 

 

Thanks a lot,

 

  • Kelly_Edinger's avatar
    Kelly_Edinger
    Bronze Contributor
    Are folks submitting on behalf of others? If not, you should be able to use the Created field rather than using the additional people picker field of User.
    • YannDevo13's avatar
      YannDevo13
      Copper Contributor

      Thanks Kelly_Edinger for your answer. 

       

      Unfortunately, it does the same than the other technique, the default value for the date is considered as blank and is not the date containing the "+" sign. 

       

      Greetings,

      • ganeshsanap's avatar
        ganeshsanap
        MVP

        YannDevo13 I think it is not possible to set the selected date from SharePoint list calendar view as default date in Power Apps customized list form.

         

        Power Apps cannot understand/receive the date selected from SharePoint list calendar view. Parent.Default might be resulting in the current date column value for the item (Blank for new item and actual column value for view/edit forms).

         

        You can set the today's date as default date for date control in the Power Apps form - but again that might confuse users if they click on +New button for other dates than today.


        Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Share

Resources