Update/Delete Excel Data Using Power Automate  

Thanks Deepak, you showed me how to bulk update excel file based on conditions because of you. Thumbs up !

fantastic upload Deepak Shrivastava. I crushed that thumbs up on your video. Keep up the superb work.

Deepak, is there a way to use filter logic like what in Filter Query from "List rows present in a table" action to remove rows?

Excellent stuff Deepak , this is exactly I was searching, simple gold knowledge sharing. Keep it up. All the best

Hello Deepak, I only want to update a cell, for example cell A1 from 100 to 200. How do I do that?

Hi Deepak, If my excel file does not have a table, what should I enter in Table option.

Hi, I was just wondering - can you run scripts from PA in excels that are shared/may be open by another user?

Hi Deepak, can I update rows, use this logic but for multiple tables across different files, all of which are in a SharePoint Folder and are identically formatted?

Hi Deepak, The column values comes with space, suppose "Unique ID" instead of UID, how you can filter with this?? Contains('Unique ID' , 'Part1ABCD') will this work??

Hi Deepak, nice video. Thank you. However, for some reason when I tried to update multiple files using the items('Apply_to_each')?['RowName'], my excel just update the first row his find. could you please help me? thank you very much

How to filter the multiple string columns in excel using power automate

HI Deepak, Really a great session. you gave threshold value as 1000, what is the max I can provide??

Hello Deepak, I work for an engineering firm in Florida. I have this urging feeling that you work with this company also. Is there a way I can contact you about this. We are trying to automate the creation of tasks from our excel sheet and need help with it. How can I get a hold of you to discuss this? Thank you. Kevin with FLENG...

Excellent video! I would like to know how to update the all the columns of the file. Thanks

Could you show how to delete a column, Thanks

Hi Deepak, thanks for this very useful video. One question: I noticed that whenever I delete a row, the size of the table present in the excel file is also shortened. This is a problem for me because the size of the table should always remain 200 rows. Is it possible to resize the table and bring it back to 200 rows after deleting the rows? Or not delete the row but just clean up the contents? Thank you