cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

List items present in table (Fin & Ops) - Check if record in entity A exists in entity B

Hi Experts,

 

I have two List items present in table actions to get data from two entities.

 

  1. Sales prices
  2. Items

AdrianPeterson_0-1649320694884.png

AdrianPeterson_1-1649320699883.png

 

What is the best method to build a list of Items with Sales price i.e. check if Item number from Items entity exists in Sales price entity? I tried researching best methods but did not find the most suitable one for the 'list items' action as above.

 

Would also need the reverse approach e.g. Item doesn't have Sales price/doesn't exist in Sales price entity. I guess this should be straight forward once above example is working.

 

Appreciate your help!

 

 

1 REPLY 1

After some investigation I think I found the way:

 

The filter array is set to check whether Item number from 'List items' contains Item number from 'Sales price'

 

Then checking if the result is not blank - good old fashioned length(body('Filter_array'))

 

On TRUE, array is updated

 

AdrianPeterson_0-1649412433212.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,558)