Importing dates from Excel into Sharepoint list
Hi, I've tried various forums for answers to this issue but none have succeeded. I have an extensive spreadsheet that I want to import a Sharepoint list. The issue is the date column. irrespective of how I format the date in Excel it does not conform to the date/time format in Sharepoint. The error message (note the error varies depending on how I format in excel) I am sure there should be a simple function fix but I suspect I don't have sufficient knowledge to understand potential solutions offered on other forums. any help/advice gratefully received.
How do you update a SharePoint page with Microsoft Form submissions kept in an Excel file?
I am working on a SharePoint site used to track Change Requests. I am pretty new to using Microsoft services for this kind of use case, but after some struggles, I discovered that I can use a Microsoft Form to track new Change Requests on an Excel sheet that is located within the SharePoint directories. The issue that I am experiencing is that I cannot pull live data from the Excel file. My objective is to have a SharePoint page named "Schedule of Change" which lists the Change Requests from the excel file on the SharePoint site itself. For example, if a user fills out the Microsoft form and a new row with this submission data is added to the excel file, the SharePoint site should also see this and add it to the Schedule of Change page. In other words, I want the content on the Schedule of Change page to stay up to date with the content of the excel file. I am pretty open to how the info is presented. Ideally, I would like to have a table on the Schedule of Change page where each change request is a new row, but if this isn't possible, then I will take what I can get. What I've Tried I attempted to create a list from an excel file, however it only pulled the data once upon list creation, and it would not update when any new change requests were made. I also researched this issue on the Microsoft forum and found some pages that recommend creating an automation, but the instructions didn't match what I saw and I wasn't able to automate this successfully. Can anyone provide instructions on how to read excel rows and add them to a SharePoint page even as new data comes into the excel form?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?Sharepoint list creation from Excel breaks my dates
I am trying to create a list on Sharepoint to be used in Power Automate. My Excel list has the dates column formatted as date only and as yyyy/mm/dd: When I create a new Sharepoint list from Excel, the import screen shows the dates correctly: But when the list is created, it minuses one day from the day of each date: So when I go to column settings and change to date only, I am still missing a day on each date. Why is this happening? Even if I format my Excel dates as M/d/yyyy h:mm AM/PM which is how it appears in the sharepoint list, it still breaks and removes a day. A workaround is to create a calculated column with this formula: =DATE(YEAR(Date),MONTH(Date),DAY(Date)+1) but why should I have to do this?
Get email addresses from Excel Attachment and Send emails
Pls need help creating a Power Automate flow: When I receive a certain email (Outlook 365) with an Excel attachment, get the email addresses from column D in the Excel attachment, then forward the original email I received to that list of email addresses.
Updating Planner task description from list in Excel
I have successfully created a flow that allows me to create tasks in Planner with customised checklists for the type of task. E.g. Project Title1 - Project Task1 - Checklist Item 1 - Checklist Item 2 - Checklist Item 3 I would like to extend on this to update the decription of the task based on the Project Task 1 variable in the table.Need help retrieving MS Form response and insert it into a cell in .xlsx
Hi MS Power Automate Specialists, Experts and Gurus, May I trouble you to help me a little bit with this question? I created an MS Form to get a text response and then I would like to insert this text into E2 cell and send me an email with this excel file attached. Basically, I can just create new .xlsx in my Onedrive/Sharepoint and use create a table then update row actions in the flow, but I do not want to place the file temporarily to any place, I need it to be sent to my email directly. By doing so, I use Compose action to get the file content and then use the Send an email action to send that file. but the problem is the .xlsx created and attached in the email cannot be open due to a file error. I suppose there's something wrong with the file content in the Compose action { "$content-type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "$content": [{ "cms_item_id": "120978", "data_version": "A", "translated": "TRUE", "language_id": "6", "data": "@{outputs('Get_response_details')?['body/r1c6600e386c648b3a04e9bce374cce47']}", "record_status": "1", "created_by": "", "created_when": "", "last_modified_by": "", "last_modified_when": "" }] } Could you please help verify and suggest how I should fix the code to make this flow work? Thank you in advance PjuvishLookup Excel Value in SharePoint List and Update Excel Table
Hello, I have a SharePoint list with the following fields; EmployeeID, Surname and First Name. I also have an empty table with the following columns on Excel Desktop; EmployeeID Surname and First Name. When I enter a value in the Employee ID column, can I get the steps below to play out? 1. The Employee ID value gets looked up in the SharePoint List from the Employee ID field, then gets the employee's corresponding Surname and First Name. 2. Takes the corresponding values from the SharePoint List and updates the Surname and First Name columns in the Excel table. Many thanks.
Create a Custom Worksheet From a Form Response Using Flow
I am trying to create a workflow where when a customer is interested in our services and filled out an inquiry form, their information is placed in a new excel workbook or worksheet with dynamic content (like customer name) as the workbook/sheet title and then input the information to view in a portrait summary rather than the typical table format. This is so we can give the snapshot to the next person to review before reaching back out to connect with the inquiring customers. We then use this document to track other things from outside medical entities that are not things we will track in the table format. I'm having trouble creating this automation within flow. Could anyone be able to help me create this flow? Thank you!
