Hi Everyone! I am creating an app where I am using the gallery items to populate the form based on an SP list. These gallery items are based on the country keyed-in in the text input and can be processed by 1 or more persons depending on the email address(es) indicated in a column in the SP list called "System Owner Email Add". However, the current formula that I am using can only accept 1 email address. If the cell in the in the column "System Owner Email Add" contains multiple emails address, the gallery items will only be visible to the first email address in the cell.
This is the current formula that I am using:
Filter('SP List', TextInput2.Text in CountryColumnSPList, Status<>"Finish", 'System Owner Email Add'= varUser.Email).
My goal is for the galley items to be visible to all the users indicated in the "System Owner Email Add" column and any of them will be able to process the task.
Below is the simplified SP List.
| Server Name | Country | System Owner Email Add | Action Taken |
| Server A | Country A | abc@abc.com
def@abc.com
ghi@abc.com | This will be based on whichever action is selected in the app by the System Owner. |
| Server B | Country B | jkl@abc.com
mno@abc.com | This will be based on whichever action is selected in the app by the System Owner. |
Any help will be greatly appreciated.
