Send a list of related items from list

[mismith]

I'm wondering if its possible to create a flow that suggests SharePoint list items that are already created?  Similar to when you create a post here it gives you suggestions to possible related posts to reduce the possibility of users from creating duplicate issues.

[yashag2255]

Hi @mismith 

Can you share more details? You can probably get a list of items by using the odata query and search the SP list where a column contains the value you pass. But if you are looking for something like while populating fields when adding the create item action in flow, I believe that is not doable with the current capabilities. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[efialttes]

Hi!

What's the columns structure of your list?

Just guessing... for example I have a SP list and each of its items is a task, one of the columns is the Title (single line of text), another column is called 'Tags (multichoice), so whenever I am about to create a new item, your suggestion is to have a PowerApps where I can select Tags first and see current tasks matching, so I can reuse one of the existing ones or create a new one... is this example similar to what you are looking for?

Hope this helps

[mismith]

I'm not necessarily looking to populate fields for me but more suggest another list item that has previously been added.  Currently I'm using flow to send an email to my team and the user that created the issue with pertinent information on what the issue is.  What I would like is to add a link or suggestion to a similar or related item in the list.

[efialttes]

Hi again!

---

Currently I'm using flow to send an email to my team and the user that created the issue with pertinent information on what the issue is.  What I would like is to add a link or suggestion to a similar or related item in the list.

---

So, which criteria do you want to use to suggest an already existing issue? Which Sharepoint item fields, which format do they have? Integer? Single line of text? Multichoice?

Shall your recommendation be based on matching integer values? matching multichoice values? searching for similar texts?

Hope this helps

[mismith]

Hi @efialttes -

I would like to use the Title field of the issue to achieve this.  The title field is a single line of text.  Is it possible to use flow to search for similar text? Hopefully this makes sense!

[efialttes]

Hi!
So you need a text similarity algorithm... as far as I know AI builder (license required) can provide sentiment analysis and text classification, but not heard about any 'text similarity' algorithm supported yet... not even a 'distance' algorithm to compare two short texts...
Same applies for azure text analytics API...
https://azure.microsoft.com/en-us/services/cognitive-services/text-analytics/?cdn=disable

let's hope somebody else can point us to the right direction
Hope this helps

[v-alzhan-msft · Accepted solution]

Hi @mismith ,

You could take a try to refer to screenshot below to create the flow:

The length expression in the Condition as below:

length(body('Get_items')?['value'])

Note:

User would enter the post subject when run the flow, the flow would check from the list to see if the post subject is existed in the Title field of any item in the list, if the post subject is existed in any items in the list, send the notification email, if not, send the post message and create the item in the list.

And if you want to send the related items, you could create html table for those items and send it in the email:

If you want to send the link of the related item, you would send multiple emails, each contains one link:

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CedrickB]

Hi Mismith,

I'm part of the AI Builder development team.

If I understand correctly your requirement you would like to suggest related post based on a new post title.

I see a possible option using Ai builder and Power Automate.

With AI Builder key phrase extraction, you can extract key phrases in a text. You could use this to extract tags which will be used afterward for indexing. You would build a flow that will batch process all existing text. And another one triggered when there is a new post, extracting tags and doing a search on already tagged items.

See https://docs.microsoft.com/en-us/ai-builder/prebuilt-key-phrase

You can activate an AI Builder trial to test this.

[mismith]

@v-alzhan-msft Thanks for the suggestion.  I had given this a try yesterday but wasn't successful.

[mismith]

@CedrickBThanks for the suggestion i will give this a whirl!

[mismith]

@CedrickBAre you able to connect with SharePoint Lists rather than yammer with the Key Phrase Extraction?  Is there a way to create a custom AI Builder or is this not available? 

[CedrickB]

I'm not sure to understand the question.

AI Builder is callable from Power Automate with the "Predict" action choosing "Key Phrase Extraction" model.

So you can take anything as source using the built-in Power Automate connectors and then send the result to Predict.

Does it answer your question?

[mismith]

@CedrickBThat does make some more sense.  Do you have any examples or screen shots you you share?  I'm learning this on my own and appreciate the help!

[CedrickB]

You can go to https://us.flow.microsoft.com/en-us/templates/, then search "Key Phrase".

You have 3 templates available to help you get started.

[v-alzhan-msft]

Hi @mismith ,

Would you please share a screenshot of the configuration of your flow?

And could you please share the run history of the flow and the error message?

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.