iTranslated by AI
Creating Custom Lists in OneDrive for Business
When using Power Apps or Power Automate for personal projects, Excel files are the easiest data source to get started with. However, Excel files come with challenges such as delegation issues and errors when the file is open elsewhere, making them somewhat difficult to manage. Ideally, one would prefer to use SharePoint custom lists.
In that case, the question arises of where to create the custom list. While creating a new site is an option, it often feels wasteful to create an entire site just for one app. If you are using it for personal purposes, you likely want to keep everything within your own scope. Therefore, I wondered if it would be possible to create a custom list in OneDrive for Business. Since OneDrive for Business is based on personal SharePoint sites, it is, in itself, a SharePoint site. Custom lists can be created in the classic UI of OneDrive for Business or via CUI using tools like PowerShell.
With this background, I decided to change the data source for the password manager I previously created to a custom list.
When using Excel, I had to set the last modified date from Power Apps using Patch, but with SharePoint, the modified date is updated automatically, which is very convenient.
Discussion