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
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
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!! Smiley Happy

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 455 members 5,494 guests
Please welcome our newest community members: