Power Platform Community Forum Thread Details

I have a scheduled flow that takes rows from an Excel table and, based on a Region field, sends rows for that region in an email to the matching Region email address.

The Excel table has other fields:

SiteID, TimeID, and Level ID: The combination of these three fields represents event times at event sites.
SeatsAvailable: The number of maximum seats available to sign up for
SeatsRegistered: The number of registrations for that event. This number is always a 1 or 0, because this entire table represents event locations and times where a session has less than two registrations.

I have a second Excel table - a waitlist. It contains the same SiteID/TimeID/LevelID/SeatsAvailable/SeatsRegistered fields as the first table.

What I need to be able to do is:

-Compare the rows on the waitlist to find rows where the SiteID and TimeID match, but the LevelID does not.
-The resulting rows need to then come into the flow and be added to the email table

.. so that the end result is an emailed table that shows for each region not only what events have low registration counts (implemented now), but also records from the waitlist that show what other LevelIDs for that location and time might be able to be enrolled instead.

I'm not sure where to begin with this in the context of the existing flow structure although I have to assume it's before the first Apply to Each step or right at the start of it. Screenshots of the existing flow structure are here: https://imgur.com/a/foGNdvP

And then the actions themselves that I'm inserting:

- probably another List Rows Present In A Table action and then
- a filter array action for rows with matching SiteID and TimeID, but exclude matching LevelId values.
- That output goes to the TableforEmail (?), but what I'm unclear about is how to now format that table so that the relevant results from the waitlist table are listed in position under/nested within the associated site records from the first table.

Am I on the right track with the above? This one admittedly hurts my brain and having covid right now certainly doesn't help 😕

Categories:

General topics