Thank you to Alice Keeler (@alicekeeler) for sharing a list of resources collected at Chawanakee Academy.
This app was made as a personal design challenge to view and search content in a spreadsheet more easily. Run with it and try applying its principles to another spreadsheet you have.
Scenario: you want employees to contribute to a knowledge base with links to resources that would be helpful to others.
Setup
- From the ribbon, click View > Datasources
- Click the ellipsis and remove the existing tables. This is so you can add your own connection to a spreadsheet.
- Click + Add Datasource
- If you have not already connected Google Sheets as a connection to PowerApps, click + Add Connection, otherwise skip steps 4-5.
- (Continuing from + Add Connection) Select Google Sheets. You'll be prompted to sign into Google Sheets and asked to allow permissions.
- Once Google Sheets is a connection, select it from the list of available datasources.
- You'll see a list of all spreadsheets available on your Google Drive. Browse for the 'Resources for Chawanakee Academy (Responses)'.
- You'll see a list of all the workbooks from the spreadsheet. Select 'Form Responses 1'.
- Remove this screen when you're done setting up.
Note: The app in its current form is set to communicate with a spreadsheet called 'Form Responses 1' and its columns.
If you decide you want to use this same app for another spreadsheet, you will need to tinker with all instances that reference 'Form Responses 1' and any of its columns.
You can break the connection to 'Form Responses 1' and use the App Checker to see what you need to repair (see the stethoscope icon at the top right corner). It will pull up a pane that shows each location that needs to be fixed.
.png){kind=link}