Unanswered

Searching a column in Excel

(0) Share

Report

Posted on by GJH

I need to search a column in Excel to determine if text exists in any cells. The excel sheet is made from running a script that compares data tables. When a compaison isn't found the scripts output excel sheet will contain the customers name rather than their customer number. When that happens I want the flow to present a comment and to stop (so the excel sheet can be editied) as the next step requires all customer numbers to be correct.

I know how to get the column from the output sheet into a data table (if that is what is necessary?) but can't get an action working that parses the table to look for text or get an If action to work.

Suggestions please

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GJH

I couldn't understand the requirements fully, but maybe this suits your purpose.

For searching use Find and replace cells in Excel worksheet

Prompt the user or ask the user for input with Display message or Display input dialog

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

VJR
Thank you. My problem is what to Find! The text could be any Customer name, in other words any combination of text characters. The consistent factor is that the cell or item in the list or table won’t be numeric. The need is if a non numeric item exists in the column (or list or table once converted) the flow Comment is triggered and and stopped so the user can replace the non numeric cell with the correct Customer number after looking it up. I hope this is a better explanation!

Was this reply helpful? Yes No