Unanswered

Help pulling SharePoint list items, then filter on items that have been logged within the past 24 hours, then remove duplicate rows that have same Ref number

(0) Share

Report

Posted on by snipesnab

Hi There,

I have a Hardware ordering app that logs new orders into a SharePoint list called 'Hardware Orders'. Each order may have multiple rows in the list, and these wwill have a duplicate value in the 'PO_Number' column.

On a daily basis I would like to email a feedback form link to users who have used the app over the past 24 hours.

The plan is to get Flow to run through the rows in my SharePoint list, identify all the rows that have been added within the last 24 hours. The Flow would need to remove rows that have duplicate PO numbers (column 'PO_Number), and also duplicate email addresses of the column 'Submitter_Email'. This should leave a list of unique emails that I can use to send off the feedback link to via email.

Please can someone assist in how to run these filter queries in Flow, as I have never done this before. So far I have the 'SharePoint List - Get Items', I think I need to configure the the 'Filter query' but not sure how to get it right.

Any help much appreciated!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@snipesnab

Can you tell me what needs to be in the actual email? Do you need data from each of the rows associated with a PO?

Was this reply helpful? Yes No
snipesnab 69 on at

Like (0)

Report
Copy link

Link copied!

I just need to send a static link to a forms survey to all the unique email addresses as a result of the list query

Was this reply helpful? Yes No
snipesnab 69 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer - Are you able to assist with this, its got me stumped 🙂

Was this reply helpful? Yes No
ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@snipesnab

Sure. The key to the solution is this:

Use a SharePoint Get items action with a filter query that looks something like this:

Created ge 'addDays(utcNow(), -1,'yyyy-MM-dd')'

Create any array from the output that contains only the email addresses

Use the union expression and supply the array for both parameters - this will generate values

Here is an example

Loop through the unique values and send the email

I will provide an example Flow later today.

Was this reply helpful? Yes No