cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Joule
New Member

Work Flow Management

Hi Team,

 

I have a spreadsheet which contains 100 invoices in Column A. These invoices were allocated to 10 users. 

 

I have created a common Survey for all these 100 invoices in MS Forms. Hence all the 10 users will update that survey form.

 

Once it is done I will get the Response from the MS Form and would check whether I got response for all 100 invoices.

 

This is my daily task. Can anyone assist me to do a automation on this.

 

Thank You.

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @Joule ,

 

You could create two flows to achieve the requirement.

The first flow: when a new response is created from the form, create a new item in a new sharepoint list.

The second flow:when an item is created in the sharepoint library, count the length of the records and check if it is equal to 100, if yes, send you an email.

 

Best regards,
Alice       
 
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
v-alzhan-msft
Community Support
Community Support

Hi @Joule ,

 

You could create two flows to achieve the requirement.

The first flow: when a new response is created from the form, create a new item in a new sharepoint list.

The second flow:when an item is created in the sharepoint library, count the length of the records and check if it is equal to 100, if yes, send you an email.

 

Best regards,
Alice       
 
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,644)