r/MicrosoftFlow • • 6h ago

Discussion Subconsultant guests in Teams: why a private channel won't keep them out of your other projects, and what does

0 Upvotes

Hit this again on a job last month, so writing it up.

Structural or MEP sub needs the current drawing set. Someone adds them as a guest to the team that already exists, spins up a private channel for drawings, and assumes that's the wall. It isn't.

Guests can only join a private channel once they're members of the parent team. And every team member can open every standard channel. So if that team holds three other projects, your sub can read all of them.

What's worked for us:

  1. One team per project. Subs go in as guests, drawings live in a standard channel everyone on that team is allowed to see. Private channels are for things like your own staff discussing fees.
  2. Same sub across lots of jobs, and their IT admin can configure Entra B2B direct connect? Then a shared channel gets them in without joining the parent team at all. Both tenants have to set it up. An existing guest account doesn't count.
  3. Before live drawings go in, have one external person sign in with their own account and open the exact file. Then have a colleague from another project try the same file and confirm they're refused. Write both results down.
  4. Closeout is a separate job. Removing someone from the team or shared channel doesn't remove access granted directly to a file or folder through SharePoint. Go find those direct grants.

Smaller gotchas:

- Private channel site permissions can't be managed separately in SharePoint. Change membership in Teams.
- Microsoft's own pages disagree on scheduled meetings in private channels. Test in your tenant before relying on them.

Until the tests pass, the PM sends the current revision through your normal access-controlled route and logs it in the transmittal register. Never an Anyone link. It works for whoever holds it.

Full write-up with the exact steps:
Read the write-up!
View Our Offerings!


r/MicrosoftFlow • • 8h ago

Discussion What B2B workflow automation stack are you building for 2027.

Post image
0 Upvotes

A lot of agency owners are already locking in their 2027 operations. Most teams are still wasting hours on manual data entry and lead generation. We are seeing a massive push to fix this before the new year.

At our agency we are moving clients away from scattered Zapier setups and building centralized systems. We are focusing heavily on custom API integrations, smart error handling, and automated web scraping to feed CRMs directly. Buyers are already searching for reliable workflow automation to scale next year instead of just playing whack a mole with broken flows.

What specific operational bottleneck are you trying to eliminate before 2027 hits? Are you looking into n8n Power Automate or custom Python setups?


r/MicrosoftFlow • • 10h ago

Question Delete Emails from copier after a period of time

4 Upvotes

Hey, I'm trying to create a flow with the basic power automate to delete outlook emails from the copier that are older than say 3 months and for it to trigger once a week or so, I have a rule in my email to send it to its own folder named copier and from what I can tell Outlook dosent have a built in rule for deletion like this.


r/MicrosoftFlow • • 22h ago

Question Moving from Excel to SharePoint lists

19 Upvotes

There are a few different Excels at my company that get refreshed weekly and then a team adds their comments throughout the week regarding any process they are making on the item. I was thinking about moving this to a SharePoint list with different views and probably a power app to make input more user friendly. What will be my downfall when moving from a new Excel sheet every week with a lookup for the comments for the previous week, to one continuous SharePoint list?

(Moving it to the SharePoint list will make it easier to automate part of the processes)