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

Flow using excel for business

Hey guys has anyone ever built a flow using excel for business

I am trying to create an action with the option “update a row” but I don’t understand what to put in the field “key value”.

Thank you in advance!

Isabella
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @IsabellaChakur 

 

You should use the insert a row action instead of the Update a row action to insert a new row to an excel table.

Have your problem be solved now? If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Or if your problem haven't been solved, please share more details about your problem so we could provide a proper workaround for you.

 

Best regards,

Alice       

 

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

4 REPLIES 4
Highlighted
Super User II
Super User II

@IsabellaChakur 

Hi there!  So, when you want Flow to "Update a row", it needs to know which specific row to update.  Because of that, you need to identify which column will have the key in it, and then what unique value it should look for.

 

Does that help?

 

-Ed-

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Highlighted

Thank you for your answer! I undersand that but actually I don't know what to put as a key. Do I have to name a row in my table?



Indeed, what I really need is to insert the data from the survey (which is the trigger) in the table. I have also tried the option "insert a row in a table" but the flow didn't work because "it would move cells in a table on your worksheet". Have you ever performed something similar?



Thank you in advance!!

Isabella

Highlighted

Ah, ok...that helps.

You definitely want to use the Insert option.  The Update action is to make changes to a row that is already in the table.

 

I have used both of these fairly often.  Can you tell me more about this part, "it would move cells in a table on your worksheet"? 

 

Inserting a row should add it to the end of your table, but if you've got stuff downstream referencing specific fields, we should plan a different path somewhere. 

 

Let us know.

-Ed-

 

Highlighted
Community Support
Community Support

Hi @IsabellaChakur 

 

You should use the insert a row action instead of the Update a row action to insert a new row to an excel table.

Have your problem be solved now? If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Or if your problem haven't been solved, please share more details about your problem so we could provide a proper workaround for you.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

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.

Top Solution Authors
Top Kudoed Authors
Users online (8,737)