Compare Two Excel Tables - Update One

[lardo5150]

So I have a spreadsheet - SS1

It has two talbes.  Table 1 and 2.

Table 1 has a ton of columns.  But it has a Name Column that is important.

Table 2 has a Name column and a Manager Column.

Table 1 has a ton of data that gets updated.  The user's name can appear several times in the table as they may own several tickets.

I have added a column to Table 1 called Manager.

I want to compare the two tables.  If Name in Table 1 matches a name in Table 2, then it updates the Manager column in Table 1 with the Manager listed in Table 2.

[edgonzales · Accepted solution]

@lardo5150 

Hi there.  So, you don't really need to step outside of Excel to do this (if I understand the scope correctly).  Index/Match or Vlookup could probably do the same thing much quicker.

If you're wanting to use it as an exercise in Power Automate, then we can step through a couple of things, but I thought I'd check our options first.

-Ed

If you liked this reply, please give it a thumbs up! 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.

[lardo5150]

@edgonzales  this is my first attempt after I did some searching.

I am not sure what it was doing, but it started adding the manager to the column, but it was adding the wrong manager.

So I have SpreadSheet 1, with Table1 and table2

Table1 has like 400 lines.  It is a list of cases that my engineers own.  Engineers can be listed multiple times.

Table 2 is just a list of my engineers, and their manager name.

I am trying to grab each line from Table1, check if the Engineer matches an Engineer in Table 2, and then update Table 1 with that manager name.

[Anonymous]

I am trying to compare strings from an excel table to strings in a cds table. if they match I want to update the date.

varDFN is set to these values:

osp_name from the cds table outputs similar values, but not exact  - for example, they all have dfn_ in front of them. To remove 

the extra from the front I used the substring expression here: 

When I compose it it brings back values that match the values in my excel table. 

However... when I try to filter my table with this expression

I get an eror that tells me the value on the left of the equal sign must be from the same entity. I thought the point of setting variables was to be able to use them in whatever context works for the flow. 

Any ideas? If someone has the time I'd be glad to share a screen and talk it through. 

thank you!