👨‍💻Dev Ops - Add a workflow to sync changes from the Developer Sharepoint List to the Production Sharepoint list during merge

[Calinator444]

Description

As per my conversation with @JeanThirion there should be a workflow in place to ensure that changes made to the sharepoint list used for the developer environment are carried over after changes are merged with the main branch.

Tip

I suspect that it may be possible to sync the Sharepoint list for the developer environment with the SharePoint list used in production via a Power Automate workflow but I haven't looked into it.

Important Note

The SharePoint list used for the developer environment should also be updated whenever the list used in prod is updated.

- [ ] Investigate if Sharepoint lists can be exported
- [ ] Investigate whether Sharepoint lists can be imported (and whether they would include new columns when imported)
- [ ] add a Power Automate workflow (or other) to sync the dev and prod Events Sharepoint lists after a merge

[JeanThirion]

Hey Caleb,

Dev: https://sswcom.sharepoint.com/sites/Events/_layouts/15/listedit.aspx?List=%7Bdbb5993f-fa85-49bd-8cc6-0197b23db3fd%7D Prod: https://sswcom.sharepoint.com/sites/Events/_layouts/15/listedit.aspx?List=%7B5502E86D%2DAD16%2D4EB4%2DA41C%2DAC33C9A08382%7Dhttps://sswcom.sharepoint.com/sites/Events/_layouts/15/listedit.aspx?List=%7B5502E86D-AD16-4EB4-A41C-AC33C9A08382%7D

Thinking this through, I think the process when adding a new column to this list (or any SharePoint list that has multiple environments, i.e. Dev/Test/Prod) should be :

1. Create the column as a “Site Column” (https://learn.microsoft.com/en-us/microsoft-365/community/what-is-site-column)
2. Add the created to the Dev List, using List Settings | Columns | Add from existing Site Columns | {{Custom_Column}}, then test your code
3. If working, add the column to the Prod list, using List Settings | Columns | Add from existing Site Columns | {{Custom_Column}}

To be fair, we should go even a step further an use “Content Types” (which are a collection of Site Columns defining a data type). Anyway, for Events, I think you should delete the custom column you created, created it again as a site column instead and follow the above steps. Tips: When creating a site column, you should always use a the format {{prefix}}_{{columnname}}. Here I’d use SSW{{Column_name}}.

1. Read about Site Columns and Site Contents
2. Check if we have SSW Rules / SugarLearning items about it (work with Josh)
3. I suspect we don’t really – create a SugarLearning item that points to the best video you can find about Columns and Content Types (two super important concepts)
4. Fix /sites/Events according to the above
5. Add a link somewhere in the Website project readme “To add new column to the /events/ list, follow XXXX”
6. Add Checked by Josh, then me

Cheers,

Jean Thirion | SSW France CEO + Solution Architecthttp://www.ssw.com.au/People/Jean-Thirion?utm_source=emailsignature | +61 402 924 179https://www.ssw.com.au/ssw/Company/Offices/?utm_source=emailsignature | Ping me on @.***>

From: Caleb Williams [SSW] @.> Sent: Thursday, May 9, 2024 9:57 PM To: SSWConsulting/SSW.Website @.> Cc: Jean Thirion [SSW] @.>; Mention @.> Subject: [SSWConsulting/SSW.Website] 👨‍💻Dev Ops - Add a workflow to sync changes from the Developer Sharepoint List to the Production Sharepoint list during merge (Issue #2611)

Description

As per my conversation with @JeanThirionhttps://github.com/JeanThirion there should be a workflow in place to ensure that changes made to the sharepoint listhttps://sswcom.sharepoint.com/sites/Events/Lists/EventsDev/AllItems.aspx?env=WebViewList used for the developer environment are carried over after changes are merged with the main branch.

Tip

I suspect that it may be possible to sync the Sharepoint list for the developer environment with the sharepoint list used in production via a power automate workflow but I haven't looked into it.

Important Note

The sharepoint list used for the developer environment should also be updated whenever the list used in prod is updated.

• [ ] Investigate if Sharepoint lists can be exported

• [ ] Investigate whether Sharepoint lists can be imported (and whether they would include new columns when imported)

• [ ] add a Power Automate workflow (or other) to sync the dev and prod Events Sharepoint lists after a merge

— Reply to this email directly, view it on GitHubhttps://github.com/SSWConsulting/SSW.Website/issues/2611, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AH7TA737QHVK3VSVCNN4XC3ZBNQA5AVCNFSM6AAAAABHOV3WWCVHI2DSMVQWIX3LMV43ASLTON2WKOZSGI4DONJTGU2TIMI. You are receiving this because you were mentioned.Message ID: @.**@.>>