Update specific columns depending on a list in excel

[AndresVilla]

Hello, 

I'm trying to update specific columns on a row depending on a list that I got from another table column. I know it sounds weird but is part of a bigger system. The problem is, I cant specify when a column gets updated or not, I got all the data from the second table but cant apply it to the first one. Any help?

[abm]

Hi @AndresVilla 

Have you got any common identifier in both source and target systems? To update a specific column in Excel you need to filter that row using the source data. Once the row is identified then you can do the update row action step from Excel connector.

Thanks

[AndresVilla]

The only common identifier is the name, as the name of the columns and the name of the data inside of the other table is the same. All of this is to make a table that has certain columns "active" depending on a Microsoft Forms trigger, then it will gather the names of a column that is set through Microsoft Forms and check and change the information in the first table

[abm]

Hi @AndresVilla 

So you could use the Filter Query by name for the relevant Excel Rows. There are lots of articles about how to filter Excel Sheet. If you need further help on this please let me know.

https://www.youtube.com/watch?v=NsGOUJfZO7o

Thanks

Thanks