cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Display information using a variable to identify the record

Hi

 

Help...I am stuck in the next phase of my powerapp...It's a (lack of) knowledge issue and probably really easy to answer!!

 

I have a screen that lists a number of projects and on selecting one of those projects, a new screen opens with a text variable that is the project name. I can get that variable to display in a label on the new screen, so I know this bit works ok.

 

I now want to display some information relating to that project name variable on my screen and this information comes from an excel table called EVA_Calc, which contains the project name as a column, as well as other information such as dates and cost columns.

 

I cannot think how to do this - my initial thought is to add a display form:

Ive set the DataSource as EVA_Calc

 

Now I want to search the EVA_Calc table for the relevant fields relating to the project name that has been passed to this screen.

 

Any advise would be gratefully received.

 

Thanks

 

kai

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Display information using a variable to identify the record

Hi @Anonymous,

 

Could you please share more information about the Excel Table and the record?

If the Variable is ablet to locate a single record, then we could take use of lookup function to find the proper record.

For example.

Lookup(EVA_Calc, project=Variable)

This formula would return a record, and if you would like to show the corresponding elements, for example the Project name, then try:

Lookup(EVA_Calc, project=Variable).Porject

So, here you may add some label with the formula example above, to display the proper information.

Filter, Search, and Lookup functions in PowerApps

For Display form, after datasource has been specified, please choose to un-hide the proper field, then take a try to put the:

Lookup(EVA_Calc, project=Variable)

in the Item property of the Display form control.

Check and see if this would work.

Some more readings:

Edit form And Display form controls in PowerApps

Regards,

Michael

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

View solution in original post

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Display information using a variable to identify the record

Hi @Anonymous,

 

Could you please share more information about the Excel Table and the record?

If the Variable is ablet to locate a single record, then we could take use of lookup function to find the proper record.

For example.

Lookup(EVA_Calc, project=Variable)

This formula would return a record, and if you would like to show the corresponding elements, for example the Project name, then try:

Lookup(EVA_Calc, project=Variable).Porject

So, here you may add some label with the formula example above, to display the proper information.

Filter, Search, and Lookup functions in PowerApps

For Display form, after datasource has been specified, please choose to un-hide the proper field, then take a try to put the:

Lookup(EVA_Calc, project=Variable)

in the Item property of the Display form control.

Check and see if this would work.

Some more readings:

Edit form And Display form controls in PowerApps

Regards,

Michael

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

View solution in original post

Anonymous
Not applicable

Re: Display information using a variable to identify the record

Thanks for this Michael

 

The lookup function is exactly what I needed.

 

My problem at the moment is locating the right functions to use at the right time - I wasn't being lazy...honest!! 🙂

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 (4,968)