Share
Report
2Hey guys,
There are several people in the organization and each employee has their own excel sheet ( table) that tracks the courses they took. Essentially, I want the employees to select what course and "sign it off" which updates their respective excel table with the date they signed it off.
At the moment, I am using the patch function which updates exactly how I want it to. However, how do I make it so that depending on which user is using the app ( each have their own Office365 accounts), it will fill out their respective table?. From what I read, it seems like PowerApps cannot implement a dynamic feature for the source in the patch function. ( like having "Text(Office365Users.MyProfile().Given Name)" instead of the actual table) So, any suggestions on how to work around it or other solutions? I know I can rebuild the app for each employee but it contains a large number of buttons and categories for each "course" which is very time consuming especially when it comes to making changes in the future
Thank you!
Patch(
JohnTable,
LookUp(
JohnTable,
List = Text("Course 1")
),
{
List: Text("Course 1"),
level_1: Text(Today())
}
)
All responses (
Answers (
