Unanswered

Get Unique Items from Sharepoint, filter and email

(0) Share

Report

Posted on by Prasad Venkat

Hello,

I have a requirement to get unique Column A items from sharepoint. This is then checked against an existing array B of strings. Any string in the array B that is not present in Column A is then collected and finally emailed.

Is there a way to do this in flow. I tried multiple variables to initialize and then sort through the different elements in the array. But it doesn't seem to work well for me. Any example is greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Harry_G 367 on at

Like (0)

Report

Re: Get Unique Items from Sharepoint, filter and email

Hi @prasadvenkat ,
Did you tried Send Http Request to SharePoint? I think you have to send REST call to Sharepoint Column A Items. Take One item from Column B and send request to get data from A If Data not Matched, Send Email.
Example rest call is.
https://yourDomain/sites/sitename/_api/Web/Lists('guid of list')/Items?$Select=ColumnA$Filter=Column A eq 'Column B Item'

Thanks,
Harry_G

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Re: Get Unique Items from Sharepoint, filter and email

Hi @prasadvenkat ,

Could you please share more explanations and details about your needs?

I am afraid it is difficult to build the Flow you expect based on your description because I am a bit confused about the scene you describe.

Please provide more details.

Best Regards,

Was this reply helpful? Yes No