Unanswered

Show Gallery items of the User Logged from SharePoint List while a pulldown (CHOICE Field) is active on the landing page

(0) Share

Report

Posted on by ramoroso

I have the following code in my ITEMS field for my Gallery, but on any user logged in, I want to only show the items they submitted and I am not sure on the syntax for this in addition to the code below. The pulldown (CHOICE Field) is only available for certain Admin users. So all other user need to see their items from the SharePoint List that they submitted and only be able to submit a new record, which I have a button for that and it works fine.

If(Dropdown2.Selected.Value="Leticia Lamarque",SortByColumns(Filter('Contract Review', 'Assigned To'.Value= "Leticia Lamarque"),"Created",Descending), If(Dropdown2.Selected.Value="Yasaman Moazami-Goudarzi",SortByColumns(Filter('Contract Review', 'Assigned To'.Value= "Yasaman Moazami-Goudarzi"),"Created",Descending), If(Dropdown2.Selected.Value="Pending", SortByColumns(Filter('Contract Review', 'Assigned To'.Value="Pending"),"Created",Descending), Filter('Contract Review', 'Created By'.DisplayName=User().FullName))))

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

SoPatt Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Here is your code in a readable form:
If( Dropdown2.Selected.Value="Leticia Lamarque", SortByColumns( Filter('Contract Review', 'Assigned To'.Value= "Leticia Lamarque"), "Created", Descending ) ,//Else If(Dropdown2.Selected.Value="Yasaman Moazami-Goudarzi", SortByColumns( Filter('Contract Review', 'Assigned To'.Value= "Yasaman Moazami-Goudarzi"), "Created", Descending ) ,//Else If(Dropdown2.Selected.Value="Pending", SortByColumns(Filter('Contract Review', 'Assigned To'.Value="Pending"), "Created", Descending ) ,//Else Filter('Contract Review', 'Created By'.DisplayName=User().FullName) ) ) )
Here is your code as a Switch, which I think is even more readable:
Switch( Dropdown2.Selected.Value, "Leticia Lamarque", SortByColumns( Filter('Contract Review', 'Assigned To'.Value= "Leticia Lamarque"), "Created", Descending ), "Yasaman Moazami-Goudarzi", SortByColumns( Filter('Contract Review', 'Assigned To'.Value= "Yasaman Moazami-Goudarzi"), "Created", Descending ), "Pending", SortByColumns(Filter('Contract Review', 'Assigned To'.Value="Pending"), "Created", Descending ), Filter('Contract Review', 'Created By'.DisplayName=User().FullName) )

I'm not exactly sure what isn't working for you.
ramoroso 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you sopatte - much more readable. I will try to start writing my code in this format, as I see this is the standard.
ramoroso 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello sopatte - What is not working, or I am not sure how to do it in conjunction with my pulldone, is I want the gallery to only shows selected records that were input from the logged in user. Yet right now it shows all records depending what the pulldown is set at upon login. Does that help ? I need this initial view (only records submitted by current logged in user) in conjunction, with my If statement.
SoPatt Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I'm still not clear, but might it be that you want Dropdown2's Default to be "Pending"? Then the gallery will be filtered by 'Created By'.DisplayName=User().FullName.