HI there
I have made an hours monitoring app. This is linked to a sharepoint list 'On call hours monitoring'.
There is an email column (text), start time (text), end time (text), activity (text) and notes (multiline text). The email column is a choices formatted column with 16 different emails as choices.
I have made an app from the sharepoint list.
On the editform1, there is a dropdown created for me. I have used this code in the items heading
Choices([@'On call Hours monitoring'].Consultant_email)
and when preview the app the dropdown shows the appropriate choices and allows me to select appropirately, enter the other data needed and correctly create a sharepoint entry. I am happy.
What I would like to do is default the dropdown to the logged in user. I have created a variable varUserEmail at the app --> on start section to create the variable and this populates with the appropirate email correctly
However, I have tried using the variable in the dropdown control default section and defaultselected section and it states that either table or record data is needed in these sections and that Text data is being passed to them.
Reading this page
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-tables
i feel that the datatype being passed to the default and defaultsection sections is incorrect.
I do have a different sharepoint list with ONLY the emails on which I can connect to the powerapp.
I would like logged on users to have the dropdown (choice) selected to their email so users only have to enter start , end time, activity and notes and then submit.
I am not sure what formula to use and where?
Any help would be appreciated.
