Answered

To pass values from excel to datacontrol based on the logged in user details in the PowerApps form

(0) Share

Report

Posted on by Veblitz

2,249

Background: I need to fetch values from excel sheet for candidates training status and in my form i have a single line of text field in my new form and it should check the logged in user name with the excel sheet data and fetch the values in the new form training status datacard value dynamically for the respective logged in user

Excel sheet format

CandidateName Emailaddress Trainingstatus

John John@abc.com Inprogress

Sam sam@abc.com Completed

New form : (canvas appp PowerApps form)

Name: John

Training Status : Inprogress // This value needs to be captured from the excel based on the logged in user

Country: US

Save cancel

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Tolu_Victor 197 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi ,A simple lookup would provide the data you need
See below, modify as needed

Lookup(DataSource, Emailaddress = User().Email).Trainingstatus
You can display this on a label control or even use it as part of a query in any of your controls
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the inputs.

I copied the below code in visible property of my textbox as per my requirement and got error lookup is unknown or unsupported function.

Lookup(Table1, Emailaddress = User().Email).Trainingstatus
Verified answer

Tolu_Victor 197 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi

That code will return the "Trainingstatus" of the current logged in user as text or whatever data type your "Trainingstatus" column is

So if John logs into the app, that code will return "Inprogress" and if Sam logs in, that code will return "Completed"

So if you want them to view their training status, set the Text property of the label to that code and set visible property to true

If you want to query on the returned value, for example to show the label only if status is Completed ,
On the visible property use this code
Lookup(Table1, Emailaddress = User().Email).Trainingstatus = "Completed"

That will return a true/false value that the label will now use to display conditionally
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks.

Is this static way of importing excel in our app and lets say if i want this excel dynamic so whenever status changes we have to re import the excel right.is there any way to make this trainingstatus values is configured dynamically when we update excel in some path for dynamically in powerapps form.is it doable dynamic excel?