Using Collections

Usually it is necessary to store the data in temporary storage while calculation or processing. Then, the processed data is transmitted to the data source by saving permanently as ultimate data. Temporary records are stored in the variable tables called Collection. In this method, the data is calculated, processed and quickly written to the cache memory on the app screen only.

These tables are created virtually. Tables and columns can be named however wanted. Columns’ data types are automatically shaped based on the data they contain or the data source that will be saved tı later.

The Collect formula is used to create the collection tables. It is written as (table name ; { columns}) like below:

Collect(name_of_table;
{ column1:   textbox1.Text;
column2:   textbox2.Text;
column3:   textbox3.Text    } )

For example, you can write this formula into the OnSelect property of the SAVE button of OnTimerStart/OnTimerEnd property of the timer.

Using Collections

The personnel records will be written on collection in the screen of the image you see. 4 textboxes, 4 labels, button and gallery items have been used in this screen.

Item names are frequently used in formulas. So, the functional items in the screen should be named based on what they do or the data they contain.

Textbox names are: txt_name, txt_surname, txt_mail, txt_department

The formula below has been written into the OnSelect property of the SAVE button for the data entered in textboxes to be written to the Collection table.

*Table and columns can be named as desired.

Collect( Personnel;
{
P_name:    txt_name.Text;
P_surname:    txt_surname.Text;
P_mail:    txt_mail.Text;
P_department:    txt_department.Text   } )

When you click the save button, the data will be transmitted to the collection in seconds.

How to View Collection Data

All collections and their contents can be analyzed on a single screen with the Collections button in the View tab.

Click the gallery item to view the data in lists and choose the related Collection in the screen that opens up.

For the older versions, you can choose in the Data Source field in the Properties Window. Or you can execute the same action why writing the table name into the Items property of the gallery through formula bar.

To reset the textboxes after clicking the save button, the Reset() function is used.

*;; is used in actions that need to be executed successively.

Collect( Personnel;
{
P_name:    txt_name.Text;
P_surname:    txt_surname.Text;
P_mail:    txt_mail.Text;
P_department:    txt_department.Text   } );;

Reset(txt_name);;
Reset(txt_surname);;
Reset(txt_mail);;
Reset(txt_department)

 

Send Mass E-mails with Power Automate

You can send the mails with custom subject and content in which you address people specially in cases like congratulating, events, special day celebrations. This is something that especially the HR needs.

This way, you don’t deal with sending mails one by one. You only need to indicate the mail list and details.

Create a Table

Open en Excel in OneDrive. Add a Table from the Insert tab.

Write Mail, Name Surname and mail details into the columns of this table like below.

Each row of this table will be sent as separate e-mails by the flow.

Flow Process with Power Automate

Start a new blank flow.

After the data in the table is filled, flow will be run by being triggered individually. For this reason, start the flow with Manually trigger a flow.

In the next step, add Excel for Business (List rows present in a table) to be able to add the data in the Excel table. Add the table you’ve just created into this item.

In the next step, add Outlook (Send an e-mail).

In this step, the columns of the Excel table is added to the related fields. With you choosing the Excel fields (mail, name, etc.) the Apply to each item will be added to the flow automatically. An event will be created for each row in the Excel file thanks to the Apply to each item.

 

After filling the related fields, name the flow on top left corner. For example: Send Mails to a Certain List. You can save and close the flow on top right corner.

You can verify the data in the Excel table and run the flow.

You can take a look at here for the Power Automate Outlook Connector.

Send Calendar to a Guest List with Power Automate

You can send meeting calendars with customized data like addressing each person, event content and location for all your event invitations through Power Automate.

This way, you don’t have to deal with creating calendars one by one. You only need to indicate the guest list and event details.

Create a Table

Open en Excel in OneDrive. Add a Table from the Insert tab.

Write Mail, Name Surname and mail details into the columns of this table like below.

For each row of this table, e-mails will be sent separately by the flow.

The event date and hour was written as 2020-03-23T13:00:00 in order for it to be in the format Power Automate expects. The time format is 24-hours and the event will be created for the exact hour you determine.

Flow Process with Power Automate

Start a new blank flow.

