Unanswered

How to flag rows containing certain strings.

(1) Share

Report

Posted on by Soraumi810

I would like to perform automatic sorting on a large amount of data that is created automatically.
The only way I can think of to sort it out is to add many control functions, but if you have any good ideas for a solution, please let me know.
The policy of my team prohibits the use of power automate for desktop. I would like to use the cloud version.

If column A contains the letter “ABC” and column C contains the letter “123”, then put the number “1” in column E,
Put the number “2” in column E if column A contains the letters “ABC” and column C contains the letters “124”,
If column A contains the letter “DEF” and column C contains the letter “123”, insert the number “3” in column E.
If column A contains the letter “DAF” and column C contains the letter “223”, insert the number “4” in column E. ・・・・ etc.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @Soraumi810 ,

If your data source is a excel table , you could use excel function to achieve your needs.

=IF( AND(ISNUMBER(SEARCH("ABC",A1)),ISNUMBER(SEARCH("123",C1))), 1, IF( AND(ISNUMBER(SEARCH("ABC",A1)),ISNUMBER(SEARCH("124",C1))), 2, IF( AND(ISNUMBER(SEARCH("DEF",A1)),ISNUMBER(SEARCH("123",C1))), 3, IF( AND(ISNUMBER(SEARCH("DAF",A1)),ISNUMBER(SEARCH("223",C1))), 4, 0 ) ) ) )

Best Regards,

Bof

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (0)

Report

Hi

Use these steps -

Trigger: When a file is created or modified (properties only)



   Action: List rows present in a table

Action: Apply to each (value)

   Condition: If Column A contains "ABC" and Column C contains "123"

   Action: Update a row (set Column E to "1")

   Condition: If Column A contains "ABC" and Column C contains "124"

Action: Update a row (set Column E to "2")

Condition: If Column A contains "DEF" and Column C contains "123"

Action: Update a row (set Column E to "3")

   Condition: If Column A contains "DAF" and Column C contains "223"

   Action: Update a row (set Column E to "4")

Mark as solution if it helps.

Thanks,

Sandeep Mishra

@Soraumi810

Was this reply helpful? Yes No