Forum Discussion
How to Organize Data
I am moving to sharepoint to manage my legal client case load. Currently I have an MS database where I store client data. From what I have read, a hub and spoke organization would be appropriate fo...
Thanks for your reply Rob. As I said, I am coming from the MS Access and still haveing trouble getting my head around this different approach and structure in PowerApps. So in MS Access, I can query all my clients all the live long day: how many clients do I have over the age of 50, how many are waiting for hearing, etc. If I have this sharepoint structure where I essentially have a spoke site for each client, and each client spoke site has the same "template" list structure, how do I query my entire case load?
Okey, Here's a super short verison on how to do it with basicly links,
if you need me to go into more details or step by step ping me.:
1.First create a site template of how you want your site too look like:
https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/get-started-create-site-design
2. Create a list where each new client will be inputed, add all your fields here + URL field with the site Path
3. Create a Power automate Flow which trigger when a new item is created in that list :
https://ganeshsanapblogs.wordpress.com/2022/10/29/create-a-sharepoint-online-site-using-power-automate-flow/
4. Apply site template using power automate:
https://365corner.pl/2021/10/14/how-to-apply-site-template-via-power-automate/
https://cloudkumpel.de/2023/02/11/powerautomate-create-sharepoint-site-collection.html
5. Update that list item with the link to the site.
if you need me to go into more details or step by step ping me.:
1.First create a site template of how you want your site too look like:
https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/get-started-create-site-design
2. Create a list where each new client will be inputed, add all your fields here + URL field with the site Path
3. Create a Power automate Flow which trigger when a new item is created in that list :
https://ganeshsanapblogs.wordpress.com/2022/10/29/create-a-sharepoint-online-site-using-power-automate-flow/
4. Apply site template using power automate:
https://365corner.pl/2021/10/14/how-to-apply-site-template-via-power-automate/
https://cloudkumpel.de/2023/02/11/powerautomate-create-sharepoint-site-collection.html
5. Update that list item with the link to the site.