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

Twitter search to Onedrive Excel - What am I doing wrong?

Hi, I give up and hope someone can explain what I'm doing wrong.  I want when someone tweets or retweets my hashtag for tweet information I selected to create a new row on my excel sheet.  Here is what I have so for and thanks in advice for any help.

 

twitter to excel.png

 

 

twitter to excel failed.pngUpdate

I'm not getting

twitter to excel failed 2.png

4 ACCEPTED SOLUTIONS

Accepted Solutions
ChristianAbata
Super User
Super User

hi @kimber  its because you need to create inside excel a table with headers and then try to add row into excel and your are going to see fields with your table previusly create.

this.PNG



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

View solution in original post

efialttes
Super User
Super User

Hi!

The current problem is, 'Add a row into a table' is referencing a table that does not exist yet in your Excel File.

https://support.office.com/en-us/article/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e49...

 

So either you reference an already existing table in your Excel file -in such case, you can select it from the drop down menu- or, you create a new one. Excel connector currently offers the option to Create a table by means of an specific action block

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

@kimber  it's because you are using create worksheet action and you need to add add rows into a table action.

 

Just an advice try to open a new topic to help you because this is mark already as solved.

 



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

View solution in original post

@ChristianAbata   I could just hug you right now.  Thank so much for all the help

View solution in original post

8 REPLIES 8
ChristianAbata
Super User
Super User

hi @kimber  its because you need to create inside excel a table with headers and then try to add row into excel and your are going to see fields with your table previusly create.

this.PNG



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

View solution in original post

efialttes
Super User
Super User

Hi!

The current problem is, 'Add a row into a table' is referencing a table that does not exist yet in your Excel File.

https://support.office.com/en-us/article/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e49...

 

So either you reference an already existing table in your Excel file -in such case, you can select it from the drop down menu- or, you create a new one. Excel connector currently offers the option to Create a table by means of an specific action block

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Thanks, everyone for the help but I give up. This is too much work to simply track a hashtag, I'll try another next week. 

 

Have a great weekend

Kim

@ChristianAbata  Who do you know what to put in the column header?  I assume it needs to match what the column will be listing. Such as fullname or followercount.

 

Thanks

hi @kimber  its not necessary just add a columns name to regcongnice in your flow, where do you need to insert you twitter data.



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

@ChristianAbata   I have no idea why this is not working. This is what I have and thank you so much for the help. 

 

Flow.pngspreadsheet.png

 

@kimber  it's because you are using create worksheet action and you need to add add rows into a table action.

 

Just an advice try to open a new topic to help you because this is mark already as solved.

 



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

View solution in original post

@ChristianAbata   I could just hug you right now.  Thank so much for all the help

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.

Users online (2,032)