Collection is retriving as a table

[Rabbanisyed]

How to retrive the Table information in to the gallery or in to a data table control.

my code for searching office365 users, in to a collection and from collection i wanted to search

when i look at the collection NAME is having a table icon when i click on table icon i getting the user information like

displaname ,email address etc that inforation has to populate in gallery. any help is appriciated

[WarrenBelz · Accepted solution]

Hi @Rabbanisyed ,

That is because you have NAME in the schema of your collection (it simply collects a Table in it as you have requested it to do) - you simply need

ClearCollect(
   searchM365users,
   Office365Users.SearchUserV2(
      {
         searchTerm: username.Text,
         top: 999
      }
   ).value
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Rabbanisyed]

Thanks, @WarrenBelz when i remove the NAME i get the blank information

how to retrive the input when a user search the username in the textbox in to the datat table?

[WarrenBelz]

@Rabbanisyed ,

Like this

ClearCollect(
    searchM365users,
    Office365Users.SearchUserV2({searchTerm: YourTextBox.Text}).value
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.