Recap
This is a follow on from my previous post, ‘Using Microsoft Flow to update a Teams group with SharePoint activity‘. Flow is also known as Power Automate, and it is a Microsoft method for connecting apps so that outputs from one app can become inputs to another app, and events that happen in one app can trigger procedures in another app.
In my previous post, I added Flow to a Microsoft Teams group, and set up conditional testing to post a message in one of two Teams channels, depending on the value chosen in a metadata column when a file was uploaded to a SharePoint library belonging to the Team.
The Plan
The next steps to improve on this Flow will be:
- Changing the SharePoint column name to ‘Relevance’ and the option labels, Teams channel names and Flow conditions to say ‘Urgent’ and ‘FYI’ rather than ‘Yesterday’ and ‘Never’. This morphed into the far more complicated problem of waiting for the SharePoint column value to change before continuing the Flow.
Jump to this section. - In the message that’s posted to Teams, change the text displaying the uploaded file’s URL to a working link to the file.
Jump to this section. - Post the message in Teams using the name of the person who uploaded the file to SharePoint.
Jump to this section. - Another thing I would like to do is to add the updates as cards in ‘To Do’ columns in the Teams group Trello board.
Jump to this section. - Summary: Bringing the last few things together. Jump to summary section
- Jump to links