Hi everyone,
Creating this new query as there was some requirement change (to one of my previous post: Previous ) . So in my previous query I had to perform in sub-folders based on tag column, here I was using a multi-line column to store the tags. But now instead of using a text column now I need to use a choice column and the choices for every folder will be different (there will be 1-2 that will be in common).
Example:
Assume there are 2 folders Mendix and Power Platform
For Mendix folder : There will be a column named 'Tags' which will have the following choices: 'Integration', 'SSO','Security'
For Power Platform folder: There will be a column named 'Tags' which will have the following choices : 'Automation', 'Connectors', 'Integration'.

So currently I have created a SharePoint list named TagsList in PowerApps_DEMO site. In this list I have created 2 folders named PowerApps, Mendix and have added few files in it. So now if I add a column inside a folder (like PowerApps with some choice values those are reflected in other folder as well) like this:


So my question is it possible to do this in SP list for a site or do we need to create separate sites (and if create separate site can we connect different sites and their SP list and perform search) or is there another workaround?.
2. Then on the main screen there will be a search box which will do the searching based on the tags (which is a choice value) we can provide a choice column which will show all the list of choices from both the folders (i.e. 'Integration', 'SSO','Security', 'Automation', 'Connectors', 'Integration'.) or a normal text column to do the search based on the pass value.

3. The other thing is which is after this search part is done in sharepoint we get a pop-up to add a records like:

In the similar way I want to design a pop-up or screen. Where the title will be the folder name, in attachments whatever attachments are added will added in the folder and the label field will show the tags. (This is once the search part is done).
I did try adding a new choice column in the PowerApps folder with two choices but on saving it the column was not shown so when I tried adding (Show/hide column) it showed the column for few seconds and then disappered (i.e. new column were unchecked) .



So any inputs for this will helpful on how to work for it.
Regards,
Sidhant.