cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

I need help in updating the Row of Excel through Power Automate. It's critical requirement

Hi,

 

I have the critical requirement of updating the row in the excel thorough.

 

The scenario is such that If I have two Columns A and B are there, then I have to combine them and then replace the resultant in Column B itlself.

 

It's an urgent requirement, Iam using my personnel one drive for this automation.

 

PFB the screenshot:

Screenshot.JPG

 

 

 

Please help me and reach out to me here or at "rohawasthi@gmail.com".

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: I need help in updating the Row of Excel through Power Automate. It's critical requirement

Hi @RohanAwasthi ,

 

You could refer to screenshot below to create the flow:

1.png

concat(outputs('Compose_2'),outputs('Compose'))

 

Please make sure you have a Key column in the table and the value in the key column would unique so we could identify the row for updating it.

You could save the 2 column data in 2 Compose actions , combine  it and update the column.

 

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

Re: I need help in updating the Row of Excel through Power Automate. It's critical requirement

Hi @RohanAwasthi ,

 

You could refer to screenshot below to create the flow:

1.png

concat(outputs('Compose_2'),outputs('Compose'))

 

Please make sure you have a Key column in the table and the value in the key column would unique so we could identify the row for updating it.

You could save the 2 column data in 2 Compose actions , combine  it and update the column.

 

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

Highlighted
Frequent Visitor

Re: I need help in updating the Row of Excel through Power Automate. It's critical requirementSir,

Hello   Sir,

 

My table is not having a unquie ID column in it. However I have tried to add it via "Add a key column to a table".

 

But it is simply adding the blank column in the excel table.

 

How to deal with it.

 

You can reach out to me in gmail : rohawasthi@gmail.com

Here Iam unable to attach the screenshot

 
Highlighted
Frequent Visitor

Re: I need help in updating the Row of Excel through Power Automate. It's critical requirementSir,

Hello   sir,

 

PFB the screenshot where I have created the "Add a key column to table":

 

Addakeycolumn.JPG

 

As a result of this I got the below column in the table, this is for one value:

 

ToSir.JPG

Please help how I can uniquely identify it.

 

I have to concat Pay category and Pay class and replace the result in Pay Class itself.

 

-Rohan

rohawasthi@gmail.com

 

Highlighted
Community Support
Community Support

Re: I need help in updating the Row of Excel through Power Automate. It's critical requirementSir,

Hi @RohanAwasthi ,

 

You need to add the key column by manually in your excel table not in flow.

 

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.

 

 

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 (5,598)