Temporary Tables

[LarryAlx]

• I am currently pulling a list from a Sharepoint that contains enrollment info -  body('EnrollInf') - Start date being the start date of the contract
• After pulling the list I need to determine a product to use based on whether or not the start date lands between the products
• the start dates are being pulled in from another list - body('ProdInf'), Rate Start and Rate End being the date range on that list

There is no over lapping of dates on the ProdInf list and the following, Rate Start <= Start Date <= Rate End.

What actions or how would I express that in the flow?

Keep in mind I will need to use the result in a create action with the record info from the EnrollInf list to create a record on an sobject.

[v-litu-msft · Accepted solution]

Hi @LarryAlx,

You can use two Get items to get rows of the two lists: 'EnrollInf' and 'ProdInf'.

But what's the relationship between the two lists? In other words, if you want to determine the Start date is between Rate Start and Rate End, you need to find a key column have same value in the two lists. I assume you set the key column named as ID,  you can use the following structure to create it:

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.

[v-litu-msft]

Hi @LarryAlx,

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

[ScottShearer]

@LarryAlx 

While I agree with @LarryAlx I believe that you could simplify the Flow by using a Get Items action and an OData filter.

So, once you know the start date, use a Get Items action and filter it so that only items that meet your criteria are returned.

Here is a link to a blog post showing how to filter list items using an OData filter.

[LarryAlx]

Hello @v-litu-msft 

I'm not sure I need the 1st condition but I do think this may be what I want to try.  Here is a better representation of what i am trying to do.  I am trying to assign a product to a contract using the start date as a way to filter for the product.

[LarryAlx]

Hi @ScottShearer 

Thank you for link, I definitely am trying to use odata filter more often, however I've had problems using 2 filter criteria

for example:

Not sure if this would be the correct syntax but I'm sure you'll get the idea.

Start Date ge 'Rate Start' and Start Date le 'Rate End'

Maybe you can let me know what i'm doing wrong?

Thanks,

Larry V.