cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anubi
New Member

Searching a text in SharePoint and attachments

Hi all!

I'm quite new with PowerApps and SharePoint and i have a big question:

Is it possible to create a custom connector linked to a searchbox in an App in PowerApps that allows me to search a text into Sharepoint list and his attachments?

The results should be all the name of attachments or Sharepoint list field that are the same of the text insert into the searchbox.

Thanks all!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Anubi :

Do you want to search based on the content of the file in the attachment?

If so,I am afraid that we can only get the matedata of the attachment, and it is not available to retrieve the content of the attachment.

Best Regards,

Bof

View solution in original post

3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

Hi @Anubi :

Could you tell me:

Do you want to filter specific items based on the attachment name and fields?

If so,I suggest you in sert a flow in this app:

1\My data source

65.gif

2\Create a flow-PowerAppsbutton(This flow is used to find the items whoes attachment have the specific name)

1.JPG

Note:These two pictures have some overlaps2.JPG3.JPG

Please refer to the figure below for the structure of the flow:

5.JPG

3\Add this flow to the app

4\Add a textinput box control-SearchBox

5\Add a 'Search' icon and set it's OnSelelct property to

 

Set(TheID,Distinct(Split(PowerAppsbutton.Run(SearchBox.Text).theid,";"),Result))

 

6\Add a gallery and set it's Items property to

 

Filter(MySPList,Column1=SearchBox.Text || Column2=SearchBox.Text || Title=SearchBox.Text || Text(ID) in TheID.Result)

 

66.gif

Best Regards,

Bof

 

Hi @v-bofeng-msft!

First of all thank you for the reply and the guide!

Your answer is really close to the solution, but i want to search inside the attachments and not only the name of them.

For example, if i put 63 like you did, the number should be searched in the text inside the attachments.

The output is perfect, but in my case it should return all attachments where 63 is present as text inside.

Thanks a lot!

Hi @Anubi :

Do you want to search based on the content of the file in the attachment?

If so,I am afraid that we can only get the matedata of the attachment, and it is not available to retrieve the content of the attachment.

Best Regards,

Bof

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (62,853)