Forum Discussion

bradt30h's avatar
bradt30h
Copper Contributor
Jul 06, 2021
Solved

Building SharePoint forms with default form or PowerApp form?

Hi Guys,   I am building a SharePoint form which require the following function: Data validation Retrieve data from database  - for instance, retrieve client data after inserting client...
developer
  • RobElliott's avatar
    RobElliott
    Jul 06, 2021

    bradt30h if it's in SharePoint yes you can just use a lookup column, but if it's in any other app then you'd need a Power Apps form.

     

    Rob
    Los Gallardos
    Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

RobElliott's avatar
RobElliott
Silver Contributor
Jul 06, 2021

bradt30h as you'll be retrieving client data from a database you'll need to build a Power Apps customized form as, depending what the database platform is, you can add it as a datasource in your form.

 

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

  • bradt30h's avatar
    bradt30h
    Copper Contributor
    Jul 06, 2021
    Thanks for your reply Rob,

    Imagine, if the database is in excel/SharePoint (SP), I suppose it can be done using SP default forms right?

    Rgds
    Brad
    • RobElliott's avatar
      RobElliott
      Silver Contributor
      Jul 06, 2021

      bradt30h if it's in SharePoint yes you can just use a lookup column, but if it's in any other app then you'd need a Power Apps form.

       

      Rob
      Los Gallardos
      Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources