Hi,
I did some research and it seems not to be possible to combine the results from two views in a same action. I see two options here: (1) use one Get Items for each view and then combine the results into a single array or (2) use a HTTP request to return only the desired columns.
Get items for each view
I tested this approach using only two views, so it must be more complicated if you have a large number of views. Add your Get items actions and then use an Apply to each loop for one of them, as marked in red. Inside the loop, add an Filter array action, where the From input will be the the records returned by the other Get items, as marked in blue. Inside the Filter array, you must match the ID column from both Get items actions:
The outcome from Filter array must be the record from the second Get items that matches to the currently iterated record from the first Get items in the loop. Now we need to merge them into a single object, and you can achieve it with a union() formula, passing the item() expression (highlighted in yellow) and the first element of the Filter array (highlighted in green) as inputs:
The output will be a single object merging the columns from both views. Any columns existing in both views (like the metadata columns, such as ID, created at, and so on) will be ignored, so you won't have duplicates in our object. After that, if it makes sense for your use case, you can append this result to an array variable.
HTTP request
This approach requires only one action to return all records with all columns. The inconvenient is that you must fill all of the desired columns into the request URI (highlighted in yellow):
URI: /_api/web/lists/GetByTitle('Choice cols')/items?$select=ID,col_1
Make sure to replace the bolded fields in the URI for your actual data. The result from this action looks like this:
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
23
Share
Report
All responses (
Answers (
