You’re offline. This is a read only version of the page.
149
I need to re create the below Excel into a table in Dataverse. Any advice what route to go down. Previously I have created basic table but this is like a matrix format.
Are there only ever 2 companies per assessment? If so you can simply make it one table and create fields for the assessment and fields for company1 (c1_impact, c1_speed, etc) and company2 (c2_impact, c2_speed, etc).
if you can have N number of companies per assessment, then you create a Parent ‘Benchmark Assessment’ table and a 1:N relationship to a child ‘Company Assessment’ table with all the fields for 1 company.
if you need to copy the format/style of the excel doc, use a canvas app or PowerBI as Dataverse won’t spit out that exact format.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
