Power Automate Desktop- How to apply VLookup formula on a column only for the filtered cells

(0) Share

Report

Posted on by Ganesh_naga

Hi Team,

I have a scenario in Power Automate Desktop, like

Step-1 Launch Excel,

Step-2 Filter Blank Records on Column C,

Step-3 Apply VLookup() formula on the column C for only on the filtered cells (Value of blank cells in column C are pulling from Other Excel Sheet of columns A in the same Excel workbook)

Step-4 Mark only those cells in Yellow Color

Sample formula I need to use in my scenario for filtered Blank cells - " =VLOOKUP(A414, 'StaticData' !A:C, 3, 0)"

Can someone help me how to achieve Step-3 and Step-4 will be a great help to implement in multiple steps.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (3)

Sort by

Verified answer

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have written a detailed blog on the same.Please have look.

Link : https://community.powerplatform.com/blogs/post/?postid=7be68540-4cb8-ef11-b8e8-7c1e52182eb9

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Ganesh_naga 56 on at

Like (0)

Report
Copy link

Link copied!

Hi Vishnu,

Thanks for the post its helpful, I have applied same steps, but for passing formula to only filtered rows how to achieve this? "Get First free row" action is returning total rows count.

In my case I have 7000 rows, and I need to apply VLookUp formula on only rows that are filtered (example 35 rows with random row number).

Can you assist how to achieve this.

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

There is no way you can directly apply Vlookup formual to visble cells after filtering. But you can follow this alternative. Copy the Filtered excel data to another sheet or another excel and then apply the vlookup and then rewrite that data to the excel.

Regards,

Vishnu Reddy

Was this reply helpful? Yes No
Ganesh_naga 56 on at

Like (0)

Report
Copy link

Link copied!

Hi Vishnu,

Thanks for sharing the alternative workaround.

Can you help with the steps for the second part "then rewrite that data to the excel" How I can copy Sheet B to replace with existing values in Sheet A again.

Great help if you can suggest with steps.

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Take the Unique part or column between 2 different sheets and then try to use below methods.

1. Again apply vlookup methods like this formula : "=VLOOKUP(A2,Sheet2!A:I,2,0)"

2. Use can used Find and Replace in excel sheet action and try to find the row index of that part number and write the required data in the cell.

Actually without excel i can able to write the exact data.

Regards,

Vishnu Reddy

Was this reply helpful? Yes No
Verified answer

Ganesh_naga 56 on at

Like (0)

Report
Copy link

Link copied!

Hi Vishnu,

I tried to apply formula like you mentioned in the blog. can you help in correcting this error? The same working as expected in Excel but when I paste, getting this error.

Was this reply helpful? Yes No
Verified answer

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Ganesh,

You trying to build your solution Power Fx enabled flow. Please disable the Power FX as shown in below image and try to build the flow it will work.

regards,

vishnu reddy

Was this reply helpful? Yes No