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.