For the Get Items from SharePoint, you can use the Filter Query field directly in the get items.
You have to write the filter query to get single selections or pairs however you want.
Here is an example:
Get Items - Filter Query
I have a SharePoint column named "GroupSelection" which is multi-choice.
If I write the Filter Query with a single group name, it will get all rows that have that group even if it has additional groups.
GroupSelection eq 'Group4'
However, if I only wanted to return selections that had Group3 and Group4 I would put that into the filter query:
(GroupSelection eq 'Group3' and GroupSelection eq 'Group4') or (GroupSelection eq 'Group1')
This filter would return only rows which had both Group4 and Group4. It would also return any row that contained Group1.
Here is a YouTube video for creating an Excel file.
https://www.youtube.com/watch?v=RB_ySjhm9Sg
It would probably be easier to make a blank excel file with a table to use as a template. So you basically copy the file, then add rows to the table.
But if you don't want to rely on a template, then you can use the video.
