cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

AutoFill lookup fields from lookup dropdown list

Hey again

 

 

As already mentioned in some other posts, I work with two lists. One where all my sandwiches are stored and one where i can order sandwiches and have an overview of them. The two lists are linked in SharePoint.

 

So if I want to order a new sandwich I pick a code from a lookup field and then I would like that the description, price, etc... is filled in when I pick the code.

 

Now the scenario is that when I pick a code nothing fills in but when the submit button is clicked it fills in and stores the item. So actually it works but the only problem is that you don't really know what you order until its to late.

Any ideas to Update or Fill in those fields before ordering/saving?

 

Kind regards

 

 

Tom

 

 

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: AutoFill lookup fields from lookup dropdown list

This is the solution that provided me the answer!

 

Thanks to @v-micsh-msft for the solution in my previous post for this problem!!!

 

First(Search(Broodjes,<DropDownList>.Selected.Value<1,2>,"<Column>")).<CorrespondingColumn>

Kind regards 

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: AutoFill lookup fields from lookup dropdown list

Hi Tom,

 

I think your issue should be handling from the first beginning. You should store the overview information of the sandwishes along with the first list instead of the order list. 

 

If you have a different opinion, please feel free to tell.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: AutoFill lookup fields from lookup dropdown list

Hey @v-monli-msft

 

 

Maybe my previous post is more clear about my problem I have.

I made this post because I didn't get any response up until now.

So if you want to know the problem more in dept go to: Previous post

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: AutoFill lookup fields from lookup dropdown list

This is the solution that provided me the answer!

 

Thanks to @v-micsh-msft for the solution in my previous post for this problem!!!

 

First(Search(Broodjes,<DropDownList>.Selected.Value<1,2>,"<Column>")).<CorrespondingColumn>

Kind regards 

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





View solution in original post

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,265)