Power Platform Community Forum Thread Details

Hello Everyone,

I am really in need of help.
I have two lists (inventory and orders) in a channel (inventory management). Inventory has 72 rows and 15 columns while orders list has 216 rows and 12 columns.
I want to create a scheduled workflow in which all information from these two lists will be retrieved into an xlsm file.

I have done these ways:

1. recurrence

2. get items- inventory

3. get items - orders

4. create a file

5. add a row into table.

but these actions seem likely not to work.

Can anyone actually give the right steps?

I am okay with the raw action steps.

Categories:

General topics

Hi,

Why would they not work?

1) You haven't explained exactly the format you would want since you said a single file. Are there columns with the same name? Let's assume not

2) You don't explain the relationships, so how are you going to combine the 72, with 216 since they are not a 1:1 match??

3) you don't explain if Inventory will have a 1:M relationship with Orders??? so are you printing multiple Rows, that duplicate inventory?? Or does each row in an

order near to find the inventory..

4) make a CSV file and open it in Excel, don't worry about it being XLSM

So much missing

Without the knowledge of how they 2 lists connect, its impossible to give you specific details, but here are the raw steps

1. Create Schedule Flow

1.b Create an Array or a string (array works better) just make it null to start

2. Get items from the list that you want to FIND if the other list has data for it.

Let's assume its Orders

3. Do an Apply to each

3a. Do a Get Items, but with a Filter, using the ID from #2, that allows you to find the Inventory row

3b. Append the row of data (from both Get Items) onto the Array you created

4. When the Apply to each is done do a Create File (SharePoint or One Drive) with the content being the Variable