web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to search and retr...
Power Apps
Answered

How to search and retrieve information of the object detected by AI builder from several tables ?

(0) ShareShare
ReportReport
Posted on by 27

Hi,

Now I know that we can use the formula to retrieve the information of the detected object from one table :

 

LookUp(tablename,name=First(ObjectDetector1.Results).TagName) 

 

I wanna ask if I have different types of objects I hope to detect that are saved in different tables, can I LookUp more than one table here in this one formula? I'm really new here, thanks. How to retrieve the information of the object that is detected by AI Builder via the detected object name 

Categories:
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Puco ,

     

    Firstly, Object Detector is a control. It has a property called ModelId.

    When creating a model, a model ID will be generated.

    So, we can put a class of things in a table and generate a model from this table.

    If we have another class of things, we can create another model.

     

    Because this is a broad question. I did a simple test.

    1\ Create a dropdown control and set its Items property to:

    ["*****","******"] // Each model has its own ID, which is automatically generated

     

    2\ Set the ModelId property of Object Detector control to:

    Dropdown1.Selected.Value // Dropdown1 is the name of my dropdown control

     

    If you select the first item in the drop-down list, it will only recognize the data in the first model.

    If you select the second item from the drop-down list, it will only recognize the data in the second model

    In addition, each model corresponds to a table.

     

    You could set the Items property of gallery control like this(Take two tables as an example):

    If(Dropdown1.Selected.Value="***" , LookUp(your first Table,String=First(ObjectDetector1.Results).TagName),Dropdown1.Selected.Value="***",LookUp(your second Table,String=First(ObjectDetector1.Results).TagName))

     

    Best Regards,

    Wearsky

    If my post helps, then please consider Accept it as the solution to help others. Thanks.

  • Puco Profile Picture
    27 on at

    thanks @v-xiaochen-msft I finally tried out, it's really helpful~

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#2
11manish Profile Picture

11manish 205 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard