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)


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 • • 2h ago

Question Importing list with users no longer in company

Thumbnail reddit.com
1 Upvotes

r/MicrosoftFlow • • 6h ago

Question Issue with flow potentially after recent Microsoft Outage

Thumbnail reddit.com
1 Upvotes

RESOLVED - See comment thread on original post

Looking for some feedback if you have a moment. Thank you!


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!