Unanswered

Selecting multiple items from SharePoint list and adding them to a HTML table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm trying to build a flow that will match up multiple items in SharePoint list and output them to a single HTML table.

I have a SharePoint list built that we use for order tracking, each order will have multiple items within SharePoint that are all linked to a sales order number, for example order 100 has 5 different list items for 5 different items that form part of that order,

What I'm trying to achieve is to get a HTML table that shows all the items for order 100 and send an email.

Thanks

Dean

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

AlexEncodian 4,409 Moderator on at

Like (0)

Report
Copy link

Link copied!

@hodgson41

Hi, when you say "Selecting multiple items", are you triggering this flow manually from SharePoint (e.g. selecting a few items and then starting the workflow) or is this triggered somewhere else and you want the logic in the flow to find the relevant items?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Alex,

ideally I want it to run on a schedule, for example to run over night to generate the sales orders for the next day.

thanks

Was this reply helpful? Yes No
AlexEncodian 4,409 Moderator on at

Like (0)

Report
Copy link

Link copied!

@hodgson41

In that case you are looking at a flow with a recurrence trigger.

Then use "Get Items" to get all the List items that related to an order number. You should be able to use ODATA query in Get Items to do this easily:

OData Filter query in SharePoint Get items in Flow (sharepains.com)

Then just create your HTML table:

How to create HTML table for Get Items in Power Automate?

Was this reply helpful? Yes No