Hi Folks -
I have a forum that has a data source of "rdPartnerAssets" and a ComBox that is populates with a certain source (Table.Column) based on a Radio button selection on my form.
However, I would like if I can filter ComboBox with another field from that source. Each source has a SP column called "Portfolio_Status" and I'd like to return all value from the particular data source where "Portfolio_Status" <> Terminated.
My current formula is as follows:
If(Radio1.Selected.Value="Asset",RD_Portfolio_Compound_List.Alias,Radio1.Selected.Value="Investment",RD_Investment_List.Alias,Radio1.Selected.Value="Target",RD_Target_List.Alias)
I tried th filter function, but can't seem to get it to fire. Thanks!
Solved! Go to Solution.
Sorry wrong screen shot!
Below is the correct one. For some reason, its not recognizing "Portfolio_Status" in the data source...(RD_Portfolio_Compound_List).
@simms7400 wrote:@R3dKap Hi -
Thank you, but that doesn't validate. Also, Alias isn't a choice column in the data sources.
What is the datatype of your Alias column then?
Thanks... Ok... So what is the data type of your Alias column ?
Oups, sorry... Didn't see it (post was too small )...
Ok, so let's summarize the situation here:
Is that correct?
This is assuming that all list datasources have the 2 columns Alias and Portfolio_Status... Correct ?
Sorry... I was busy on another matter...
Ok, now that we have the exact goal we just need to find the solution ...
Let me do a test on my side and come back to you...
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
204 | |
180 | |
62 | |
32 | |
30 |
User | Count |
---|---|
324 | |
270 | |
104 | |
74 | |
56 |