cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
owenfw
Regular Visitor

Solicit monthly feedback from all users in a team on Teams

Power automate newb here. I've successfully learned how to post an adaptive card to a team to solicit information that I then append to an Excel spreadsheet. My use case for that is reminding myself to record a weekly update of progress on a project to create a running project history. However, it would also be great to be able to do something similar that allows everyone on a team to enter updates for their projects. Imagine a team that is just for supervisors and each of them needs to report on x number of their projects to the manager each month.

 

But first, let's keep it simple: Let's imagine there is one team that all supervisors belong to. Each month (I already know how to schedule the recurrence), I want a message to automatically post to the team chat that asks for each supervisor's monthly update to be entered. By responding to that message (I'm assuming this will be an adaptive card with an input field), their update posts to a single spreadsheet table so the manager can see everyone's project reports in the same table. Ideally, the solution would not require knowing the team members in advance, since they might change (so no hard-coded email addresses). Also, while I think it's OK if everything goes to the same table every month, it would be amazing a new sheet in the workbook could be created for each month. 

 

Any hints about how to approach any part of this would be greatly appreciated!

0 REPLIES 0

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (3,554)