Join the Team Forms community

Members
Ray Howard
R
Ray Howard
Offline, last seen 4 weeks ago
Joined August 28, 2024

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
R
T

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

4 comments
A
R

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.

5 comments
R
A

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

12 comments
R
E
A

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).