Unanswered

Multiple Sharepoint Lists > Navigate problems

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

SKimble119 21 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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 !

Was this reply helpful? Yes No
SKimble119 21 on at

Like (0)

Report
Copy link

Link copied!
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})

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
SKimble119 21 on at

Like (0)

Report
Copy link

Link copied!
navigate(EditPage,None,{MyVariable:NameAssociation})

Set the form or gallery to use Datasource=

Filter(List2,NameAssociation=MyVariable)

Was this reply helpful? Yes No