Send email from PowerApp with data from Parent/child lists

(0) Share

Report

Posted on by Community Power Pla...

I am working from the Microsoft-provided template for the mobile expense report PowerApp. On submit, there is an approval flow that is kicked off, which has the steps as below.

What I'm looking to do instead of this approval process is when I click submit from PowerApps, I want to kick off a flow that gets the data from two SP lists (there is a parent (Expense) and child (Line Items) list), format the data to be tabular (columns and lines), and then send to a group email.

I'm stuck on how I go about joining together data from two lists. There is an ID on the parent list, and a "ReportID" on the child list that looks up to the parent list.

I have the same question (0)

All responses (1)

Answers (0)

MJain 2,450 on at

Like (0)

Report

Re: Send email from PowerApp with data from Parent/child lists

Hi @Anonymous ,

If you are looking to filter the parent list first and then based on the parent list filter child one this url be of some help :

https://www.netwoven.com/2019/05/15/how-to-query-a-sharepoint-list-from-another-sharepoint-list-using-microsoft-flow/

Thanks

Was this reply helpful? Yes No