• 1.9k
  • 95
  • 17.9k

Design forms in SharePoint Online - Best approach

Nov 5 2019 7:39 AM

I am designing a form in SharePoint Online, where the form has three kind of users.

  1. Requestor – Can create new event from the Create New Request page. Some form fields required to be auto-populated like logged-in user and some form fields need to have auto-complete on, based on previous value entered.

  2. Moderator – Can blacklist the event, by clicking on the blacklist button in the form. If the organiser is blacklisted, requestor cannot add-in the same organiser again in the New Request page. It should show alert.

  3. Approver - Should approve the request. All form fields should be set to shaded/read only.

I explored various approaches in designing these forms for SharePoint Online.

  1. Using PowerApps and flow – Since the form has lot of customizations, like on button click, should blacklist the event and show alerts. Should show certain fields based on permissions. Each dept users should see their own VP, as a approver in dropdown. I am not sure whether this can be done in PowerApps as its usually a no-code solution. Small JavaScript’s I wont be able to execute, unless depending on Spfx framework which is complex.

  2. Using InfoPath + SPDesigner – I understand InfoPath is being deprecated in 2026 and shouldn’t be absolutely used in SharePoint Online. But it does offer me some JavaScript customization.

  3. Plumsail Forms – I think its doable using Plumsail Forms since it offers form designing + JavaScript’s. Only thing is licenses need to be purchased on yearly basis.

Any technical advice which is the best possible way to design these form to meet the above requirement ? Thanks.


Answers (2)