Get table of persons from 'registered' for every event from 'events'

(0) Share

Report

Posted on by Valentijn

initialise

I have a list of events ('evm events')
-columns: ID, session series, session code, Titles

and a list of registrants ('evm registration')
-columns: ID, personen, eventID

Goal

Each record has a 'person' and the selected event. By storing the ID of the events in the 'EventID' field

For each event, I want to store an HTML table of persons in PDF.

Flow

In the flow, I run through all events with an ID.
I filter 'evm registration' the event.ID in registrants. EventID.

I plug that table into HTML. But it's all columns. This works fine but doesn't look like it. It's too many columns.

So I want to choose custom columns. And then it goes wrong. It creates an extra loop which then also crashes when testing.

Overview

Overvieuw flow.png

The colum that I want in HTML-file

Output Filter.png

When I choose 'custom columns in advance options. Powerflow makes a second loop (Apply to each 2) Why? From then on, it doesn't work either

All responses (5)

Answers (2)

Valentijn 21 on at

Like (0)

Report

Re: Get table of persons from 'registered' for every event from 'events'

I would like to explain my goal with the screenshot below. So I want to go through the list evm_events where each evm_event.ID is used to filter evm_registration. Only the Person field I want as a result from that filter in an HTML table. The table will be given the title from the record of evm_event. the Html will be converted to PDF and emailed to the mail from evm_event.
Verified answer

Valentijn 21 on at

Like (0)

Report

Re: Get table of persons from 'registered' for every event from 'events'

Why 'fx Item(...)' as the value of {v}Select. I expect a field from 'List rows' .
I then went on to search what you meant by 'fx Item(...)'. I arrived at the following and it worked:
fx = Item()['field_name']
Verified answer

SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (1)

Report

Re: Get table of persons from 'registered' for every event from 'events'

Just send the flow and data. I will build a sample for you.

This is how I meant
Valentijn 21 on at

Like (0)

Report

Re: Get table of persons from 'registered' for every event from 'events'

Thank you for replying so quickly. I applied the selection after the filter. I can then choose between two outputs of the filter: 'Item(a table item)' or 'Body'.
- If I choose 'Item', the select goes straight back into a loop and the selected output changes directly to 'Body'
- If I choose 'Body' then I can fill in the 'folder' of the 'select'. BUT what do I choose as Value. In the 'Dynamic content, I cannot choose columns of the filter. Only the columns from 'evm registration'. If I then choose 'person', an extra loop appears again.
Know that I am using PowerApp and flow from Teams.
Otherwise I try to make my flow using test data instead of the data fresh. And upload the export here.
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Get table of persons from 'registered' for every event from 'events'

@Valentijn ,

It adds a loop because you are picking the "Person" field from an array.

Try this,

Add a Select action under the filter action and pick the Person's name or email field from the Filter action.

Next Use the Output of the Select action inside Create HTML table action.

Let me know if you struggle with it.