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