Forum Discussion

Copper Contributor

Mar 31, 2020

Using Forms as a front end for a database

Hi all, First time posting so I hope this makes sense. I have a piece of work to do where I need to get various departments to check a spreadsheet of course start and end dates and a few othe...

microsoft forms

RobElliott

Silver Contributor

Mar 31, 2020

badongism Forms is not the best tool for this: unless you are using Forms Pro and CDS you can't pre-populate the form. And Forms doesn't have a feature to select course code and it then shows the course start date etc.

You would need to build an app in Power Apps to connect to the SharePoint list of courses for the user to amend as necessary.

Rob
Los Gallardos
Microsoft Power Automate Community Super User

andrev5

Brass Contributor

Feb 13, 2023

RobElliott what is CDS?

And what if our org uses a central database outside of SharePoint lists. Can the Power App be used to read from/pre-populate, then give the option to fill in/overwrite, that non-SharePoint database?

My org has a number of databases all linked internally so they can be queried as the data source within Power Apps, but I am not sure if Power Apps has the ability to write to those databases, or just read from it. Thanks!