Unanswered

How to use column from another table in formula field of Dataverse?

(1) Share

Report

Posted on by javeriatabassum

I am creating a new Formula type column (Total Seeds) in a table and want to use column (No of Seeds) from another table in the formula but unable to use it.
How to write formula for another table's column?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (2)

Report

Hi @javeriatabassum

The related table must be in a Many:1 relationship (i.e. a Lookup column on your current table). See example here where I am referencing the Owning User and selecting a field from that table:

Only specific column types can be created (https://learn.microsoft.com/en-us/power-apps/teams/formula-columns#data-types)

Was this reply helpful? Yes No
javeriatabassum 7 on at

Like (0)

Report

@dpoggemann Thanks, it works.

Was this reply helpful? Yes No
55552 674 on at

Like (0)

Report

I have a situation in Dataverse where I need a calculated column on Table A, where Table A is the "One" and Table B is the "Many." Table A has 5 records with 5 different Work Order IDs, and Table B has over 100 records, with those same Work Order IDs spread among many records, some records have the same ID. For each Work Order in Table A, I want a column to filter table B to the current record's Work Order, then sum up the values from a Completed column (numeric, just 0 or 1 values) in Table B. Is this possible?

Was this reply helpful? Yes No