hi guys, i need help in creating Microsoft Flow from 5 different list from sharepoint.

Question

question

SumiteshKumar asked Apr 2, '22 SumiteshKumar commented Apr 11, '22

hi guys, i need help in creating Microsoft Flow from 5 different list from sharepoint.

I am trying to create a dashboard from 5 different list from sharepoint.
3 list from 1 database (list A, list B, list C)
1 list from 1 database (list D)
1 list from 1 database (list E)

List A contains spread view (Jan, Feb, Mar.. Dec)
Similarly B, C, D and E
I want to create dashboard in monthly spread view (Jan, Feb, Mar.. Dec)

Condition used :
Projection = sum (A+B+C+D)
Difference = E-(sum (A+B+C+D))

please have a look on the export date of list A, B, C, D and E(excel) from sharepoint.

Shapshot of dashboard i have made it manually in excel using Vlookup, need to make it in sharpoint.

office-sharepoint-online office-sharepoint-server-development office-sharepoint-server-customization

dashboard.png (55.1 KiB)

list-a.png (31.5 KiB)

list-b.png (31.5 KiB)

list-c.png (28.0 KiB)

list-d.png (51.6 KiB)

list-e.png (32.1 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-04T13:37:50.797Z

YiLu-MSFT answered Apr 4, '22 SumiteshKumar commented Apr 11, '22

Hi @SumiteshKumar
The information in the 5 lists is too much, I could not figure out clearly what is the connection between them. As the result you want to get is involved in different kind of calculation methods, it is difficult to achieve your requirement using just one flow. For example, if I want to get the sum value in "Jan" and "Feb" column with "Amit" Title in a list, I need to create a flow as following:

As a result, I could use this flow to create the sum value of "Jan" and "Feb" with Title "Amit" from list1 to list4:

So in my opinion, you need to create a few similar steps to get the sum value in "March', "April"..."Dec". And you could also get the sum of "Jan" in list1 and list2 with the similar method.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

image.png (19.8 KiB)

image.png (70.0 KiB)

image.png (21.1 KiB)

image.png (7.2 KiB)

image.png (4.6 KiB)

· 3

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YiLu-MSFT · Apr 04 at 02:12 PM

Hi @SumiteshKumar
This is the whole flow to add the value in "Jan" list1 and "Jan" list2 with "Amit" Title to list4:

Just notice here I add two Compose step to get the output of “Sum1' and "sum2", this step is to summarize the two variable and add the output in "Create item" step:

The dynamic content in "Jan" is add(outputs('Compose'),outputs('Compose_2'))

As a result, we could create new item to get the sum of "Jan" in list1 and "Jan" in list2:

This is the two basic flow you need in your requirement, as the data in your lists is a bit large, the flow may be tedious and to complete it need a lot of time.

0 ·

image.png (34.9 KiB)

image.png (28.1 KiB)

image.png (6.0 KiB)

image.png (3.7 KiB)

image.png (8.0 KiB)

YiLu-MSFT YiLu-MSFT · Apr 11 at 12:58 AM

Hi @SumiteshKumar
Is there any progress on this thread? Please comment here if you still need help.

0 ·

SumiteshKumar YiLu-MSFT · Apr 11 at 07:27 AM

Thanks

0 ·

question