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

Create a Form based on Excel Sheet data and Update Excel Sheet based on Forms response

Dear All,

I am trying to create a Flow which does the following

  1. Access an Excel Sheet (Lets call it Excel 1).
  2. Get Resource Name from the Excel 1.
  3. Update MS forms with Resource Name and ask user to provide domain for each Resource Name.
  4. Once the response is submitted an Excel sheet (Call it Excel 2) gets updated with Resource Name(from Forms), Domain (from Forms), Hours (from Excel 1).

I have illustrated this in the attached picture. Any guidance on how to achieve this would be great. 

 

Thanks

ShahFlow_Ques_1.JPG

1 REPLY 1
fchopo
Super User
Super User

Hello @AShah16 

Unfortunately you can't create Forms with dynamic fields. You can vote here for Microsof Graph API integration with Forms: Microsoft graph API integration with Form – Customer Feedback for Microsoft Forms (uservoice.com)

Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,813)