You’re offline. This is a read only version of the page.
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?
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?
@dpoggemann Thanks, it works.
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)
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (