Unanswered

Trying to get data from two SharePoint lists into one Email or New List

(0) Share

Report

Posted on by Jandal_Power

101

I pretty much copied Shane Youngs cart app (https://www.youtube.com/watch?v=Ztn39KuOW0g) - "Power Apps Shopping Cart new for 2021" then modified it for my use.
App works well, and the data collection however I am having the issue of joining the data together as a complete order.
The cart ordered items contains multiple entries attached to an OrderID eg,

Then the other list collects the personal information relating to the cart order with an ID that matches the OrderID

The plan was to use Automate to grab all the info when an order is placed, join it together and present the personal information with a list below of the ordered items.
I watched another video (https://www.youtube.com/watch?v=kiSYLjAcVVE) - "Power Automate - Multiple SharePoint Lists and Report" and was able to get some kind of result for a single item, but not the whole cart list and I can't figure it out.

End result I am wanting to send an email that shows the complete order, per order with all details.

Any ideas?
Regards,
Jandal_Power

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Jandal_Power 101 on at

Like (0)

Report

Here is the data I am trying to populate into an email if it wasn't clear 🙂

Was this reply helpful? Yes No
LorraineHowie 6 on at

Like (1)

Report

Hi, did you get a reply to this query as I have the exact same one. Have used Shane Young's video to make my app but now struggling to get all the information together to be able to process the order.

Was this reply helpful? Yes No
Jandal_Power 101 on at

Like (0)

Report

Hi there @LorraineHowie,
Sadly I never got a reply from anyone and have not yet figured out a solution.
I spent a day with power automate to amalgamate the data which sort of did work but not how I wanted.
I put it on the back burner and have not yet picked it back up.
Getting this project to work for 2024 is on my to do list.

I am open to solutions and hopefully someone might have some pointers.

Was this reply helpful? Yes No
Jandal_Power 101 on at

Like (0)

Report

The closest I have been able to get so far, grabbing the latest order, then filtering the OrderID to match the ID from the order so the second list shows the multiple items that were ordered.
The flow now grabs the data I want, I just don't know how to display it together... Hmm

Was this reply helpful? Yes No