Hi,

Our embedded youtube videos Fullscreen button suddenly stop working. Could we please get assistance?

I'm fairly new to Team Forms. Is it possible to send a copy of a response to the form submitter? If so, how? Note: I use the Email feature to send responses to appropriate staff members.

We’re excited to introduce powerful new updates to the Team Forms Microsoft Power Automate connector, making it even easier to automate your workflows:

✅ Enhanced Workflow Flexibility: The “When a form response is submitted” trigger has been improved! You can now trigger a workflow for any form within your team by leaving the form dropdown empty in the trigger settings. This reduces the number of workflows you need to maintain, allowing a single workflow to handle multiple forms, saving you time and effort.

✅ New Trigger: “When a form response is deleted” – Now, you can take action when a response is removed from a form. Like the updates to the “When a form response is submitted” trigger, this new trigger can be set to fire for a specific form or across all forms within your team, making it easier to manage deletions without needing multiple workflows.

Every time I minimise Teams, it needs to reload every form. Because of this is crashes constantly.

I want to title the sections within the document. I was doing so by creating a text field, putting 'xx' in the Label field, the title I wanted in the Placeholder field, and then clicking 'Hide Label' and 'Disabled'. It works great within the forms app. However, when you transfer it to PDF, it comes up as a blank field. I tried multiple different combinations using the Label and Placeholder fields, and the selections at the bottom such as 'Hide Label', and no matter what I do the best I can get for a section title once I transfer it to PDF, is the title I want with an empty field box below it. Is there any way around this?

We’re excited to announce that Team Forms has expanded its language support for Automatic PDF generation! We’ve added seamless support for Hebrew and Arabic (along with any others), which will now display correctly in generated PDFs without requiring any special configuration. Chinese and Japanese characters will continue to be supported by enabling them in the PDF settings. This update enhances accessibility and ensures that multilingual documents can be created effortlessly. Whether you’re working with global teams or diverse audiences, Team Forms makes PDF generation smoother and more inclusive than ever.

When a user with an apostrophe in their surname submits a form, the responder's name and email fails due to the ' causing an issue.

Example is Bill.O'Reilly@xyz.com

We get Bill.O@#x27;Reilly@xyz.com

Of course the email fails.

Any way to fix this?

Thx.

I want to create cascading drop down menus, but it is for an Employment Agreement, so there will be more information in some fields than just a few words. I would like it to work so that when you select the Job Title, the next field will give you the option of selecting that title's job description, and the following field will provide the key responsibilities of the role. I watched the YouTube tutorial and have it working correctly as far as options, but because the fields are long and narrow, the information under Job Description and Key Responsibilities is being cut off and is not readable in full.

Is there a way to change the size of the SharePoint Data fields, OR a way to make specific text populate into a Text Area when an option is selected in a SharePoint Data field above it? As opposed to three SharePoint Data fields in a row, could I do a SharePoint Data field for the Job Title, that makes the Job Description and Key Responsibilities populate in a Text Area below it?

Thank you!

I have this form and I want my form responder to respond to it only if the time is between 2 pm to 7 am. So I put the fields in a panel and used this JavaScript to conditionally show the panel.

const currentTime = moment();
const startTime = moment().set({hour: 13, minute: 0}); 
const endTime = moment().set({hour: 6, minute: 0}); 

show = currentTime.isBetween(startTime, endTime);

It's currently 2:31 PM here but the panel is still not showing.

I have a text field that I'm actually using as a field where respondents input their email. I want to put a validation that checks if the inputted text ends with our company domain. How can this be achieved?

We have an issue with the way that Team Forms handles draft form submissions. Users are opening forms and not updating, or doing minimal updates in the forms. They then leave the update of the form for a period (sometimes days) and it captures the original data (including the date) on the form. Can there be an option on a form, that can be turned on or off at teh form level, to warn users that they are opening a previously "draft" form? I have spoken to a few of our users and they are getting frustrated with this.

We’re excited to announce that Team Forms now integrates SharePoint’s powerful version history functionality directly into our app, making it easier than ever to manage your forms.

All form templates and responses created in Team Forms are automatically subject to SharePoint’s built-in version control and retention policies, configured by your organization’s IT team. This ensures that you can always:

• Revert to a previous version of a form template.

• Audit changes made over time.

While SharePoint’s version history is robust, its interface can be cumbersome to navigate. That’s why we’ve brought version history management into Team Forms!

With this new feature, you can now:

• View all historic versions of a form template directly in the app.

• Roll back to a previous version with a single click.

• Compare changes between different versions for better transparency and control.

This enhancement streamlines your workflow, giving you the power of SharePoint with the convenience of Team Forms.

I want to set a deadline for my Team Forms, similar to the feature in Microsoft Forms, where users are unable to respond to the form after the specified deadline.

Hi everyone,

I am trying to filter out the options from one SharePoint data component which is inside the data grid component. In my SharePoint data component i have used an excel file where i am displaying numbers lets say from 1 to 30. Moreover, the user can have multiple values in it. For example, the user selected 2, 4 and 6 numbers from first row of data grid component from the SharePoint data component now what i want to achieve is that in the second row of data grid component in the SharePoint data component those three numbers (2, 4, 6) should not be displayed. How do i achieve this any suggestions would be useful.

Many thanks!

It has been two weeks without access to the Teams Forms App within Microsoft Teams. Our company has iPhones through T-Mobile, and no one is able to access the Teams Forms. T-Mobile/Microsoft both say its on the Team Forms end. Has anyone had this problem and were you able to resolve it? Attached is the error message/screen that appears.

Thanks!

