Hello everyone,
I have stumbled upon yet another thing I do not know in PowerApp, and thus, am here asking if anyone of you could help me.
My problem now is that in screen 1 "proyect list" I have a list of all the projects an user has items on:
From that one, I select one and I will want for my browse screen to show it with "project 2" as the one selected, for example. The problem is I do not know how to link that the selected value there will show as the one I see on the browse screen.
So here instead of seeing all the items of "project1" and the dropdown list have selected "project1", I would want to have it selected on "project2". Due to the way the droplist and gallery are coded:
Droplist:
Distinct(Filter(demo_project;User().Email in ShowColumns(Encargado;"Email"));Título)
Gallery:
SortByColumns(Filter(demo_project; Título = ListaProyectos.Selected.Value && User().Email in ShowColumns(Encargado;"Email"));"Fecha_x0020_Termino";If(SortDescending1;Descending;Ascending))
What should I do so the selected one is the one I choose from the view of the project list?
Thanks in advance for any help,
NOTE: I still want the user able to choose from the dropdown list.
Solved! Go to Solution.
Hi @FelipeCaru ,
Is Listado de proyectos your first list in your BrowseScreen1 as next screen shows?
And do you want to when you select Project1 the second screen’s dropdown shows Project1 and the gallery shows Project1’s related information?
Is ListaProyectos your dopsown’s name?
And your dropdown’s Items: Distinct(Filter(demo_project;User().Email in ShowColumns(Encargado;"Email"));Título)
Your gallery in your second screen’s Items: SortByColumns(Filter(demo_project; Título = ListaProyectos.Selected.Value && User().Email in ShowColumns(Encargado;"Email"));"Fecha_x0020_Termino";If(SortDescending1;Descending;Ascending))?
What is your first list’s type? Gallery or other control?
If that is also one gallery, I think you can edit the formula as this: Listado de proyectos. Items: Distinct(demo_project; Título)
Your dropdown’s Items: Filter(demo_project; Título= Listado de proyectos.Selected.Result,User().Email in ShowColumns(Encargado;"Email"))
I test as this: Gallery1.Items: Distinct('20190221projectsnavigate',Projects) (on your side you can change the name of your sp’s and column’s)
Dropdown1.Items: Filter('20190221projectsnavigate',Projects = Gallery1.Selected.Result,User().Email in ShowColumns(Persontype,"Email")) (on your side you can change to your sp list name and column name)
Result:
Hope this can be helpful.
Best Regards.
Yumia
Huh, weird. I was told this thread was marked as deleted/spam by a mod.
@v-yuxima-msfthello, not sure if what you said works, but I got answered in here:
Hi @FelipeCaru ,
Is Listado de proyectos your first list in your BrowseScreen1 as next screen shows?
And do you want to when you select Project1 the second screen’s dropdown shows Project1 and the gallery shows Project1’s related information?
Is ListaProyectos your dopsown’s name?
And your dropdown’s Items: Distinct(Filter(demo_project;User().Email in ShowColumns(Encargado;"Email"));Título)
Your gallery in your second screen’s Items: SortByColumns(Filter(demo_project; Título = ListaProyectos.Selected.Value && User().Email in ShowColumns(Encargado;"Email"));"Fecha_x0020_Termino";If(SortDescending1;Descending;Ascending))?
What is your first list’s type? Gallery or other control?
If that is also one gallery, I think you can edit the formula as this: Listado de proyectos. Items: Distinct(demo_project; Título)
Your dropdown’s Items: Filter(demo_project; Título= Listado de proyectos.Selected.Result,User().Email in ShowColumns(Encargado;"Email"))
I test as this: Gallery1.Items: Distinct('20190221projectsnavigate',Projects) (on your side you can change the name of your sp’s and column’s)
Dropdown1.Items: Filter('20190221projectsnavigate',Projects = Gallery1.Selected.Result,User().Email in ShowColumns(Persontype,"Email")) (on your side you can change to your sp list name and column name)
Result:
Hope this can be helpful.
Best Regards.
Yumia
Huh, weird. I was told this thread was marked as deleted/spam by a mod.
@v-yuxima-msfthello, not sure if what you said works, but I got answered in here:
@FelipeCaruI thought this sounded like a familiar conversation.
User | Count |
---|---|
227 | |
101 | |
93 | |
56 | |
30 |
User | Count |
---|---|
288 | |
116 | |
109 | |
62 | |
58 |