How to send an email with respective elements in different columns?

[GeZeCe96]

Hello, everyone.

I am developing this tool for my company, which consists in reading a table of engineering items and send emails for the responsible for them.

The table looks like this:

What I need to do is put those respective elements for each column together.

So the output that I am intending to have is something like this:

ID	1000
ITEM	A
ITEM DESCRIPTION	A
STATUS	A

ID	1001
ITEM	B1
ITEM DESCRIPTION	B2
STATUS	B3
ITEM	C1
ITEM DESCRIPTION	C2
STATUS	C3

I have tried to iterate between those elements using power automate but I couldn't find a way.

Every time that I try I cannot put the items respectively in order to send the emails, as the image below shows:

Can somebody please help with a suggestion of what can I do to solve this??

[v-stephen-msft · Accepted solution]

Hi @GeZeCe96 ,

Sounds like it's related with RLS. Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

Please kindly refer to

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Dynamic Row Level Security with Power BI Made Simple - RADACAD

Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.