File created from SharePoint list via Power Automate cannot be opened
I have a Power Automate flow that is supposed run once a day at 7:45AM EST. Then Get items from a SharePoint list where the filter query is: ReminderOne column is less than or equal to the date when the flow was triggered and field_4 (Date and Time) is null. Next it should get the following columns and values from Get items: Site (Single line of text), PageURL (Single line of text), the email from Requestor (Person or Group with multi-select disabled), the emails from SiteOwners (Person or Group with multi-select enabled), and field_3 (Date and Time). From the values of those columns it should create an Excel file in https://xxx.com/teams/xxx/Shared%20Documents/xxx/xxx/. Lastly it should take that Excel file and attach it to an email- not as a link but as a file to download. The flow runs successfully, however, when I try to open the file in the folder its in or in the email attachment, I get an error that the file can't be opened.
Help!! – Forms to Excel with Power Automate
Hello! I have a group of students who have to take three different exams in order to use school resources. Students who pass each of the tests fill out a form ( Form A, Form B and Form C) after each one of them, acknowledging they've completed the specific course. I have an Excel Sheet automatically generated from the responses gathered in Form A (email, name, acknowledgement acceptance) and would like to add two more columns to display their responses to the acceptance question in Form B & C so I can see in a singular table which of the three resources they are authorized for. As you can see in the image below, I have been able to get as far as creating a new column to gather Form B responses (Power Automate>When a response is submitted>Get response details>Get User profile>Add row into a table) but I cannot get them on the same line as the responses by the same user in Form A. Could anyone give me any pointers as to how I can get this fixed? Thank you so much!!Request for Information on Rate Limits, Pagination, and Data Generation for Microsoft Message Trace
I am implementing an Integration with Microsoft O365 Reporting API and wanted some support regarding the Microsoft Message Trace API, specifically concerning the following aspects: Rate Limits: Can someone please provide detailed information on the current rate limits applicable to the Message Trace API? Understanding these limits is crucial for optimizing our API usage and ensuring we stay within the allowed thresholds. Pagination Approach: I would appreciate guidance on the recommended pagination approach when querying the API. Specifically, we'd like to know how to handle large datasets efficiently and whether there are best practices or built-in mechanisms for managing pagination in API responses. I am able to hit the API and hence, getting some response but unable to retrieve the Next page or any similar parameter which will allow me navigate to the next page. Generating Additional Data for Reporting: Lastly, I am exploring ways to generate more comprehensive data through the API for reporting purposes. Could anyone advise on any available options or techniques to retrieve a broader range of data points or more detailed logs from the API? Retention Policy: would like to know about the Retention policy of this API. Let me know if it varies from account level permissions/access? Someone's assistance is greatly appreciated, as it will help me ensure that the integration with Message Trace API is both efficient and compliant with best practices. Reference links: https://learn.microsoft.com/en-us/previous-versions/office/developer/o365-enterprise-developers/jj984335%28v%3doffice.15%29 API Link: https://reports.office365.com/ecp/reportingwebservice/reporting.svc/MessageTrace[?ODATA%20options] Thank you in advance for your support.
import caldav/ics calendar
Hi, I am using Nextcloud with a calendar. So, there are two ways to share this calendar: With a .ics subscription or with caldav. So, I tried adding the calendar (from internet) to outlook 365 (web version) using caldav. But, there I get an error "could not be imported". Maybe because of lack of authentication for caldav? Then, I tried importing the .ics subscription link. This works! But: The calendar items are not synced to the calendar app in MS Teams! Any ideas how to get this work? Thanks in advance!
how to comeback to a old version even with a synchronization issue.
Hello, I have been using OneNote Online for a while now. Some times, I noticed that the version that appeared was an old version. But the correct version eventually reappeared. But, last time, I didn't notice there was a synchronization issue, and I made a modification on the wrong version, the poorly synchronized version. This modification bug the page and I had to create a new page (I gave it the same title) where I copied-pasted the content of the bug page. But the bug page is the old version version, not a recent. Obviously, I delete the bug page after. Even If I can restore the delete page, I can't retrieve the recent versions. What I mean is that I know OneNote saves pages regulary, but because of the synchronization issue, I no longer have access to the recent versions of the page. The most recent version I have access to is the one where I made the modification. I would like to point out that I have already posted a request here : https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-comeback-to-a-old-version-even-with-a/49a29505-46c6-48d8-8374-fb4842229da8 But, the support team asked me to submit an additional one here. I will add some information that the support team has often asked me. In the 2 pictures, we can see how my OneNote files are stored (I have hidden some parts for the second picture). For the synchronization issue, the support team told me that it was bug that it will be fixed in the future. My issue here is : can I retrieve my lost data, and if so, how ?Removing optional hyphen in Word
Hi, I had the following problem in Word. I had a document which I did not create, and I had to format it. Once I turned on "Show Formatting Symbols," I noticed these "optional hyphen" symbols which were so annoying. Here is the picture: After trying to remove them unsuccessfully, I searched a lot on the internet and could not find a thing. I have solved this by going to Find and Replace (Ctrl + H), expanding More options, and in the Special menu, I clicked on Optional Hyphen. Look at the picture: It finally worked! I just wanted to share this in case someone needs it. Best regards, Miloš KozomaraHow to integrate Office 365 to Web App for document edit
Hi, I want to edit document from my web app using Office 365, Any one can explain how to do that I have searched around 1 week not yet got correct article User Scenario: - 3 Excel files uploaded in web app, As an user I want to edit those excel files from online itself without download to my local.
