So here's the issue:
I have a form in a powerapp and two of the datacards have radials in them. The first one is the Wood Type radial. Its choices/formula is:
Table({Type:"Cant"},{Type:"Board"},{Type:"Stringer"},{Type:"Block"},{Type:"Cb"},{Type:"Eb"},{Type:"Tb"},{Type:"Remnant"})
The second is the location radial. It's pulling from a SharePoint list; column being single line of text. Its choices/formula is:
Sort(Distinct(REM_Wood_Data,Location),Result,Ascending)
Here's a photo of the app:
Here's a photo of the list (you'll need it for my question):
In this list the location is a single line of text and wood_type is a choices column. My boss wants to be able to reference the wood column in the app to the wood column in this list instead of the current table it's using.
Essentially if someone picks "Cant" in the wood type radial (referencing this SharePoint list), then the only choices they'd see from the location radial is (referencing this SP list) is Incoming Cants. If we change "cant" in the SharePoint list to "board" then when someone chooses "board" in the app all they would see is "incoming cants" for the location radial.
It's hard to put my question, but it would be a dynamically filtered column with the filtering coming from the SharePoint list in a sense.
If anymore information is needed please let me know and thank you for your help!
You need to change your Items:
Try this: You may have to play around with it as the 'Wood Type' = Label.Text, might need to be changed to Label.Text in 'Wood Type'.
Filter(Sort(Distinct(REM_Wood_Data, Location), Location, Ascending), 'Wood Type' = Label.Text)
User | Count |
---|---|
183 | |
124 | |
88 | |
45 | |
42 |
User | Count |
---|---|
248 | |
159 | |
127 | |
78 | |
73 |