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.

When using the Email option while building a new form I want to use the /Title in the Subject line of the email, but when the email arrives the /Title field includes the Submission number for that for as part of the Title.

How do I just get the Title, no submission number?

Ray

I'm trying to generate a numeric Risk Rating based on two text values that correspond with a numeric value. For example a Likelihood of Rare, Unlikely, Possible etc. Also, we have a Consequence of Critical, Major, Moderate etc. When the two are in a matrix the X and Y values give a Risk Rating. The higher the Likelihood and the higher the Consequence means it's a higher risk. How do I generate a matrix based on two values to produce a single result.

Example below.

The numeric value is probably not needed, even the rating alone will be OK.

Open to any suggestions.

Thanks.

When creating an email template using data from the form, I use the / to get a list of my fields which shows me the correct field names as used in the Label setting (for the Select Box component.)

I have 5 fields that use a numeric value to populate the email with a qty requested for each option. When I type the / I get the correct field names, I select the one I want and then the email designer will show something totally different as a field name (in green). This has now given me three duplicate field names (out of 5), but when I submit the form the workflow runs, sends me an email and lo and behold the values are correct.

Example below:

The values for testing are the values 1 through 5 top to bottom. The fields are NOT supposed to be duplicated.

When the email arrives this is what I get:

Based on the design I should have got 1, 2, 2, 1, 1

Any idea why this is doing it?

Ray

When a Workflow is added to a form it is next to impossible to find which workflow in Power Automate is associated with that form. If I Build the form, then select Workflow it takes me to a new Power Automate screen and in the 'My flows' menu I can see a list of flows but I have no idea which flow is associated with which Form.

In some cases a Flow may be associated with multiple forms. Can we get a view that links a flow with a Form(s) so that I can edit the correct one.

Can the Action Menu have another menu option called Show Linked Workflows (or similar).