cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Re: Lookup field Issue in PowerApps(Comman Data Services)

Thanks @mokhawaja:

 

Now is working fine, I understand better now what is doing...

 

With your way to do it, I've been able to see the correct field in the detailscreen, but for selecting the field in the editscreen it doesn't work, only works well if value 1 is primaryID, if I select another value it doesn't work.. any clue?

 

There is one more think I would like you to help me... thanks a lot in advance!!!

 

I have a database with three entities

 

1- Customer (Peticionario)

2- Company (Empresa)

3- Work order (Orden de trabajo)

 

The flow is like this:

A customer that works at a company asks for a work order

 

So the relations are as follows:

There is a look up relation between customer and company (as the customer works in the company . A lot of customers can work in a company, but a customer can work only in one company )

There is a look up relation between work order and customer (as the work order is request by the customer. A lot of work orders can be made by a customer, but a work order is done only by one customer))

 

Going back to the issue, ideally, when selecting the person that has made the work order, I would also like to see of course the customer.name, but also the company.name (that way is much more fast to find and make sure that I select the correct person.

 

So when a new work order is registered, ideally I would like to view the customer.name property in the value 1 field and the customer.company.name property, in the value 2 field

 

With your help I've been able select the correct property, but as value1 and value 2 fields that I want are from different entities (though they are indeed related) I think is not posible to do what I want, is it?

Highlighted
Kudo Collector
Kudo Collector

Re: Lookup field Issue in PowerApps(Comman Data Services)

hi @cholopa

really glad to help...

 

first let me be sure of some points:

  1. you need to view Value1 and Value2 on a "View" or "Edit" form, not gallery or dropdown, right?
  2. you do not want to view the list of companies... instead, a list of customers which contain the name of the customer and to which company he/she belong to, right?

regards,

Mohammad

 

 

Highlighted
Regular Visitor

Re: Lookup field Issue in PowerApps(Comman Data Services)

Any news on this bug? Can't seem to find much info about it. Is the userbase really that low so this can go unresolved...!?

Highlighted
Helper II
Helper II

Re: Lookup field Issue in PowerApps(Comman Data Services)

It can be sort out, you have to add all the entities to the powerapps app, and make the correct use of lookup and filter.

 

If you give me an example maybe i can help you.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (3,448)