Issues with filtering array and multi-select field

[Anonymous]

I may just be overthinking this. I'm fairly new to Flow so I'm not sure what I am doing wrong.  Thanks in advance.

Scenario: I created a list where we are storing items with an Expiration Date. I created a multi-select field that contains the following 4 values: 45 days, 30 days, 15 days and 7 days to allow a user to choose at which days they want an expiration notice email.

For example, if the expiration day is April 17, and today is April 10, and 7 days is chosen, I will get an email today alerting me. They can choose multiple alerts.

My Condition statement is working but I cannot get a single row of data for my HTML table. I am getting 5 rows of correct duplicated data in the HTML table doing it one way I tried (I have 5 items in my SP list so this is why for whatever reason), and I am getting 2 rows of data (the number of boxes that were checked in the multi-select) another way. I'm not sure what I am doing wrong. Can someone help? 

My condition is checking if the Expiration Day = NumberOfDays+TodaysDate and it works fine. It only enters Yes when I want it should.

My filter array gives me the same for input as output when I test. I was attempting to just grab the first row where notification rule = option that was chosen (Output_9 is basically equal to "15 days") but it honestly does not matter which row I get. If I have gotten this far, the item details will all be the same (see HTML table output below). I just need a single row in the array for my HTML table. 

This is what my array output:

[

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 1,

    "Value": "30 days"

  },

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 2,

    "Value": "15 days"

  }

]

[efialttes]

Hi!
Is the condition inside an 'Apply to each' iterating all through your SP list items? Or... Iterating oll through multivalue column? Or... no Apply to each? Or...
Can you share a screenshot of the whole flow design? The more context info, the faster you will get a valid suggestion
Thanx!

[Anonymous]

Hi,

I am adding screenshots with the whole workflow and the SharePoint Item for details on what I'm working on. Please let me know if I'm not making sense. I've tried Filter array using the entire SP list items to just get my current item but it doesn't seem to work for me. I'm sure I am doing it wrong just do not get where I am going wrong. I think I may have provided too many details now. 

SP Item:

Flow:

Actual run where Expiration Date is a match:

Intput and output of Array is:

[

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 1,

    "Value": "30 days"

  },

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 2,

    "Value": "15 days"

  }

]

Thanks in advance for any advice!

[v-litu-msft · Accepted solution]

Hi @Anonymous,

I think your Flow is a little messy and the logic is not very clear. Here I create two Flow to implement your requirements according to your description.

SharePoint columns, NotifactionRule is multiple choice and ExpirationDay is multiple lines of text:

Flow one, when an item created in the list, initialize a string variable to hold the Expiration Days, then it will get the string shows above:

addDays(body('Get_item')?['Created'],int(item()?['Value']),'yyyy-MM-dd')

 Flow two, Create a recurrence runs every day to check whether have item expired, 

 This part is converting the Expiration day into an array, then use the contains to check the utcNow() whether it exists in the array, if it exists, send a notification email.

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