cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Multiple Sharepoint Lists > Navigate problems

Hello All !
I have a problem for use a multiple [SharePoint] lists data in powerapps.

 

I have 4 Lists.
L1 ( Informations of associations contact) :
-NameAssociation, Assigned (contact O365), Address, City, Department, Phone, Website ...)
L2(Form Projet) :
-NameAssociation, TypeProject, DateProject, ObjectProject
L3(Form Meet) :
-NameAssociation, TypeMeet, DateMeet, ObjectMeet
L4(Form Request) :
-NameAssociation, TypeRequest, DateRequest, ObjectRequest.

 

I created a powerapp for the List1.


I use filter by my contacts with a DropDownList1 (L1>city) and DownDownList2 (L1>NameAssociation).

It's Ok for that, but i can't see other informations in the gallery1.
And i can't use a button for "add Projet/Meet or Request" at my contact.

 

 

So, I have 2 questions :
1)How i can see other informations in the Gallery1.
2)How can i use the contact's informations for navigate in other screen for edit/add or delete of Projet/Meet or Request?

 

Thanks for your helping !
(and sorry for my english, i'm french.)

5 REPLIES 5
Highlighted
Regular Visitor

Re: Multiple Sharepoint Lists > Navigate problems

1) If you are attempting to find more information from your other lists (L2,L3,L4) you can use a lookup function in an added label inside your gallery.

2) To pass information to a new screen for editing a form I typically use a global variable that is set by the navigate function. Navigate( Details, ScreenTransition.Fade, { ID: 12 }from the documentation found here

Highlighted
Anonymous
Not applicable

Re: Multiple Sharepoint Lists > Navigate problems

Hello SKimble119!
Thanks for your advices.
1) I just want to filter and see the associations information. I think I have an error in my formula, because I can just see the Department column with my code:

Filter ('list-1'; Dropdown2.Selected.Result = Name).Department


2) I saw this page before asking my question, but I do not know how to navigate by getting the association selected.

 

Thanks again !

 

 

Highlighted
Regular Visitor

Re: Multiple Sharepoint Lists > Navigate problems

1) Maybe a simple typo: 

Filter ('list-1', Dropdown2.Selected.Value= Name)

2) Create a new screen, rename it to "EditPage". On your main screen where the gallery1 is located you should see some next arrows within the gallery1 item boxes. If you do not see the next arrows you can add one from insert>icons>next and set the OnSelect value of the arrows to 

navigate(EditPage,None,{MyVariable:VariableValue})

 

Highlighted
Anonymous
Not applicable

Re: Multiple Sharepoint Lists > Navigate problems

Hi again !
1) Thank you for your answer. It works;)
2) I have duplicated the screens (browse, detail, edit), but I can not (for example) select NameAssociation (List1) to add a project (List2).

 

Do you have an idea?  Sorry, I'm pretty confused about this problem for a few days now.

 

Highlighted
Regular Visitor

Re: Multiple Sharepoint Lists > Navigate problems

navigate(EditPage,None,{MyVariable:NameAssociation})

 

Set the form or gallery to use Datasource=

 

Filter(List2,NameAssociation=MyVariable)

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (834)