Answered

Edit Form Update secondary lookup if changing primary lookup

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm creating a powerapp with SharePoint as Data Source.

I want to create an ne Item in my SharePoint list wich contains a Lookup column, the primary lookup is the Customer Name, I can chose the customer with a dropdown and everything is fine, my problem is that the fields of the secondary lookups aren't updated, so my users can't see the full address until they saved the form.

Is it possible to update the secondary fields, marked in the screenshot, with the "onchange" parameter of the primary lookup field or is there any other solution for my problem?

Thanks for your help in advance.

Kai

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Abhilash_Swain 901 on at

Like (0)

Report
Copy link

Link copied!

Good day kai,
Please share the codes used in the secondary lookup.
It will be helpful.

Thanks
Abhi

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The answer is no (they are a formula back in SharePoint) and I will give you a bit of advice if you will take it - please throw away the Lookup columns unless you need them to use directly in SharePoint (they are unnecessary unless you need to do this), do the lookups in Power Apps and write back to Text fields. I have a blog on data structure that mat interest you.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Like (0)

Report
Copy link

Link copied!
Hi Abhilah,
its the standard code in forms I think:

Choices([@Umfuhrauftraege].'Ladestelle:Plz')

Thanks for your help

Kai

Was this reply helpful? Yes No
Verified answer

Abhilash_Swain 901 on at

Like (0)

Report
Copy link

Link copied!

Hi Kai,
I will go with @WarrenBelz. Lookup columns are useful when they are getting used in Sharepoint forms directly. Once you move to PowerApps you can do the lookup or filter in Powerapps and populate the values.

Change lookup fields to single/multi-line text as required.
Example:-
Let's say you are having an employee table. You are having another table of their personal data.

Use the employee table to show employee names/ ID (Prefered). based on your selection, you get the data and update the default value for other fields.
Ex:-
First(Filter(PersonalData,EmployeeID = Dropdown.Selected.value)).StreetAddress

Please give me a Thumbs up if I answered your question and mark it as a solution to help others.
Thanks
Abhi

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

I will leave you with @Abhilash_Swain due to time zone, but it does not change my advice to you.

Was this reply helpful? Yes No