web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Different choice value...
Power Apps
Unanswered

Different choice value based on a folder and search

(0) ShareShare
ReportReport
Posted on by 986

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'.

Sidhant_02_0-1696403908567.png

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:

Sidhant_02_1-1696404337552.png

 

Sidhant_02_2-1696404376080.png

 



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.

Sidhant_02_3-1696409084830.png


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:

Sidhant_02_4-1696409252649.png

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) .

Sidhant_02_1-1696415343745.png

 

Sidhant_02_0-1696415313217.png

 

Sidhant_02_2-1696415462535.png

 


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

Regards,
Sidhant.

Categories:
I have the same question (0)
  • BCBuizer Profile Picture
    22,535 Super User 2025 Season 2 on at

    Hi @Sidhant_02 ,

     

    (1.) Yes this can be done with a single site/list as long as you keep delegation in mind.

    2. Items in both folders are still using / populating the same columns, so there is only one list of choices from both the folders.

    3. You can do that by using a Custom form: https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-apps/get-started/create-your-first-custom-form

    (4.) This should work as you described. Did you click the Apply button?

  • Sidhant_02 Profile Picture
    986 on at

    Hi @BCBuizer ,
    So it is possible using one site itself. I did check the Customize a form for a SharePoint list, so what I understand from that is a customize form is being created for that list. To answer your (4th point), yes I had clicked on Save changes after creating the new column and it appeared for few seconds on-screen and disappeared and the choices were same in both the folders.
    So I have removed the old list and created a new list. In one of the folders I created the choice column named Tag with three values, but these values are also reflected outside the folder 
    (Inside the Outsys folder)

    Sidhant_02_0-1696494413813.png


    Now if I create another folder in the SP list those choices are also reflected in the folder:

    Sidhant_02_1-1696494483099.png


    Regards,
    Sidhant.

  • BCBuizer Profile Picture
    22,535 Super User 2025 Season 2 on at

    Hi @Sidhant_02 ,

     

    Indeed subsets of choices for a column can not be created in SharePoint. Instead you will have to filter the choices in you PowerApps either by hardcoding or a separate data source where the subsets are defined. 

     

    In this topic I have given an example of how you can go for the hard coding option: https://powerusers.microsoft.com/t5/Building-Power-Apps/Uploading-Files-to-Document-Library-using-PowerApps/m-p/2389200/highlight/true#M596226

  • Sidhant_02 Profile Picture
    986 on at

    Thanks @BCBuizer ,
    For the reply I will check this out and let you know.

    Regards,
    Sidhant.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 393

#2
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 271 Super User 2025 Season 2

Last 30 days Overall leaderboard