cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Community Support
Community Support

Re: Create Excel sheet and attach to approval

 

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
Highlighted
Super User III
Super User III

Re: Create Excel sheet and attach to approval

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
Highlighted
Helper I
Helper I

Re: Create Excel sheet and attach to approval

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

Highlighted
Super User III
Super User III

Re: Create Excel sheet and attach to approval

@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
Highlighted
Helper I
Helper I

Re: Create Excel sheet and attach to approval

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

Highlighted
Super User III
Super User III

Re: Create Excel sheet and attach to approval

@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
Highlighted
Helper I
Helper I

Re: Create Excel sheet and attach to approval

@ChristianAbataMy apologies I misunderstood your request Excel screenshot below:

04.06.2020_17.02.52_REC.png

 

Highlighted
Super User III
Super User III

Re: Create Excel sheet and attach to approval

@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
Highlighted
Helper I
Helper I

Re: Create Excel sheet and attach to approval

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

Highlighted
Helper I
Helper I

Re: Create Excel sheet and attach to approval

@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

Highlighted
Super User III
Super User III

Re: Create Excel sheet and attach to approval

@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
Highlighted
Community Support
Community Support

Re: Create Excel sheet and attach to approval

 

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
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (7,364)