Display information using a variable to identify the record

[Anonymous]

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

[v-micsh-msft · Accepted solution]

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

[Anonymous]

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!! 🙂