cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
evcarey
New Member

How Do I Insert a Row into a table that does not yet exist

I have been able to successfully create a worksheet and create a table, however after the creation, I would like to input data from a Microsoft Form into a row (Add a row into a table) due to the table name not being able to be selected (it hasn’t been created until execution), I have used the Select Operation – This keeps coming up as an error.

Can you please assist? Screen Shots are attached.

Screen Shot 2021-12-15 at 9.45.17 am.pngScreen Shot 2021-12-15 at 9.45.32 am.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @evcarey :

Just provide the value in JSON Format.

vbofengmsft_0-1639722130801.png

I think this link will help you a lot:

https://powerusers.microsoft.com/t5/Building-Flows/Updating-an-excel-sheet-which-is-a-subject-of-my-...

In addition,the 'From' property of the "Select" action seems like a string value instead of an array:

vbofengmsft_1-1639722220615.png

Best Regards,

Bof

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @evcarey :

Just provide the value in JSON Format.

vbofengmsft_0-1639722130801.png

I think this link will help you a lot:

https://powerusers.microsoft.com/t5/Building-Flows/Updating-an-excel-sheet-which-is-a-subject-of-my-...

In addition,the 'From' property of the "Select" action seems like a string value instead of an array:

vbofengmsft_1-1639722220615.png

Best Regards,

Bof

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,170)