Unanswered

Dataverse formulas

(0) Share

Report

Posted on by todorovicdijana

Hi all

I am trying to do something that seems extremely simple, and yet i dont see the way without lookup function available in formulas. So, i have a table with Id of resource, Name of the resource, Id of the manager and i want to create a column Name of the manager, where i would use formula for having it populated. Since i have id of the resource and name, its seems so easy, give me the name for this id. However, i can not think of formula not being Lookup which is not supported. I tried If(id of resource = id of manager, give me back the name), which obviously only returns the names for the resources that are their own managers.

Any help would be appreciated 🙂

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

steeevid 333 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

1, create a lookup field in the resource table, looking up manager table
2, it's prefer that the primary column of your manager table is the ID column as you describe, so you can select manager ID in the drop down list, otherwise if you dont like what's showing up in the drop down list, you have to completely delete the whole table and re-create
3, in view, add new column, select related, manager table, name of the manager, put it in the view
4, now for every manager ID you allocate for resource, the manager name will show up

Was this reply helpful? Yes No
todorovicdijana 15 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for the reply, however, you misunderstood my explanation.
I have one table only, Resources, so i am not talking about creating relationships between tables using Lookups, i am talking about creating a column in Dataverse table using formulas, choosing Data type - formula, Fx.....
As i have id of resource and manager is resource at the same time, i am sure there is a way to associate the id of manager with a resource name, i just can not find an expression. To me it seems that Lookup function would resolve that, but apparently Lookup is not suported function in formulas...

Was this reply helpful? Yes No
steeevid 333 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

how does your table structured? when you said you want to create an automatically populated column for manager name, where do you store all the manager name? is it in the same tabel? So you have these rows are column?

Name of the resource, Id of the manager, name of manager....

then you already locked up each resource with one manager. Maybe I mis understood still, can you elaborate what you need to achieve?

Was this reply helpful? Yes No
todorovicdijana 15 on at

Like (0)

Report
Copy link

Link copied!

Yes, those are columns in the same table, ,Id of resource, Id of manager and Name of the resource, and table is populated from external source. True, each resource has the manager associated with him, in the same row, which at the moment is id of manager. What i want is to have a name of manager there, in the same row,, so i am creating a column manager name, and hoping there is a way to have it filled automatically (what i meant when said populated), without me comparing what is the name of resource that has an id of manager in that row and fill it manually

Was this reply helpful? Yes No
steeevid 333 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

where do you store manager name? In order to automatic populate you have to have a source of manager name.

Was this reply helpful? Yes No
todorovicdijana 15 on at

Like (0)

Report
Copy link

Link copied!

manager is at the same time resource, means, i have resource name column, and manager name is one of those. its the one that corresponds to the id of the manager in that row

Was this reply helpful? Yes No
steeevid 333 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Sorry this sounds still confusing, can you show a screenshot of list of your table columns and where do you want to achieve looking up manager name column?

Was this reply helpful? Yes No