Forum Discussion
MS Lists vs Airtable
Hi, I could not find any discussion on Lists missing features or feature requests so far, so I thought I'd create one. I am an avid Airtable Pro user and privately I use it for everything fro...
Maybe it's gonna be a late reply but I want to add some points:
In my perspective, MS lists is the easiest , yet effective data source or database creation tool. But the power of MS lists is not lying on the MS lists itself. It's lying on the environment products like power BI, power Apps and Excel.
You can literally create a relational database just by loading your MS Lists into power query in either power BI, power Apps or Excel, and you can get full power of DAX and Power query.
If you need some data to be pulled to the MS Lists, just create a flow with power automate, and it will be done. (yet, excel is never a good data source for anything. not created to be a data source as well.)
In the bottom line, if you want to do something with the data in the MS lists, don't try it on MS lists itself. Just create, update or delete records in there, treat it as a professional database table or, if you are familiar with, like an MS Access table.
Then open an Excel sheet, hit the data > get external data> online services > Sharepoint list, enter the place you published your list, and boom. You will see the power query. Even if you know nothing about the power query, just hit the load and you will have the data.
Do whatever you want after that point. It will be synced with the list and your reports or graphs etc will be automatically updated with the changes in your lists.
Just an opinion...
Burak
In my perspective, MS lists is the easiest , yet effective data source or database creation tool. But the power of MS lists is not lying on the MS lists itself. It's lying on the environment products like power BI, power Apps and Excel.
You can literally create a relational database just by loading your MS Lists into power query in either power BI, power Apps or Excel, and you can get full power of DAX and Power query.
If you need some data to be pulled to the MS Lists, just create a flow with power automate, and it will be done. (yet, excel is never a good data source for anything. not created to be a data source as well.)
In the bottom line, if you want to do something with the data in the MS lists, don't try it on MS lists itself. Just create, update or delete records in there, treat it as a professional database table or, if you are familiar with, like an MS Access table.
Then open an Excel sheet, hit the data > get external data> online services > Sharepoint list, enter the place you published your list, and boom. You will see the power query. Even if you know nothing about the power query, just hit the load and you will have the data.
Do whatever you want after that point. It will be synced with the list and your reports or graphs etc will be automatically updated with the changes in your lists.
Just an opinion...
Burak