Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : UYvZPs6drVBI7hQO28of96
Power Platform Community / Forums / Power Automate - Building Flows / Search ID with other t...
Power Automate - Building Flows
Unanswered

Search ID with other texts in an excel or sharepoint column

Like (1) ShareShare
ReportReport
Posted on 13 Mar 2025 15:11:06 by JC-04032021-0 12
Hi.
I have a column with random texts that contain IDs located in another Excel tab and I need to search these texts to find out if this ID exists and bring this ID in the 7 or 11 character pattern (I put the regex pattern in the file). This search needs to have good performance, since the original ID file has 60 thousand lines. There is no problem in converting to json, txt or any other format, as long as it solves the problem.
 
Please, can someone help?
 
 
 
Categories:
Business Process Flows
search1.xlsx
  • JC-04032021-0 Profile Picture
    JC-04032021-0 12 on 14 Mar 2025 at 15:04:34
    Search ID with other texts in an excel or sharepoint column
    I apologize for not sending enough details, but this need is certainly related to Power Automate. In the fifth record, for example, we have the text: "Formulário padrão aprovação SJOCO81_005.xls". This table currently has less than 5 thousand lines and grows 100 lines per month. And in this column with this text, we have the ID of a device registered in another table with approximately 60 thousand device IDs. The difficulty is to find the ID within this text (it can be in any position) and loop through 60 thousand lines to check if this ID exists in the table. Regarding the regex, it was only to explain the character pattern of these 60 thousand IDs. In short, the difficulty is to perform this search with the best efficiency.
  • Michael E. Gernaey Profile Picture
    Michael E. Gernaey 35,902 Super User 2025 Season 1 on 14 Mar 2025 at 03:58:11
    Search ID with other texts in an excel or sharepoint column
     
    I apologize, but I am unsure what you are asking about and how it relates to Power Platform. It seems you want to write a Script to search for things using RegEx.
     
    Can you please clarify, step by step what you need and if you need help with a Flow or App, can you please share what you have so we can help resolve your issue.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

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

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,382 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans