cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
SKimble119
Level: Powered On

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

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 !

 

 

SKimble119
Level: Powered On

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})

 

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
SKimble119
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,360)