After the data in the table is filled, flow will be run by being triggered individually. For this reason, start the flow with Manually trigger a flow.

In the next step, add Excel for Business (List rows present in a table) to be able to add the data in the Excel table. Add the table you’ve just created into this item.

In the next step, add Outlook (Send an e-mail).

In this step, the columns of the Excel table is added to the related fields. With you choosing the Excel fields (mail, name, etc.) the Apply to each item will be added to the flow automatically. An event will be created for each row in the Excel file thanks to the Apply to each item.

 

After filling the related fields, name the flow on top left corner. For example: Send Mails to a Certain List. You can save and close the flow on top right corner.

You can verify the data in the Excel table and run the flow.

 

You can take a look at this link for the Power Automate Outlook Connector.

Send E-Mails with Attachments Weekly with Power Automate

Do you send the latest version of the excel file on which you work with your team to your manager? Spare 10 minutes of your time now and create your own flow with Power Automate and send your e-mails with Excel attachments to your manager automatically every week at any hour your want.

When you want to create a flow, you start off with an action (trigger). The flow we will create needs to be run automatically every week, so we will start the flow with the Recurrence(Schedule) trigger.
*If you want, you can do monthly, daily, hourly controls.

In the next step, we need to indicate the location of the file that we want to send as an attachment to the flow. Thus, we need to add the related connector (for example: OneDrive) to the action flow. This way, the file we want to send with mail attachment will be accessed.

Actions are very short and simple. You can follow the steps below and create the flow quickly.

