Answered

Populate selected value in new screen on Navigation

(0) Share

Report

Posted on by Community Power Pla...

I am having trouble with the 3rd argument in a Navigation formula OnSelect for a Button I've added to a screen.

I am trying to create a Timesheet app using Excel in OneDrive for Business as a data source and target. I created the app using the Employees table as the initial data source. PowerApps automatically created BrowseScreen1 which lists all Employees with NextArrow1 that users select to go to DetailScreen1.

DetailScreen1 automatically included buttons to go back, delete or edit. I don't want Employees to be deleted or edited in the app so I've removed those buttons. I have added a Button which I've renamed ButtonEnterWorkTime. This button needs to navigate to a new screen I created, named EnterWorkTime, where users will enter work time. The Employee_Name must be passed through from DetailScreen1 based on the Employee_Name selected on BrowseScreen1. It should then populate the Field on screen EnterWorkTime which will then write to the spreadsheet in TimeEntry.Employee_Name.

Please advise the correct formula for the OnSelect property of ButtonEnterWorkTime. So far I've got

Navigate(EnterWorkTime,ScreenTransition.None) which navigates to screen EnterWorkTime and of course nothing comes across because there's no 3rd argument.

I've tried all sorts of things to do it but I get an error message every time and the button no longer does anything.

Please advise what I should enter in the formula after "None".

Any suggestion is welcome and thank in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

pontusofsweden 255 on at

Like (0)

Report

Hi!

I think the easiest way is to create a collection for the selected record when pressing ButtonEnterWorkTime. Like this: ClearCollect(SelectedEmployees;ThisItem).
In this way, you will get all the data connected to the selected employee and you can build the next screen based on the new collection. So, the complete formula could look like this on OnSelect of ButtonEnterWorkTime:
ClearCollect(SelectedEmployees;ThisItem);Navigate(EnterWorkTime,ScreenTransition.None)

BR
Pontus

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
Hi @Anonymous ,
Do you mean you want to pass the Employee_Name to Field on EnterWorkTime screen ?
Is there a Form on EnterWorkTime screen and its data source is TimeEntry?
If so, modify your navigate formula as below:

Navigate(EnterWorkTime,ScreenTransition.None,{Var_Employee_Name: BrowseGallery1.Selected.Employee_Name })

Then, set the Defaults property of Field(TextInput): Var_Employee_Name
Best regards,
Sik

Was this reply helpful? Yes No