Join the Team Forms community

Updated 2 months ago

Submission Number in PowerBI report tables

At a glance

The community member asked if it is possible to show the form Submission number in a Power BI report, as neither the Forms nor Submissions tables have it as an option. Another community member responded that the submission number will be available in the Official PowerBi template in the next release, and in the meantime, the user can add it manually by adding "tfSubmissionNumber" to the "GetTeamFormsData" function.

RRay Howard

Is it possible to show the form Submission number in a Power BI report. Neither the Forms nor Submissions tables have it as an option.

2 comments

TTeam Forms

Hi Ray,

The submission number will be available in the Official PowerBi template in our next release. For now, you can add it manually by adding "tfSubmissionNumber" to the "GetTeamFormsData" function as shown below.

RRay Howard

Thanks Anthony, works fine.