Sharepoint List keeps adding one hour to date/time field?
When I submit a new form submission with a concated date/time field, the Sharepoint list time keeps adding one hour to the time. I've tried updating to 24-hour time format but the problem still persists Here's what the question looks like in forms: Any ideas? Thanks, ConorPopulate a SharePoint calendar from Microsoft Forms via Flow
I have an automation where my users can fill out a Microsoft Form and Flow picks up the fields and puts them into a SharePoint calendar. Now when Forms populates the calendar list, it is one day early for every event, I think due to there is no time field in Forms. I'm trying to add a day to the date fields in Flow by using the adddays formula, but I don't know how. Can anyone help me, or think of a better solution?
convert Form to Power Apps
Hi Team, Our End-user created a Microsoft form with a series of questions and a file that she wants to send it out to our external clients who are not part of the organization. The issue here is, with the option of the file upload "Anyone can respond" field is greyed out preventing these links to be opened by our external sender. Is there a resolution for this? if not can these forms be converted to power apps, this way external users can access the form. can I get the steps to perform this or is there an alternative solution? please note: that file is an important part of the questionnaire. regards, Nish
Retrieving a form ID saved in a Sharepoint column to get that form's responses to a flow
Hello everybody, I created a Sharepoint list with 3 columns for 3 IDs from 3 different forms. I have already made a first flow that enters the ID of my first form in the corresponding column and then I insert the second ID of the second form in the second corresponding column. Then I would like to be able on a third flow, recover this second ID in order to obtain the responses of this form knowing that I know the ID of the first form. The problem is that I am unable to harvest the ID of the second column as a parameter so that I can insert it into my "Get Responses" actuator. Is there a solution to my problem? Thank you in advance.Match a Microsoft Form submission to a table in Excel and run the condition if there's a match
Hi I have a Microsoft Form set up where I am requesting a first name, last name, email address and an ID value which is a number for an event I am holding. Only authorized members can attend this meeting, and I authenticate this via the ID value that's captured and look it up according to an Excel spreadsheet I have stored in OneDrive for Business. I want to use Power Automate to do the automatic authentication by taking the ID value from a Form submission, match it to the values in a table in an Excel spreadsheet stored in OneDrive for Business. If the ID matches, Power Automate must send an email to the recipient providing details to the meeting, i.e. the meeting link. If the ID does not match or is not found, the recipient gets an email stating what's the next procedure (a manual verification step - not created in Power Automate). The ID is a numeric value. It's captured as a numeric value on the form. The table has the IDs stored, formatted as "General". I added the following steps: When a new response is submitted Get response details List rows present in a table I specify the ID value from the Form under the "Filter Query" field Apply to each control inserted Select an output from previous steps I choose the ID value from the Excel table. Condition control inserted where the ID value from the Excel table is equal to ID value in the Microsoft Form submission. If yes, send an email with the meeting link. If no, send an email with alternative instructions. End When I test the flow, I get an error at the "List rows present in a table" step. Under "Inputs", I can see the ID value captured under the "Filter Query" field. Under "Outputs", an error is shown. The error is reproduced below: BadRequest Status Code: 400 Headers: Key Value Pragma no-cache x-ms-request-id 55ead164-c257-48e2-94ea-a... Strict-Transport-Security max-age=31536000; includeSub... X-Content-Type-Options nosniff X-Frame-Options DENY Timing-Allow-Origin * x-ms-apihub-cached-response false Cache-Control no-store, no-cache Date Mon, 27 Jul 2020 14:36:37 GMT... Content-Length 500 Content-Type application/json Expires -1 Body: { "status": 400, "message": "The $filter expression must evaluate to a single boolean value.\r\n inner exception: The $filter expression must evaluate to a single boolean value.\r\nclientRequestId: 55ead164-c257-48e2-94ea-a0e8240e9dd1", "error": { "message": "The $filter expression must evaluate to a single boolean value.\r\n inner exception: The $filter expression must evaluate to a single boolean value." }, "source": "excelonline-we.azconn-we.p.azurewebsites.net" } Then the flow stops working after this. Any advice would be appreciated as to why this flow is not working?Create form in sharepoint and data goes to a list
Is it possible to create a form in SharePoint, and that data that's filled out will go to a list. But have the form be smart enough to reference the list to know if an item has already been added. An example would be this if our sales org gets a new client, we want the person who gets the client to fill out all sorts of info. But say they try and do it again, it will stop them and say, "the client has already been added please go here to fill out additional information" (which would be on the list it is sending to)
Disable Forms answers depending on List entries via Flow/Power Automate
Hi @all, I'm trying to create something like a sign in to scheduled dates. Each date has slots for 6 participants. Now I want to send a Forms form to all off them, so they can choose which date they want. The results of the Forms survey are stored in a SharePoint List. BUT if all 6 slots on a date are full the option in Forms for this date should be disabled. Is something like this possible or better made with another solution? 🙂 Greetings
Problem with the flow of invoices
Hi, I created an automated flow which starts and is based on Forms. When our employee adds the customer and order details and clicks Send it's aggregated to the Excel on OneDrive and then all the details are beeing sent to our Accounting department. The problem we are facing is that when an Accounting dept. employee recieves these details - she/he has to respond in another Forms if the details are fine and there is a place to put (upload) that finished Invoice. But at the testing stage (when I gave a link to the starting Forms to our employees) we have noticed that when Accounting dept. employee responds in Forms at "Po przesłaniu nowej odpowiedzi 2" or "Po przesłaniu nowej odpowiedzi 3" if there is more than one Flow awaiting - she/he is not sending the Invoice to the correct employee. It looks like she/he is always answering through the Forms to the NEWEST recieved flow. I guess it could be the problem with ID Key but I am not sure. We need it to work for more than one flow at once. Accounting dept. member responds to the flows once a day (at the end of the day). They have a dedicated e-mailbox to recieve and respond to the flows. This has to work in such a way that the oldest email still answers through the Forms the right person. Now person A, starting the workflow at 12:00, waits for a reply. Another person B is also waiting for a reply at 13:00. The accountant by clicking on the answer for person A will send the answer to person B... How can I fix it? How it looks like in general: Starting flow with Forms -> Getting informations from Forms to Excel -> Sending an email to the Accounting department with all of the informations. At the bottom there are to links to another Forms (one to approve and send an invoice, another to decline and send information about missing/wrong details) Thank you in advance for your help. Pawel
From Forms to SharePoint list using Flow
Hi! I made a very simple form with Forms. The form works like a charm, no problem with that. I would like to store all the responses in a SharePoint list but I just can't get the flow to work reliably. I usually get the flow to work once or maybe even twice, and then nothing. It works and then it stops working and I can't figure out why! I've used Flow before and all the other things I have built seem to work okay. So I wonder if there's just something wrong with the connection between Flow and Forms? Have anyone else experienced the same?
