cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LeoApril
Frequent Visitor

Ms Form answer to specific cell in excel

  • Hi everyone

 

can I check with you all? I’m hoping to do something like this and I search through a bit but didn’t get any result. 

1. user filled ms form then input get approval from his boss 

2. boss approved

3. get filled detail and approval from ms form

4. Ms flow to search specific excel file in share point to update eg application form

5. use the answer in ms form to fill in certain cells in excel eg q1 answer to cell b10 then q2 answer to d10 and so on

6. Save the filled answer in application form (excel) to another folder with certain file name or self generate name also fine

 

what I’m trying to do is to get user to seek approval then use the filled detail in ms form to fill in the application form in excel. If this can’t be done, is there any idea which can replace this? 

thanks in advanced! 

1 REPLY 1
zmorek
Power Participant
Power Participant

I guess it can be done, though I always try to tell people to not use Excel as a DataSource whenever possible. You run into lockout issues and other oddities. Without knowing your exact data structure or use case:

 

1. user filled ms form then input get approval from his boss 

  • On form submission, get response details, initiate approval, save to DataSource as-needed

2. boss approved

  • Assuming you don't have to figure out who the "boss" is, add a condition for approved vs not-approved

3. get filled detail and approval from ms form

  • no change, you already have the detail (step 1, get response details) and the approval (step 2, outputs)

4. Ms flow to search specific excel file in share point to update eg application form

5. use the answer in ms form to fill in certain cells in excel eg q1 answer to cell b10 then q2 answer to d10 and so on

  • presumably you can do this without steps 2-4 above, your keycolumn will determine where the data goes
  • if you're just generating a file to be printed out, you can consider just building the file right in Power Automate

6. Save the filled answer in application form (excel) to another folder with certain file name or self generate name also fine

  • create item/get item/convert with OneDrive, or see above; Excel isn't best used for printing out data as a form, consider an alternative. You already have the data - do you need to save it permanently? Or are you just printing something out?

 

This seems like you're doing a Send form responses for approval,  then fill in responses into a template.

My best tip would be to avoid using Excel as a DataSource.. You're already saving the workbook on SharePoint, import it as a list. If your list is getting huge, move to CDS or SQL. This just sounds like an approved mail merge with more steps, so try and break it down into the parts that are important and decide where to store the data:

  1. User submits responses
  2. Boss reviews and decides approval status
  3. If approved, generate document with data
  4. If not approved, ???

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,199)