I have two SharePoint lists A and B which have 3 same columns and a different column which have their respective lists name as its metadata e.g. "TaskId","TaskTitle" and "Department","List". I want to merge the data from both the lists and display it in PowerApps gallery which show current data every time it is opened. I assume that we will store the data from both the lists in two separate collections and then merge those collections into a third collection and display it in a gallery. The output should be as shown in the picture.
Asked
Active
Viewed 1,058 times
0
-
Have you looked into the COLLECT function? https://learn.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect – Skin Jan 11 '22 at 00:25
-
Yes, but how are we supposed to merge the two collections then in a vertical manner? – Test User Jan 11 '22 at 07:14