Power Platform Community Forum Thread Details

Hi,

I have Sharepoint List 1 as:

ID Author Expense

1 Mario Holidays

2 Lucy Dinner

3 John Books

and a Sharepoint List 2 as:

masterID Author Expense Detail Amount

1 Mario Bahamas 100e

2 Lucy Meat 20e

3 John Q 15e

1 Mario Bali 150e

3 John Robin Hood 12e

How can I create a Power Automate flow to get an Excel file like:

ID Author Expense Expense Detail Amount | Expense Detail Amount

1 Mario Holidays Bahamas 100e Bali 150e

2 Lucy Dinner Meat 20e

3 John Books Robin Hood 12e Q 15e

Thanks in advice

Categories:

two sharepoint lists with Power Automate