cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PennyP
Helper II
Helper II

Create Excel sheet and attach to approval

Hi,

I have created a flow which is activated when a form has been filled in. I would like it to create an excel spreadsheet with all the details in and attached to the approval email. I have tried many different scenarios but failing each time. 

 

Wondering if anyone knows that this can be done and what steps I would do.

 

Many Thanksflow.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @PennyP ,

 

Maybe you could use Add a row into a table instead of Update row action.

 

Please take a try.

 

Best Regards,

Community Support Team _ Barry
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

11 REPLIES 11
ChristianAbata
Super User
Super User

hi @PennyP  could you show me how is filled update row action in a screanshot please? I could help



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi Christian

Yes of course below are the screenshots after the flow failed. This is using the insert a row into an existing sheet. I want a new excel spreadsheet creating everytime the form is filled and then attached it to the approvals email if possible? Many Thanks 04.06.2020_15.49.50_REC.png04.06.2020_15.50.04_REC.png

@PennyP  oh this is because your  key value needs to be an ID and the same in Key column.. Could you show me that?



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi Christian

Screenshot below of my flow with key details. What should I put in for Key? Many Thanks

 

04.06.2020_16.43.44_REC.png

@PennyP  could you sahre and screanhot from your excel headers? you need and ID in that table.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbataMy apologies I misunderstood your request Excel screenshot below:

04.06.2020_17.02.52_REC.png

 

@PennyP  oh thats the problem my friend you need to add in excel a row as unique value like and ID, to update row.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbataoh right and use that as the Unique key. Thank you for your help I will give that a try now 🙂 

@ChristianAbataI now have a ID column in my excel. Still not got it right though as getting another error message can you help? Screen shots below:

 

04.06.2020_17.22.14_REC.png04.06.2020_17.22.22_REC.png04.06.2020_17.23.41_REC.png04.06.2020_17.24.54_REC.png

@PennyP  yes like this but consider that you have to compare IDs for example imagine that you are sending that form response. In some field you need to have and ID to know that your response has for example the number 1.

 

Then in your excel you need another field with that ID, so when you use Update row you compare, 1 ID FORM with 1 ID EXCEL then your flow is going to update your row. 

 

You need exactly Unique values to update a row, and normally are IDS



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
v-bacao-msft
Community Support
Community Support

 

Hi @PennyP ,

 

Maybe you could use Add a row into a table instead of Update row action.

 

Please take a try.

 

Best Regards,

Community Support Team _ Barry
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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,219)