Answered

Setting default text datacard in form from another data source

(0) Share

Report

Posted on by Dhubach1

Hey all.

I am trying to set a default value for a text datacard that's from another data source. For example. The form where the datacard lives submits to Timekeeping datasource/list. However, I want to pull the user's "Department" from another data source called Employees. I have added both data sources. Any help would be greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Dhubach1

Are you planning to not let the user make changes to that value in the form? i.e. you just want it to always have the looked up value?

If so, then just set the Update property of your Datacard to a lookup.

Ex: LookUp(<yourOtherListHere>, <yourLookupCriteriaHere>, <yourLookedUpColumnHere>)

If you want to allow them to edit it, then you should apply the above to the control in the datacard that contains the value.

I hope this is helpful for you.

Was this reply helpful? Yes No
Dhubach1 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response and looking into this now. The only problem is there are multiple departments that I am trying to look up from the other column.

I have a form1 that submits work-from-home requests to spo list1. I want to be able to pull the employee's "department" column from spo list 2 and fill it in the datacard 'Department' for form1 automatically if possible.

Hope this makes sense thanks again

Was this reply helpful? Yes No
Dhubach1 45 on at

Like
a
(0)

Report
Copy link

Link copied!

I am trying LookUp('List2', department = User()?) Sorry im a noob <--- User would be the logged in user to the system/App.

Thanks!!

Was this reply helpful? Yes No
Dhubach1 45 on at

Like
a
(0)

Report
Copy link

Link copied!

List 2 has two columns that i need to match with the signed in user. Emplyees(peoplepicker) and Directorate (choice). @RandyHayes

Thanks much

Was this reply helpful? Yes No
Verified answer

Dhubach1 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Got it. Thanks again so much for the help and sending me in the right direction. For anyone that might come across this the formula in the From1 Datacard TextInput - Default=

LookUp('List2', 'employee'.email = User().Email).Department.Value

Thanks again @RandyHayes

Was this reply helpful? Yes No