Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 2zmFMB43phJktl7v+k+Gsq
Power Apps - Building Power Apps
Unanswered

Caching in Custom SharePoint Form with Multi choice Checkbox

Like (0) ShareShare
ReportReport
Posted on 19 Jun 2023 15:29:35 by 7

Hi,

 

I have a sharepoint list with multi select choice field. I have customised the sharepoint form where the dropdown list is changed to checkboxes. global variables are used to capture the checkbox selections. I have followed some of the videos available on youtube to do this. (Use a gallery and add checkboxes within the gallery).

 

It works fine as expected. However, I have come across an issue with caching the checkbox selections.

I have tried to reset the variables as mentioned in the videos. (OnNew/OnEdit/OnCancel/OnSuccess) Unfortunately, none of them works. If I try to create a second item soon after creating an item, the previous selections are retained.

 

has anyone come across such an issues? I would really appreciate if you can help me solve this,

 

Many Thanks,

Categories:
  • MichelleW Profile Picture
    2 on 29 Feb 2024 at 06:11:36
    Re: Caching in Custom SharePoint Form with Multi choice Checkbox

    Hi anoomathew - Do you remember what you did to resolve? I am having the same issue with my check boxes not resetting after submitting.

    Thanks!

  • KDMTech Profile Picture
    2 on 07 Dec 2023 at 17:47:19
    Re: Caching in Custom SharePoint Form with Multi choice Checkbox

    I'm curious as to what the fix was?

  • CU03121731-0 Profile Picture
    7 on 21 Jun 2023 at 16:49:44
    Re: Caching in Custom SharePoint Form with Multi choice Checkbox

    Hi,

     

    I managed to fix this problem. Please let me know if anyone else is trying to resolve this.

     

    regards,

     

  • CU03121731-0 Profile Picture
    7 on 21 Jun 2023 at 08:08:44
    Re: Caching in Custom SharePoint Form with Multi choice Checkbox

    Hi WarrenBlez,

     

    Really appreciate your reply. I can understand why my answer was a bit confusing to you.

     

    I started the form customization as per https://www.youtube.com/watch?v=Vj8uP2zaMtA.

    When I faced with the problem I mentioned, I decided to implement the same functionality in a canvas app. That's when I used the multiple screen implementation. I would like to get this working either as a canvas app or as a sharepoint list form customization.

     

    Many Thanks,

     

  • WarrenBelz Profile Picture
    146,804 Most Valuable Professional on 20 Jun 2023 at 20:29:29
    Re: Caching in Custom SharePoint Form with Multi choice Checkbox

    Hi @anoomathew ,

    Seems a bit of a different question to your post which was about the integrated functions. I will however add that Integrated Forms were never designed to be multi-screen and as I mentioned some in-built functions do not always work as you might expect once you get beyond the basic View/New/Edit functions on the chosen record. 

    I am guessing a bit here, but trying to add a new record in a manner other than selecting "New" from SharePoint may be confusing the system a bit. To be honest, if I needed to write the functionality you have, I would have been on a Canvas app long ago.

  • CU03121731-0 Profile Picture
    7 on 20 Jun 2023 at 17:56:22
    Re: Caching in Custom SharePoint Form with Multi choice Checkbox

    Hi WarrenBelz,

     

    Thank you very much for your response.

     

    I am capturing all the forms in a screen and use a button to submit the form. Once the form is submitted, I try to navigate to another screen which has another button to add a new item. I tried to reset the form and refresh the data source after OnSuccess() of the first form and also OnSelect() of the New Button.

    ResetForm(Form)

    Refresh(list data source).

     

    In spite of all these, the selections are being retained. Am I missing something else here?

     

    Many Thanks,

     

    Anu

  • WarrenBelz Profile Picture
    146,804 Most Valuable Professional on 19 Jun 2023 at 21:37:59
    Re: Caching in Custom SharePoint Form with Multi choice Checkbox

    Hi @anoomathew ,

    You have experienced one of the "helpful" functions of SharePoint Integrated Forms. When an action is finished, it executes a RequestHide(), which is exactly that - the form is actually still open and when another record is selected, the only thing that is updated is the SharePointIntegration.Selected record reference (so it simply displays the next chosen record). It does not run any of the integrated function actions you mention, unless the user refreshes SharePoint every time they change records. 

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 20

#2
BCBuizer Profile Picture

BCBuizer 10 Super User 2025 Season 1

#2
LC-26081402-0 Profile Picture

LC-26081402-0 10

Overall leaderboard
Loading started
Loading complete