Hello again,
I don't know if this is can be done but i have an excel with 2 columns:
1) Full name of every Employee
2) Cost Center where every user is assigned on a single value
I made a dataverse table with 2 columns: Name, CostCenter and imported the excel data.
My main form is saved on a sharepoint list where i have a text input named Cost Center and i want to retrieve the 2nd Dataverse column when CostCenter.Name=User().FullName
Is it possible to achieve this and if not how do you think i should do it?
Thanks in advance for your help.

Report
All responses (
Answers (