Unanswered

Filter SP List B where field matches with SP List A and count occurrence to output to HTML table for each item in List A

(0) Share

Report

Posted on by CrazyCol

Hi All, I have hit a brick wall with this one, hoping someone can put me on the right track to build a solution, there are posts trying to achieve something similar but not quite the same and I am falling down after the filter component.

List A 'Vehicle Register'

(Unique vehicles - Vehicle Rego number located in Field 'Title')

List B 'Vehicle Inspection Register'

Field: 'Vehicle' - drop-down selection choosing the Rego number from 'Vehicle Register' - 'Title' field

I want to create an HTML report to send in an email showing how many inspections have been completed for each vehicle in List A. I want to do it this way so we can report all vehicles in our fleet (20) and easily identify which ones have or haven't had inspections completed and for those that have, how many times.

Vehicle 1	1
Vehicle 2	0
Vehicle 3	3
Vehicle 4	2

This flow would be set up as a fortnightly occurrence, and I am happy with applying this date filter in the get items stage. Where i fall down (due to a lack of understanding) is after the Apply to Each (Output from Get Items - List A) and applying the filter array where List B Items 'Vehicle' equals List A 'Title' how to bring the results to structure the rows in the HTML output.

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report

Re: Filter SP List B where field matches with SP List A and count occurrence to output to HTML table for each item in List A

Hi @CrazyCol ，

Could you please post the screenshots of your two lists?

I would like to know how you can tell if a vehicle inspection is done and when it is not?

Is there also a status column for 'Vehicle Inspection Register'?

The more information you provide, the more likely it is that I can help you solve this problem ...

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
CrazyCol 49 on at

Like (0)

Report

Re: Filter SP List B where field matches with SP List A and count occurrence to output to HTML table for each item in List A

Hi @v-yetonggu-msft

Essentially it is set up like a one-to-many relationship, but they are independent except for the vehicle registration. When a user conducts an inspection on their vehicle, they choose their vehicle from the drop-down list, which is referenced to the vehicle register.

Either a vehicle inspection has been done or not done, evidenced by a line item with the Vehicle Rego in the vehicle inspection register. I was considering just reporting from the Vehicle Inspection Register grouping unique vehicle Rego and counting their occurrence, but I also want to highlight vehicles that have had no inspections completed, hence my reference back to the vehicle register.

There is no status. column in the vehicle inspection register

Vehicle Register (Field Title - (labelled registration)

Vehicle Inspection (Field Vehicle - drop down list to

thanks

Was this reply helpful? Yes No