Power Automate Steps

  • Recurrence(Schedule) -> For weekly control
  • OneDrive(Get File Content)->
  • (List Files in Folder)-> To get the data there
  • To be able to choose the one we want among the files we have called Add Condition- > (We get the control of the file we want to call by writing [Name without Extension=ExcelName] through Name without Extension.
  • This action brings the apply to each command to the screen automatically ->
    Power Automate Uygulama Adımları 
  • If the condition is met, to send the mail: we need to add the content coming from OneDrive to the attachments content field in the Advanced Options in Outlook (Send an e-mail). Also, we need to fill in the attachments name field.
    mail atma işlemi

You can send the latest version of your Excel file in Outlook mail attachment with Recurrence(Schedule) control every week by following the steps above.

Conditional Formatting Lists

You can design lists with a condition with the If Formula in the gallery. It is possible to control a lot of features of the objects like color, look, size and place with these conditions. You can authorize based on person/department , hide/show buttons on the screen and highlight status in tracking processes.

Designing Lists with a Condition

In this example, items indicated with colors depending on the information they contain. While all the items of the “Education” department are indicated with purple, the Sales department is displayed with Grey.

ThisItem word is used to individually evaluate each item in the gallery. This way, it is possible to access the data of a certain row among the items.

While registering, people enter their names and surnames separately. And the & concatenation operator is used to write the name and surname next to each other.

ThisItem.P_name & ” ” & ThisItem.P_surname

Adding a Condition

An empty Label is added to the gallery and placed on the left of the gallery to highlight the items.

If(ThisItem.P_departman=”Education”;Purple; Gray) is written into the Fill property of the Label.

With this syntax, each row in the gallery will be evaluated one by one and the department info will be checked. If the department is Education, it will be displayed with Purple. If it is another department, it will be displayed with Grey.

As well as you can write the color as Purple, Red, Blue; you can also write it through the RGB codes.

When you want to use a special color code, the RGBA() function is used.
This function is written as RGBA(255; 255 ; 255 ; 1) as well. The last parameter of the formula gets a value between 0 and 1 and affects the transparency of the color.

You can click here for the other Power Apps articles.

You can click here for the details of the use of the If function.

Office Insider – What Happened in July?

NEW FEATURES/FIXES

 

You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻  Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of July.

 

July 06, 2020

 

outlook new iconOutlook

Create polls in email quickly and easily

Easily create a poll, collect votes, and view results within an email.

Learn more

New room finder

Search for conference rooms by different capabilities.

Learn more

Notable fixes

  • We fixed an issue where Outlook would hang if there were over 130 recipients on the To line, and we also improved the performance of rendering the text.
  • We fixed an issue in the To Do Bar where events that spanned more than two days displayed the same end time for all subsequent days.
  • We fixed an issue that caused users of Outlook to see their message list stop updating for several minutes after using shared calendars.

excel new iconExcel

Notable fixes

  • We fixed an issue where data model tables created in certain versions of Excel could not be seen in ‘Table Preview’ even though the query associated with the table had not been edited.
  • We fixed an issue where disabling Ignore Relative/Absolute references in the Define Name Apply Names dialog would cause formulas not to work.
  • We fixed an issue where clearing an advanced data filter could lose table formatting.
  • We fixed an issue where the full path of an embedded PDF document would show in the document caption rather than just the filename.
  • We fixed an issue where after disabling the Wolfram cloud connector and then saving and re-opening an Excel workbook could result in a crash.
  • We fixed an issue where booting Excel with the Solver add-in enabled would result in a crash.

PowerPoint

Notable fixes

  • We fixed an issue where pasting HTML to a text area on a slide would instead get pasted into a text box created at the top of the slide.
  • We fixed an issue where selecting all slides in Presenter View, then exiting Presenter View using Alt+Tab and returning to the slide show, and clicking ‘End Show’ would result in an unhandled exception.

word new iconWord

Notable fixes

  • We fixed an issue during co-authoring mode when there is a merge conflict, and the user has already chosen to discard changes. We no longer display the option to save or discard changes.
  • We fixed an issue that, when attempting to save a file containing a macro under a new name, would cause it to be saved with a .docx extension and the filename WRO0004.docx regardless of what the user entered, which rendered the document unusable.

msproject new iconProject

Notable fixes

  • We fixed an issue where Project may crash when opening certain XML files.
  • We fixed an issue where you couldn’t open a Project file from a SharePoint document library if the library were in modern mode.
  • We fixed an issue where projects couldn’t be opened in the Project desktop client from the Project Web App if the URL ended in .com.

July 10, 2020

 

word new iconWord

Notable fixes

  • We fixed an issue where Word would stop responding after pasting some text and an image in a comments box.
  • We fixed an issue where the New comment button would be disabled after deleting the last comment.

outlook new iconOutlook

Notable fixes

  • We fixed an issue where the Allow Forwarding option was missing from the shared calendar meeting Response Options if Download Shared folder was not checked.
  • We fixed an issue that would display the print button in a disabled state even though the user had the appropriate print permissions.

msproject new iconProject

Notable fixes

  • We fixed an issue where if you tried to save a PDF/XPS from Project to a SharePoint document library, nothing would happen.

 

July 15, 2020

 

Excel

Sheet View

You can now sort and filter your Excel file while collaborating with others with Sheet View. This new feature prevents you from being impacted by other user’s sorts and filters while coauthoring the document.

Learn more >

LET – Names in formulas for Excel

The LET function allows you to name, and then use a calculation or value in your formulas, and increase both readability (by giving context to others) and performance (by reducing the number of times an expression is calculated). It’s names but on a formula level.

Learn more >

Create a PivotTable from Power BI datasets

You can create PivotTables in Excel that are connected to datasets stored in Power BI with a few clicks. Doing this allows you get the best of both PivotTables and Power BI.

Learn more >

Speedy SUMIFS

Have you ever used SUMIFS, AVERAGEIFS, COUNTIFS, MAXIFS, and MINIFS as well as their singular counterparts SUMIF, AVERAGEIF, COUNTIF, MAXIF, and MINIF to aggregate lots of data?  In this update of Excel, you’ll notice these calculations are noticeably faster.

These functions now create an internal cached index for the column range being searched in each expression. This cached index is reused in any subsequent aggregations that are pulling from the same range. The effect is dramatic: For example calculating 1200 SUMIFS, AVERAGEIFS, and COUNTIFS formulas aggregating data from 1 million cells on a 4 core 2 GHz CPU that took 20 seconds to calculate using Excel 2010, now takes 8 seconds only, on Excel M365 2006.

PowerPoint

Faster playback comes to Microsoft Stream videos

Microsoft Stream lets people in your organization upload, view, and share videos securely. You can share recordings of classes, meetings, presentations, training sessions, or other videos that your team needs. We previously enabled Stream as one of the supported online video sources in PowerPoint. Over the last few months, we’ve made significant performance improvements to the video playback experience. Now you’ll experience faster playback of Stream videos in your PowerPoint presentations.

Outlook

Create polls in email quickly and easily

Easily create a poll, collect votes, and view results within an email.

Learn more>

Quickly reopen items from previous session

We added an option to quickly reopen items from a previous Outlook session. Whether Outlook crashes or you close it, you’ll now be able to quickly relaunch items when you reopen the app. This feature is on by default. To turn it off, go to Options > General > Start up Options.

Learn more>

Disable @ mentions

Do you find the @ mention picker more annoying than useful? Now you can turn it off. Find the option under the new checkbox under File > Options > Mail > Send Messages in Outlook.

Transfer Outlook settings automatically

Outlook will now store/retrieve settings from the cloud, so when you set up a new Windows device, your settings will be loaded automatically based on your Office identity.

Store your signatures in the cloud

Signatures now follow your account across Windows devices. Set up your account once, and new installations of Outlook will have your signatures.

 

 

July 17, 2020

excel new iconExcel

Notables fixes

  • We fixed an issue where any time a pivot chart with hidden leader lines was saved and reopened, the leader lines would become visible.
  • We fixed an issue where charts were not always updated as expected when “ForceFullCalculation” was enabled via VBA for the workbook.

word new iconWord

Notable fixes

  • We fixed an issue where the Show Markup command was disabled when the focus was on a comment text box.
  • We fixed an issue where the Editor command was disabled when the focus was on a comment text box.
  • We fixed an issue in custom XML that state of comments may be lost when opening the document.

outlook new iconOutlook

Notable fixes

  • We fixed an issue around creating multiple profiles in Outlook from the same email domain.
  • We fixed an issue that caused the lock icon to fail to display in the header of S/MIME encrypted messages.
  • We fixed an issue that caused attachments to get stripped from S/MIME messages when sending as unencrypted.
  • We fixed an issue that caused users to be unable to save OneDrive attachments from outside their tenant to their local computer when selecting the Save option on the security dialog.
  • We fixed an issue that cause recipients to be unable to save rights protected messages even when the save as permission was granted by the sender.
  • We fixed an issue that caused plain text S/MIME messages to become garbled when sending.
  • We fixed an issue that caused attachments to become corrupted when sending an S/MIME email unencrypted.
  • We fixed an issue that caused the labels for some Advanced Search options to be truncated in some languages.

msproject new iconProject

Notable fixes

  • We fixed an issue where the tasks listed in the Task Board view were not in sync with those in the Assign Resources dialog.
  • We fixed an issue where if you copied and pasted a task that had multiple dependencies, not all dependencies were copied correctly.

Office

Notable fixes

  • We fixed an issue where after the user opened a new app window from the taskbar and created a new blank document, additional files were created.
  • We fixed an issue where if a user was editing a document but had lost permissions, we were not notifying the user that they had to re-authenticate.

 

July 24, 2020

Visio

Create charts with data in worksheet

Visio Data Visualizer can help users convert their excel data into high quality flowcharts, swim line diagrams, and org charts. These diagrams can be viewed in Visio, downloaded as images, printed, etc. They can also be opened in Visio for richer editing capabilities.

Learn more >

word new iconWord

Notable fixes

  • We fixed an issue where an occasional hang occurred while opening HTML files.
  • We fixed an issue where the Specific People option for Track Changes was disabled.
  • We fixed an issue where the placeholder text in the Search edit box would overflow if the application window was resized to a small dimension.

OneNote

Notable fixes

  • We fixed an issue where the placeholder text in the Search edit box would overflow if the application window was resized to a small dimension.

July 31, 2020

 

Excel, PowerPoint, Word and Outlook

Insert Apple photos into Office easily

We’re happy to announce inserting Apple photos into Office is easier than ever. You can now insert pictures taken with your iPhone or iPad into Word, Excel, PowerPoint, and Outlook on Windows! We had heard from many of you that converting these files was too time consuming, so we’ve simplified the process.

Learn more >

Office’e kolayca fotoğraf eklemeyi gösteren resim.

 

Excel, PowerPoint, Word

Notable fixes

  • We fixed an issue where a copy of an image with a radial gradient fill did not match the original.

Excel

Notable fixes

  • We fixed an issue where if the order of a chart series was changed, the corresponding checkbox aligned with the series was not reordered along with the series.

PowerPoint

Notable fixes

  • We fixed an issue where the Forms button in PowerPoint did not allow the creation of Forms when access to the Office Store was not permitted.

Word

Notable fixes

  • We fixed an issue where if a comment was added to track a change, the revisions pane would unexpectedly open.
  • We fixed an issue where links to documents were not being inserted to the comments box via the Insert > Link dropdown.
  • We fixed an issue where the hyperlink count in the VBA hyperlinks collection was not iterating correctly after adding an image containing a hyperlink.

Outlook

Notable fixes

  • We fixed an issue that caused users to be unable to add a signature when replying to a digitally rights managed message from an inspector window when the user did not have Owner permissions on the message being replied to.
  • We fixed an issue that was causing Outlook to fail to display line breaks properly in markdown content.

Access

Notable fixes

  • We fixed an issue where trying to run certain queries have previously produced the error message “Query is too complex.”

Project

Notable fixes 

  • We fixed an issue where for a SharePoint tasks list, the ribbon buttons on the second tab may be disabled.

 

We compiled all the new features and fixes in July in Office insider. Hope to see you in our other articles, bye bye. 🙋🏻‍♂️
You can share this article with your friends and family to help them get information about Office insider updates released in the month of July. 👍🏻 

Office Insider – What happened in August?

NEW FEATURES/FIXES

 

You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻  Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of August.

 

📅August 07, 2020

 

PowerPoint 

Notable fixes

  • We fixed an issue where users were seeing the ribbon/title bar not being displayed under certain conditions.

outlook new iconOutlook

Notable fixes

  • We fixed an issue where the user account attributes in Active Directory for “otherTelephone” and “otherHomePhone” were not mapped to the corresponding Outlook LDAP attributes.

 

 

📅August 11, 2020

 

word new iconWord

Explore modern comments

Add comments to objects, @mention colleagues, and resolve comment threads for a better collaboration experience.

Word’de modern açıklama ekleme

Learn more > 

 

outlook new iconOutlook

Delete messages

Delete messages and conversations in CML view.

 

📅August 14, 2020

 

Excel

Notable fixes

  • We fixed an issue where if a user typed a formula name including the parenthesis and invoked help via F1, the help topic specific to that formula would not be displayed.
  • We fixed an issue where macro links to buttons were broken after restoring the file to an older version of Excel.

word new iconWord

Notable fixes

  • We fixed an issue where the bullet picture icon didn’t display correctly.

outlook new iconOutlook

Notable fixes

  • We fixed an issue where the Meeting page would continue to be displayed after the user switched tabs from the Meeting page to the Scheduling Assistant page.

 

We compiled all the new features and fixes in August in Office insider. Hope to see you in our other articles, bye bye. 🙋🏻‍♂️
You can share this article with your friends and family to help them get information about Office insider updates released in the month of August. 👍🏻 

Office Insider – What Happened in March?

NEW FEATURES/FIXES

 

You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻  Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of March.

 

March 28, 2020

outlook iconOutlook

Calendar visual refresh

Last year, we brought you a refreshed mail experience, and, this year, it is the calendar’s turn to get a facelift! The updates are fresh but familiar so, as a seasoned Outlook user, you can jump in and be more productive right away.

Learn more.

Takvimde çalışma haftasının resmi.

Notable Fixes

  • This change addresses delays when processing images with malformed or invalid protocol information.
  • This change fixes an issue where the latest changes to draft emails were not being updated.
  • Fixed an issue where right-mouse clicking on a file and using ‘Send to’ would not work.
  • Fixed an issue where if a user had a customized the search path for the Address book, Outlook’s name resolution scope would be limited to the customized path rather than including the Global Address List (GAL).
  • Fixed an issue where within a set of returned search results, sorting the results by Categories would not display the Category colors.

 

PowerPoint iconPowerPoint

Synchronize changes while you are presenting

For years, PowerPoint didn’t allow changes made to slides by others to be displayed while presenting. This ensured that the presenter was in full control of the content being shared. No one could revise slides, either accidentally or maliciously. It also ensured that all of your computer resources were used for slideshow rendering. A concern that is especially important if you are running on a low-end machine.

However, while some presenters may still desire this original design, we’ve heard from others that they are seeking more flexibility. With an increased focus on collaboration and real-time updates, we’re excited to make available the ability to synchronize changes whenever they are made, even when the presentation is in Slide Show mode.

 

How it works

You can synchronize changes in two ways: automatically or manually.

Automatically update slide content

1. Select the Keep Slide Updated check box on the Slide Show tab on the ribbon.

PowerPoint

2. Start the presentation by selecting the appropriate button on the Slide Show tab.

 

Synchronize changes

 

3. Whenever an update to a slide is made and detected, the content is automatically updated and visible in the slide show being presented.

Manually update slide content

1. Clear the Keep Slide Updated check box on the Slide Show tab on the ribbon.

Synchronize changes

 

2. Start the presentation by selecting the appropriate button on the Slide Show tab.

3. Whenever an update to a slide is made and detected, an Update Slides button appears at the top of Presenter View.

 

Synchronize changes

 

4. Click the Update Slides button to manually synchronize the slide content.

word new iconWord

Notable Fixes

  • Fixed an issue where the functionality to post comments was disabled.
  • This change addresses delays when processing images with malformed or invalid protocol information.
  • This change addresses an issue where the account manager would not dispatch messages resulting in a hang with third party applications.
  • This change fixes an issue where the Table of Contents would get updated with heading styles which were not present in the document.
  • Fixed an issue where digital signatures saved in Word documents would be removed when mailing the documents.

 

excel new iconExcel

Notable Fixes

  • This change addresses delays when processing images with malformed or invalid protocol information.

 

msproject new iconProject

Notable fixes

  • Fixed an issue where the ‘ProjectBeforeTaskChange’ Visual Basic Applications (VBA) event did not fire when a user clicked the “Inactivate” button found on the Tasks Ribbon within the Scheduling grouping.
  • If you set predecessor or successor details from within a Form type view, the ProjectBeforeTaskChange Visual Basic Applications (VBA) event didn’t always capture the changes. For example, if you deleted a dependency and clicked OK on the form, the event did not fire. This behavior has been fixed.
  • Fixed an issue where the latest values for the Actual Cost of Work Performed (ACWP) would not be displayed after making a change, such as a date change.
  • Fixed an issue where opening a project using the Most Recently Used (MRU) menu opened the project file with Read/Write access.
  • This change fixes an issue where if you created a manual task with a start date and a time (but no duration), it would be displayed with an incorrect time on the timeline.
  • Fixed an issue where printing a timeline using Hijri calendar would result in a month being skipped or duplicated in the print view.
  • This change addresses an issue where working in Team Planner with GDI objects, could result in the over allocation of GDI objects and create low memory conditions.

 

March 13, 2020  

word new iconWord, excel new iconExcel,PowerPoint new iconPowerPoint andoutlook new iconOutlook

Sensitivity labels

You can now apply a sensitivity label that your organization has configured to prompt you for custom permissions. Learn more

How to Access

If your organization has set up Sensitivity tags in Microsoft Information Protection and enabled users to assign permissions, you can access them. For example, choose Home> Protect, then select the label you want to apply to the document, workbook, presentation, or email.

İzinlere nasıl erişileceğini gösteren Word belgesinin resmi.

outlook new iconOutlook

Notable Fixes

  • Addresses an issue that caused the “Last Modified”; date on a file to be updated when adding an attachment to a mail or saving an attachment from a mail by dragging and dropping it (as opposed to via a menu).
  • Addresses an issue that caused hitting enter in the expanded find pane to fail to start a search, requiring instead that users click on the search button.
  • Fixed an issue where search shows no information about users when the option to “Show user photographs when available” is disabled.

 

word new iconWord

Notable Fixes

  • Fixed an issue when typing or editing a comment and using Ctrl+A would result in selecting text in the canvas instead of selecting text just within the comment card.
  • We fixed an issue in which the alignment of words in a document gets scrambled when tried to edit after printing using Quick Print.
  • We fixed an issue when merging two documents into one document.
  • Fixed an issue where marking revisions involving equations could result in a failure when saving the file.

 

excel new iconExcel

Notable Fixes

  • Fixed a performance issue that users may have experienced when programmatically editing a large range of cells.
  • Fixed a performance issue that occurred when opening csv files with Japanese environments.

 

msproject new iconProject

Notable Fixes

  • Fixed an issue where summary task dates weren’t always getting calculated correctly.
  • Fixed an issue where the OnUndoOrRedo event doesn’t fire without first running the OpenUndoTransaction method.

 

access new iconAccess

Notable Fixes

  • Fixed an issue where international versions of Access were displaying English strings in the user interface.

 

PowerPoint

New Features

Look above.

 

 

March 10, 2020

excel new iconExcel,word new iconWord,PowerPoint andoutlook new iconOutlook

Pick the perfect color

We heard you! Converting Hex colors to RGB values is now a thing of the past. For any property where you can define a color, click the appropriate button in the ribbon (such as the Font Color button) and click More Colors. Then, in the Colors dialog box, click the Custom tab and enter the Hex color value in the Hex box, for example, #0F4C81 or 444.

Learn more

Onaltılık bilgiler alanını gösteren renkli kutu.

excel new iconExcel

Automatically use new data types*

When you type a data value that resembles a possible stock or geographic location, Excel offers to convert it to the appropriate connected data type – Stocks or Geography. Give it a try!

Type in several geographic locations (such as “Seattle”, “London”, or “Tel Aviv”) or stock ticker symbols (such as “MSFT”, “ADBE”, or “AAPL”) in separate cells in a column.

When Convert to Geography or Convert to Stocks appears to the right of the selected cell, click on it.

Verileri dönüştür kutusunun bulunduğu Excel çalışma kitabı.

* This feature is only available in English right now.

outlook new iconOutlook

Drag emails to a group you own

As a group owner, you can now move and copy messages and threads by dragging and dropping them from your mailbox to the groups’ mailbox. Once moved, the content is visible to all the group members, and anyone can read the messages and participate in the conversation.

Learn more

Better search results, faster

The Search experience in Outlook just got a facelift! It is now more reliable, intelligent, and faster than ever. Also, any search entry is now being spell checked and, if errors are detected, helpful suggestions are offered to ensure that you get to the results you’re looking for. Finally, notice that the most relevant search results are presented at the top of the results list, making access faster.

Arama öğelerinin vurgulandığı Outlook posta kutusu resmi.

PowerPoint

Diagrams get connector support

Now, the converted lines between objects are connectors anchored to the shapes.

Ink conversion is also easier than ever with just clicking the Convert your ink button Convert your ink button. Select the converted object again to be able to access other conversion alternates, to make sure the conversion fits your needs. Give it a try! Give it a try!

Sağda siyah bağlayıcı dönüştürme kutusuyla boş beyaz kutular.

 

 

March 6, 2020  

outlook new iconOutlook

Notable fixes 
  • We fixed an issue that was preventing users from attaching a file to their mail messages when that file was open in another application.
  • We fixed an issue where creating a rule with Outlook Web Access did not persist to the Exchange server and resulted in a conflict.
  • We fixed an issue with Outlook that wouldn’t show the drop-down list in the “From” field when using dark mode.

 

word new iconWord

Notable fixes 
  • We fixed an issue that made the User Principal Name (UPN) people case-sensitive, e.g., [email protected] would fail to match [email protected], and prevented users from accessing the SharePoint Sites service.
  • We fixed an issue that prevented the Compare feature from working when the document was protected for editing.

 

PowerPoint

Notable fixes 
  • We fixed an issue that made the User Principal Name (UPN) people case-sensitive, e.g., [email protected] would fail to match [email protected], and prevented users from accessing the SharePoint Sites service.
  • We fixed an issue where the recommended thumbnails flashed when hovering your mouse over the thumbnails. In some cases, this could cause PowerPoint to crash.

 

excel new iconExcel

Notable fixes 
  • We fixed an issue that made the User Principal Name (UPN) people case-sensitive, e.g., [email protected] would fail to match [email protected], and prevented users from accessing the SharePoint Sites service.

 

We compiled all the new features and fixes in March in Office insider. Hope to see you in our other articles, bye bye. 🙋🏻‍♂️
You can share this article with your friends and family to help them get information about Office insider updates released in the month of March. 👍🏻 

Manage Formulas by Creating a Formula Screen

You can have an interactive flow or execute visual actions by creating rules with formulas in application screens.

Usually hide, show, freeze, open to edit or change color, location, size actions are done for the determined objects. You can apply all these controls in all application scenarios easily and flexibly.

Depending on the situation in the application scenario, you can connect objects or actions to department, user mail, location, title, marital status or user choice in multiple-choice actions.You can apply all these controls in all application scenarios easily and flexibly.

In this article, we will be talking about managing the conditions in the screen centrally and formula evaluation duration. And most importantly, we will talk about the importance of executing an action after the formula evaluation duration is done.

What is Formula Evaluation?

Formula evaluation is the test done during the result that is created by the written formula. Depending on the performance of the formula, a certain duration is needed.

Why Does Formula Evaluation Takes Too Long?

Depending on the performance of the formula, duration will be longer or shorter. As the conditions in the screen get more complex; main reasons like using nested formulas, waiting for the control of  different objects related to each other to be complete, and executing an action depending on the respond from the data source can make the duration of formula evaluation longer.

For this reason, it is important to make the formula evaluation run as fast as possible. When the respond of a formula that hasn’t been completely evaluated yet is late, the default value can be accepted as a respond and cause wrong actions.

What if a Formula is not Evaluated?

When the respond of a formula that hasn’t been completely evaluated yet is late, the default value can be accepted as a respond and cause wrong actions. Moving on to the next action before the formula evaluation is complete will cause incorrect results. Which means that even the condition you’ve specified is met, since the respond came later it will look like it is not met. When the conditions don’t work as fast as they are supposed to, it is necessary to do actions and review formulas to manage the screens in which formulas run.

How Should the Formulas Be Managed?

  • An evaluation screen should be created for the formulas.
  • Like we always mention, it is very important to pay attention to naming correctly. The Label in which the formula is evaluated should be named based-on what it does and the outcome it creates.
  • The formula should produce 1 and  as a result when it is used with the If function.
  • Since actions like OnSelect, OnVisible,OnScan are instant actions, the formulas that has a long duration should be calculated outside with labels and be run with 1,0 control only.

Automatic Page Redirect with Timer

Navigate Between Screens

The Navigate function is used to navigate between screens in PowerApps mobile apps. Navigation between screens can be done when the objects are touched/clicked(by the trigger of user) or within a certain period of time(with a timer). In our previous article, we navigated by writing a formula into the OnSelect property of a button. In this article, we will automatically navigate after a while.

Timer

You can use the Timer object for each action that will be executed based on a duration. This way, when the time start or ends, it will be run to be applied on the actions you’ve determined. Timer works here as a trigger (It is a word that we use a lot in our Power Automate articles). It starts for the time to be up and starts the flow.

Timer objects has properties like OnTimerStart, OnTimerEnd, Duration, Repeat, and Reset and actions are executed with these properties. You can take a look at the general features of Timer here.

For example, you can display a text and image that states uploading/saving/wait etc. You can start the page redirect when it’s OnTimerEnd.

When it’s OnTimerStart and OnTimerEnd, you can create a collection. You can create or compare conditions.

Navigate

Let’s make an example where we see a screen with the “Saved successfully” text after saving and when the duration is done we go back to the main page.

Two screens need to be added into the application. Let’s call one of the screens SCR_Mainpage , and SCR_Action_Successful the other.

Timer object will be added to the SCR_Action_Successful page.

Duration property of the Timer objects writes in milliseconds, and this indicates the duration of the times. When you add a timer, standard Duration comes as 60 000 and it indicated 60 seconds. Which means that when the timer start from 1 and end with 60, it will start the actions.

Let’s make the Duration 3000 and get the action done in 3 seconds in order not to wait for too long and to see the results faster.

Duration: 3000

When the specified time of 3 seconds ends, we’ll be redirected to the main page.

OnTimerEnd: Navigate(SCR_Mainpage)

It was set as true in order for the timer to start automatically.

AutoStart: true

After these actions, the timer works actively. If you want, you can hide the time by setting the Visible property as Visible.