Skip to main content

Notifications

Power Automate - General Discussion
Answered

How to flag rows containing certain strings.

(1) ShareShare
ReportReport
Posted on by

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.

  • sandeepstw Profile Picture
    sandeepstw 233 on at
    Re: How to flag rows containing certain strings.

    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

  • Verified answer
    Re: How to flag rows containing certain strings.

    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
     )
     )
     )
    )

    vbofengmsft_0-1716255561514.png

     

    Best Regards,

    Bof

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard