Prepopulate Form with variables

(0) Share

Report

Posted on by Gabe1

Hello Everyone,

I have a problem, maybe it is too obvious to see the solution, but I couldn't get through it.

Note on the codes: European Powerapps, we use ;=, etc.

I have Sharepoint lists:

- Users

- Homes

- Surveys

These are relational lists, Users, have several Homes, Homes have several Surveys.

I would like to help to fill in forms, like if somenone fills a Survey, based on the choices before, they do not have to find their Homes, because it is prepopulated.

Now I made a Gallery for Users, they pick one and they go to another Gallery for the Homes, filtered only for the selected Users. When they start to fill in the Survey I would like that the Home column would be prepopulated according to the selection on Gallery Homes.

Now I only have filtered the dropdown menu from all Homes, to the one that the user previously selected. But still have to select.

I made this with global variable.

Items of Survey.Homes:

Filter(Choices([@Survey].Homes);Id=SiteIndex)

Siteindex defined Onselect at GalleryHomes:

Navigate(Survey;None; {SiteIndex: GalleryHomes.Selected.'Home index'})

But I couldn't use any Default value, or other solution. I would avoid patch, if it is possible.

Thank you,

Gabe

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Gabe1

Please see my blog on how to set up your lists here https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640 and how to implement the relationships in PowerApps here. https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Design-fundamentals-Implementing-a-One-to/ba-p/200521 . In a form, you can use the Update property of the foreign key's card to reference the primary key of another list and hide the card so that the user cannot change it.

Was this reply helpful? Yes No
Verified answer

Gabe1 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Finally I have found the solution.

Not filter, but lookup.

LookUp(Choices([@Survey].Homes);Id=SiteIndex)

Was this reply helpful? Yes No
Verified answer

Gabe1 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, your blog contains general information on Sharepoint lists, I did not have problem with Sharepoint lists, maybe you did not understand the question, but I have found solution. See below.

Was this reply helpful? Yes No