Power Platform Community Forum Thread Details

I have two datatables extracted from excel.

Now, I need to get the data that is the same between two tables. which means intersection( or inner join in SQL).

But I can't find an available function in PAD.

Any advice?

Thanks

Categories:

There is no way to do that natively in PAD. But since you mentioned an inner join, I assume you want to compare it based on some main identifier column. What you would need to do then is loop through one of the tables and then use Find or replace in data table on the other table to check which items from the first table are in the second one. The action will return the row index for you, so you will be able to retrieve the matching row, if needed.

This will be slow, as you will need to do it for each line. But that is pretty much the only way to do it properly.

An alternative could be running a SQL query to the Excel file, if the two tables are in the same file, but separate sheets. You could do a join then.

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.