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!
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
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
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:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
User | Count |
---|---|
44 | |
18 | |
15 | |
14 | |
11 |
User | Count |
---|---|
81 | |
34 | |
29 | |
21 | |
20 |