The quality of the photos i take with my phone are good when i take them and if i edit them. Once i confirm and upload on a form they decreases in quality quite dramatically. How can i keep original quality or at least better than i am currently getting?

I am trying to calculate the hours between 2 time fields, please see below.

I have been using the following javascript and it's not calculating - can anyone please provide any assistance, or a different fomula

const startDate = moment(data.startTime)
const endDate = moment(data.endTime)

value = startDate.diff(endDate, 'hour')

Hey All,

I have been trying to get email notifications set up for my forms but keep running into the issues of the link not giving access to the user, the link now showing the correct authorizer form, or the email notifications not properly working.

Does anyone have a template on the email portion where it allows a form to be submitted to the authorizer to authorize and then once this is done having a second email that sends to the user who submitted the form notifying them that their form has been approved or denied?

Thank you!

Hey,

Is it possible to change Submission number generation to occur after the form has been submitted. Our current problem is the Submission Numbers are all over the place, we're guessing this is because staff are opening forms but not submitting.

This is creating issues from an auditing and logging point of view

Hi everybody,

I would like to display all items from a sharepoint data inside a datagrid component. It works well.

But I want to edit the 'test' component inside the datagrid.

In this example, the first column comes from the sharepoint data source. when I want to write something in the second column, it doesn’t work. It's impossible to write something. It bugs...

I use this code (logic inside the datagrid component)  and the Redraw On is on 'any change'

 // Create a function

async function updateDataGrid(){

// Get all items from the data-source using its id (replace 'yourDataSourceId' with your actual data source id)

var items = await tf.getDataSource('xxxxxxxxxxxx');

// Apply a filter based on data in the form (adjust the filter condition as needed)

var filteredItems = items.filter(i => i?.competence === 'Bâtiment');

// Use a "Map" to rename the columns from the data source to match the names of field names used in the data-grid

var gridItems = filteredItems.map(i => {

return {
requisitionNumber: i?.id,
items: i?.type_intervention,
preuvePhoto: i?.photo,
echeance : i?.echeance,
batiment : i?.batiment,
etage : i?.etage,
emplacement : i?.emplacement,
tache : i?.tache,
urgence : i?.urgence,
test : ''
};
});

// Set the value of the data-grid component programmatically
instance.root.getComponent('i_batiment').setValue(gridItems);
}

// Invoke the function
updateDataGrid();

Thanks in advance !

It would be great to have permissions based on usernames from selected from a User Component that a user inputs. Right now permissions is pre-determined to whoever has been set by the form builder as per below.

Using a text field component to display a custom text value based on item selected from a dropdown. The value flashes after being selected. See video below

Hi there,

I am facing an issue where i want to update the outstanding quantities dynamically by using two methods, I am not sure on how to go about it, any suggestions would be helpful.
I have a form where a user has to select the purchase number from the list (data from sheet1) where the user can see:
- RequestNo, (like orderID)
- PO number (list where he can select the po number),
- Received date (automatically input when logged in),
- Items (from sheet1)
- Ordered quantity (from sheet1),
- Received quantity (manually type),
- Outstanding quantity (dynamically change)

So, when the form is submitted it will save in sheet2 like this (shown in image):

I want to achieve the result like above in excel sheet which is like that whenever there's new order to be added from form submission it should dynamically look in sheet2 if there's any existing entry of that same po number then it should calculate the outstanding quantities dynamically (previous outstanding quantity - current received quantity).

For now I am at that stage where i can display the latest outstanding quantities from sheet2 but i am facing an issue if the entry doesn't exist then it is showing on the form and excel like:

(Which is displaying wrong as it should calculate outstanding quantity normally with the subtraction of ordered qty - received qty.)

And, if i use calculate value under data tab in outstanding qty as:
value = row.orderedQty - row.receivedQty

then it will display correctly on form for first entry as:

But, let's say i received the same items of same po number after two weeks, then on form its displaying as:

As you can see that, the fourth row should display: 1, instead of displaying: 3

How can i achieve the result of first table so that whenever there's no entry it should look in excel sheet2 then automatically subtract normally for the first entry from form submission but if a user receives the delivery for the second time of the same po number then it should look in sheet2 and display the latest previous outstanding qty in sheet2 on the form and accordingly calculate the value of it when items were received for the second time.

How do i make the label of a table display on form. Like a Survey does

I have created three forms which are linked to one another, in which first form takes the input of supplier name and based on selected supplier, the user can select the items sold by that particular supplier For eg, Dell (supplier) sells Mouse, keyboard, Monitor, Laptop (Items sold by dell supplier which will be shown in items list) and when the user submits it'll add entry to excel as:

OrderID | Supplier | Items ordered | Quantity
01 | Dell | ["Mouse","Keyboard","Monitor","Laptop"] | [2,3,1,5]

Now in second form there is orderID drop down list and when the user selects the ID - 1, he can input the purchase order number, which will shown in same excel sheet and adds the purchase number as:

OrderID | Supplier | Items ordered | Quantity | Purchase Number
01 | Dell | ["Mouse","Keyboard","Monitor","Laptop"] | [2,3,1,5] | PN-0001

My query is that====>Now, In my last form i want to show these items in separate rows for eg, the user ordered 2-mouse, 3-keyboard, 1-monitor, 5-laptop SO, i want to display these as:

OrderID | Supplier | Items ordered | Quantity | Purchase Number
01 | Dell | "Mouse" | 2 | PN-0001
01 | Dell | "Keyboard" | 3 | PN-0001
01 | Dell | "Monitor" | 1 | PN-0001
01 | Dell | "Laptop" | 5 | PN-0001

Because, based on the above table in excel in third form i have third input field where i have to write the received quantity like how much quantity of items the user received and corresponding to the items it should display the input field.