Month: September 2020

Power Apps DateAdd Function

Power Apps is a product that allows you to develop mobile apps based on your company’s needs.

While developing your mobile app, you add and manage each one of the items on your screen one by one. It is possible to direct and manage these items from the very basic levels to the advanced levels. In this article, we will be using the DateAdd formula with a few different methods.

Writing Formulas in Power Apps

Power Apps has its own software language and its own functions. Alongside these functions, it also has a lot of functions (date, text, statistics etc.) that are available in Excel. Functions are in use in a general frame without being categorized.

You can manage an item on the screen of your mobile app easily by coding on the formula bar.

With the formula language you are familiar from Excel, it is very easy to code on Power Apps.

You can write all the formulas on items. After choosing the related item, you can write it on the Formula Bar.

The formulas can be written with a comma (,) or a semi-colon (;) , you don’t have to use the equal sign.

The DateAdd Function

You can add a day, month, year, quarter, second etc. to a certain date with the DateAdd Function.

The syntax of DateAdd is:

DateAdd( DateTime, Addition [, Units ] )

To add 10 days to 13.02.2020,
Add a label and write the formula below into the Default property of the label:
DateAdd(DateValue(“13.01.2020”) ; 10 ; Days )

We have stated that we can enter date data with the DateValue function.

—

When we need to add 10 days to today’s date,
Add a new label to the screen and write the formula below into the Default property of the Label:
DateAdd( Today() ; 10 ; Days )

We have automatically detected today’s date based on the local date with the Today function.

We got partly static and partly dynamic results with functions above by writing the parameters one by one.

We can utilize different items to make the formulas more interactive and to be able to write dynamic functions.

Create Formulas that Depend on User Choices

In the example below, all the parameters of he function can be updated with the user’s choices.

Date will be chose,

Day, Month, Year will be chosen,

Add the unit to be added will be specified.

The name of the items we use on the screen:
Name of the date selection box: dd_TarihSec (dd_SelectDate)
Name of the list for unit (day, month, year…) selection: dd_BirimSec (dd_SelectUnit)
Name of the box about the addition: txt_BirimSayisi (txt_Addition)

*Note: Each item has a standard name when added to the screen. It is very important to name the irems based on their function in order not to have any difficulties while writing a formula or calling information from one of these items.

A new Label is added to the screen and the formula below is written into the Default property of this label.

DateAdd(dd_TarihSec.SelectedDate; Value(txt_BirimSayisi.Text); dd_BirimSec.Selected.Value)

If you want to show a long date format like 23 February 2020 Sunday you can use the Text function (it is used the same way as in Excel).We can get the result by writing the Text function outside function we just wrote with the nested function logic.

Text(DateAdd(dd_TarihSec.SelectedDate;Value(txt_BirimSayisi.Text);dd_BirimSec.Selected.Value);LongDate)

You can access the list of all the other functions here.

Microsoft Teams : Not-That-Frequently Asked Questions

Does Teams work Offline?

Nope. Teams an application that was developed to run online.

When should I use Chat and when should I use Teams channels?

Chat groups are ideal to discuss and work on a project before sharing it in a channel. And the channels are recommended to be used in a more formal way since they bring more main groups like departments and projects together. For example: Creating channels for sharing success stories, announcements of the HR, splitting projects into phases is more efficient whereas using chat groups for daily flows would be more recommendable.

Tip: You can name the Chat groups to be able to find them easier later.

Where do the Deleted Teams Go?

The Teams are in a restorable environment called soft-delete for 30 days after they are deleted. But once that period is over, they are deleted completely. Each Team represent an Office 365 group and the files shared are stored in SharePoint Online Sites. And the chat in channels are stores in the mailboxes of teams.

Can Teams track and report user behavior?

Off course. There is Audit Logs in Office 365 Security & Compliance Center (protection.office.com) where all the Office 365 applications are tracked and can be reported. Teams activities can be also tracked with Cloud App Security, Azure Sentinel or PowerShell (Search-UnifiedAuditLog) apart from this method.

Can I set a profile picture for Guest users?

Yes, but not within Teams! You can execute whatever update you wants through Azure Active Directory/Guest user accounts or use the Set-AzureADUserThumbnailPhoto cmdlet. Defining a default profile picture for all guest users can be a good way to indicate the users outside your company.

Can I send and announcement to multiple teams simultaneously?

Yes. The Format option is shown with the letter A at the bottom of the channels. When you lick it, you can share announcement with different channels of different teams by using the “Share in multiple channels” option.

Does it make sense to use Teams instead of e-mails?

Teams is a very useful application for cooperation within the company and with first-degree partners. With chats, online meeting, co-authoring on a file and integrations, it gets to be a roof platform and increases productivity. But, since e-mails are still a common language for chats and between companies, it is not completely dispensable.

Why can I not blur my background in meetings?

The precondition to blur your background is a computer with Advanced Vector Extension 2 (AVX2) graphics. If your computer doesn’t meet this precondition, you cannot use the blur feature. You can also try to use the blur feature with the Ctrl+Shift+P shortcut.

Is there a limit for a Teams message size? If yes, what is it?

It is approximately 28 KB (media not included). This limit is for the e-mails sent to the Teams channels, messages that come from connectors and applications and all the messages that you can send by copy-pasting.

Why are the mail addresses of channels are so weird?

Team mail addresses work under the teams.ms domain connected to a different tenant Microsoft administrates, not to Office 365 tenant. Mails sent here are not sent to users one by one. Instead, they are sent to the mailbox of the channel a gets to be sent as a message to the channel via a connector. Apart from that, it is also stored in the SharePoint Site connected to the team, hence as a .eml file under the Files of the team.

What is Priority Access?

Priority Access is the messages that you receive the notifications of when you state your status as Do not Disturb and turn off Teams notifications. You can set the people whose notification you will always receive through the Privacy tab of Teams settings. Urgent Messages are among the notification with priority and can be sent by anyone. Urgent messages can only be sent in Chats, not in channels.

What do Bots do in online meetings?

Bots have a lot of different responsibilities, specific to this question we can see that bots enable the connection between Teams and Stream. And also, a bot joins the meeting when it is started and when it is over, the bot send the record to Azure Media Services and then it is transmitted to Stream.

Microsoft Teams Office365

Why Should You Get a Consultancy Service for the IT Sector?

Why Should Human Resources Departments Get Consultancy Services?

Many companies can be biased if they have not used this service before.

In this article, I will tell you how you can get this for 25.000₺ instead of 60.000₺. How? I will be giving the answer in the rest of the article.

First of all, let’s talk about the benefits of using this service:

Working with a professional consultant is very important primarily for the prestige of your company. The person representing your brand and the physical conditions make the first impression, after which a specialist consultant who technically speaks the same language with the candidate expresses the position to the candidate in the best way possible.

Based on research and my experience in the industry, a total of 450 resumes are analyzed to recruit an IT staff, which means 8 hours of work for an HR employee. Let’s say that they call about 250 candidates they found suitable from these resumes and made a pre-interview; this would mean about 20 hours. If approximately 50 people of these candidates come to the interview, the total work and organization time spent exceeds 50 hours. As a result, the organization of the second meetings means introducing technical teams with appropriate profiles, reference works etc. and thus, about 15 more hours of work is spent. In this example, if everything goes well, 93 hours is spent for a candidate. Considering tasks that interrupt, breaks etc., we can say that a staff member works only for this position for 1 month without doing anything.

Now if you wish, let’s talk about what it will cost you.

Let’s say a human resources employee cost ₺10,000 for a month to the employer, and the cost of the time spent by an IT staff interviewing these candidates would be around ₺10,000. In addition, if we say that the money you spend on career portals and the amount of equipment spent for this organization is minimum ₺3.000, you have already spent ₺23.000 from your pocket with a very simple calculation.

Now, let’s come to the scenario where you have hired the candidate you found and you are not satisfied.

You have worked so hard, spent overtime, endured a lot of costs and employee you were looking for finally started the job, but there is a problem. You are not satisfied with the candidate or the candidate is looking for something different and you have to part your ways! IT staff, as you know, are costly resources. In this example, let’s assume you employ a software development employee, and assume you work for two months with him/her with a net salary of ₺9,000 per month. The cost of this personnel to the employer will be a minimum of ₺35,000 for 2 months. And the whole process will start over. So, you spent ₺60.000 for a job that was not guaranteed.

Now, I want to talk about what we will provide for you.

First of all, let’s talk about reaching the right profile, which is one of the most difficult issues. IT recruitment consultants analyze hundreds of candidates that you cannot find on career portals, and provide interviews with the most suitable profiles for you. In these interviews, competent recruitment consultants question your personal competencies and select the profile that best suits your corporate culture and teammates and take them to the next level. At this stage, the requirements for the position are questioned, the technical competencies of the candidate are measured and the most suitable profile is selected for your institution, manager and job.

Afterwards, the candidate is introduced to you without wasting time. We organize the whole organization in order to make these meeting organizations in the most comfortable way possible.

In all processes of the candidate, which we call end-to-end consultancy service, we undertake processes like analyzing resumes, competence and technical interviews, meeting organizations, reference checks etc. and enable you to employ the most suitable profile as soon as possible. In this process, if you are not satisfied with the personnel employed, we immediately work on the same position for free.

The basic need of companies is primarily Human Resources and the right profile that will carry your organization forward adds value to your company.

If you want to get more detailed information about our professional consultancy services, you can contact us.

The Importance of Digitalization for the Human Resources

We are all aware that digitalization and technological transformation have taken an important place in our daily and business life with an increasing momentum. More importantly, as our age is rapidly digitalizing, companies that cannot keep up with this trend have only one question to answer: “Are we one or do we continue?”

In this article, we will talk about the importance of digitalization for Human Resources.

Digitalization of Recruitment Processes

The studies conducted by PWC show that the effort towards the use and dissemination of Human Resources technology solutions is increasing day by day. With the support of technology, Human Resources can easily report and spend the time saved in this process by managing the follow-up and analysis processes in digital environments, to become a “strategic business partner”.

If we need to explain with an example, with the digitalization of recruitment processes, Human Resources departments have been able to reach the appropriate candidate quickly and close the processes 50% faster compared to the past. In addition, job search sites, online platforms, and mobile applications continue to be a big part of the process day by day. Now, many companies have created their candidate pools in digital environment and made the first interview with the candidate over the internet, earning days or even weeks.

The introduction of the concept of “Home Office” into our lives with digitalization

Especially with the acceleration of digitalization, we cannot help but mention the concept of “home office”, which we have started to hear a lot. We have already said goodbye to the desktop computer and the paper files filling the cabinets, but with the introduction of Cloud Computing into our lives, we found ourselves in an environment where we can access any information – document we need from anywhere. As such, the expectations of the employees started to take shape in this direction. Of course, we cannot say that every company will be involved in this process, but the number of companies that provide their employees with the opportunity to work from the location they want on certain days of the week (for now), although not full-time, is increasing day by day.

The Contribution of Digitalization to Human Resources

The information that we have obtained by spending our hours and days before is now on our screen with a single click. This is a process that supports companies to take more strategic and fast actions. We are now able to research competitor analyzes, side rights, salary comparisons and many other topics that we can exemplify, in digital environments with our own means. We can say that easy access to information makes our work easier, while increasing competition and forcing companies to be innovative.

Perhaps the most important contribution of digitization to Human Resources departments is saving time. Everyone in the sector is aware that the definition of Human Resources has undergone a great change. Ten years ago, when we talked about Human Resources; bureaucratic processes, legal transactions and payroll processes came to mind, now Human Resources has gone into a more strategic, employee satisfaction-oriented process, which has been stripped of all these papers. With digitalization, they had the opportunity to focus a lot of their concentration on employee satisfaction, while spending much less time following many processes, including training planning, performance evaluations, personnel and inventory follow-up. The biggest goal of every company is to be the preferred workplace by candidates, and now with the support of all these digitalization processes, we can say that Human Resources departments can spend their efforts in this focus.

We are in the middle of a rapidly changing, developing and digitalizing era. There is only one way out that will make us different from others, and that is to adapt quickly and use our time efficiently. The way to do this is through digitalization.

Click here to meet Velocity, your companion that will support you in your digitalization processes!

Create and Track Lists from a Center with Microsoft Lists

Microsoft Lists

Track information with Microsoft Lists. Organize your work. Customize for your team. Track your work, convey information and visualize data with your team from a center.

Stay on top of it all with Lists, your smart information tracking app in Microsoft 365. Work with anyone, anywhere. Configure your lists to better organize events, issues, assets, and more.

Make lists smarter with Microsoft Lists in order to do more in Microsoft 365

Tracking information is a part of our daily lives. Writing something or using electronical tables work for simple things. However, while dealing with hundreds or thousand of data and when you need to coordinate with your teammates and match with the new workflows, it can become overwhelming rapidly. Since global pandemic has turned remote working into the new normal, we also face the difficulties caused by having to stay in sync while staying home.

We have created Lists that will save you time and overcome difficulties. Lists that are easy to use as a spreadsheet, help you to track any information, invite others to cooperate and use rules to synchronize everybody in addition to customizing forms and flows with Power Platform. Simple, smart and flexible way to track information and do more.

Start from a Template or an Excel file, or from the scratch

Create by using various templates, transform an Excel file or start from the scratch to bring you vision to life.

View your data in your style

Visualize your data in different ways and interact with them. View the information in a gallery or track your work on a calendar.

Set rules and send a notification to your team

Create rules to automatize processes based of your list data. When a change is made, send yourself or others a notification.

Create a New List

You can create a blank list.
You can import a list as a Table from Excel.
You can continue from an existing SharePoint team list.

Create, share and track lists with people you want

Start quickly with ready-made templates. See the recently and frequently used lists.Track and manage lists wherever you’re working. Share lists with others easily.

Favorites and Recent Lists in Microsoft Lists

Keep everyone in sync with lists in Teams

Work together in real time with conversation and lists side by side. Track what matters most to your team using rules, reminders, and comments.

Customize lists for whatever your team needs

See your lists any way you want using calendar, grid, gallery, or a custom view. Configure basic form elements and highlight important details with conditional formatting.

A list of assets shown in grid view in lists

Add automation with Power Platform

Build custom productivity apps using lists as the data source. Extend forms with Power Apps and customize workflows with Power Automate.

You can get the other details about Microsoft Lists here.
You can read our other blog posts here.

microsoft listeler microsoft lists

Peyman Creates Its Reports with Power BI

Peyman -the leader of Turkish Dried-Nut Industry, has become one of the strongest main industries from a regional player identity in a very short period of time with their investments and courageous steps that they took. Peyman managed to be in ISO 500 and became one of the 500 Large Industry Companies of Turkey. Peyman Kuruyemiş continues to offer its products to the consumers by visiting hundreds of customers with around 400 sales representatives every day.

How did the cooperation between PEYMAN and PEAKUP happen?

With around 400 sales representatives in the field, we visit hundreds of customers every day and bring our products to consumers. In this process, it becomes very important to follow the sales performance of both our team and our products, to compare them with past data and to analyze them with various criteria. In the past, efforts to meet this need were insufficient at the stage of meeting the need due to the license cost or capacity limits of the selected solutions.

After the analysis and researches we made as the IT team, Power BI became the prominent solution for us with its simplicity, easy implementation, and the fact that it is easy to learn.

We needed consultancy on the details of the capabilities of Power BI and whether the priority reports for us could be prepared in Power BI and how long it would take to get started with it. The PEAKUP team guided us in the right way with their knowledge and experience in Power BI and supported us with the most accurate solution for our reporting needs. Later, with the training we received from PEAKUP, we introduced 15 of our friends to Power BI, and we got to teach them that they could prepare with excel and publish their reports more quickly and easily through this environment.

With Power BI consultancy, we quickly created our reports with priority. It has been a great achievement for us that we can access our sales data in region and product details with a few clicks by using the reports we have created, and that our sales team can access these reports over the internet whenever they want.

PEAKUP is a team of friends who are competent in Power BI. Ms. Birhan helped us as a consultant during our work. Ms. Birhan, with her experience in Power BI, both guided us in the right way and helped us find the right solution with the consultancy she gave us in every issue we got stuck during the development of the reports we created. The case study and exercises she did during our Power BI trainings ensured that the trainings were effective and efficient. I highly recommend PEAKUP to everyone, both because of their approach and because of their experienced and competent teammates.

İrfan Cin – Sales Systems and Business Intelligence Expert

AZURE SENTINEL DATA CONNECTORS

We had the chance to talk a bit about the Microsoft Azure Sentinel in our previous article. We tried to answer a lot of questions like “What is Azure Sentinel? How does it work? What are the costs? ” In this article, we will talk about the data connector methods and which data connector method we should use. These methods are Integration from Service to Service, API Integration and Agent Integration. I will explain which integration should be used for which products shortly.

Data Connectors Methods

Integration from Service to Service

Amazon Web Services – CloudTrail
Office 365
Azure AD audit logs and sign-ins
Azure Activity
Azure AD Identity Protection
Azure Security Center
Azure Information Protection
Azure Advanced Threat Protection
Cloud App Security
Windows security events
Windows firewall

Integration with API

Barracuda
Symantec
Citrix Analytics (Security)

Integration with Agent

Firewalls, Proxy and Endpoints:
- F5
- Check Point
- Cisco ASA
- Fortinet
- Palo Alto
- Other CEF products
- Other Syslog products
- Barracuda CloudGen Firewall
- ExtraHop Reveal(x)
- One Identity Safeguard
- Trend Micro Deep Security
DLP Solutions
DNS Servers
Linux Servers
Other Cloud Services

Things to Do for Sentinel Data Connector

Like we have mentioned above, there are 3 methods to connect data. Let’s take a look at how these methods work:

It will be enough to enter username and password on Data Connectors for Integration from Service to Service. But keep in mind that the Account should have at least Security Administrator authority since we will log into Microsoft products. For AWS, the process is a bit different but we still need just one Account. As a different step, it will be enough for us to create a user on IAM and assign the “AWSCloudTrailReadOnlyAccess” role. Also, I need to mention that you need at least the AADP1 licence for Azure AD Identity Protection.

We need to execute some actions on the product from which we’ll get the link for integration with API. These actions vary from one product to another. For example, we need to execute different actions for Barracuda and Symantec. Since each one of these actions are a topic of an article, you can find the technical documents below.

Barracuda API Integration

Symantec API Integration

Citrix Analytics API Integration

We need a Connector service for integration with Agent as a different step from the other methods. The role of this server is to provide the connection between the Product and Sentinel. Different from the other methods, integration with Agent requires a comprehensive and extensive work.

I hope that this helped you.

Click here to read our article about Raspberry PI HotSpot/Modem.

HAVE YOU EVER SORTED WITH A FORMULA?

THE SORT FUNCTION

Hello everyone,

No doubt that one of the most frequently used functions in Excel is the Sort function.
This feature has 2 constants: A-Z and Z-A i.e. Ascending and Descending Sort.
We sort our data by certain field in pretty much all tables.
Have you ever tried to get this sorting action done with a formula?

WHAT DOES IT DO

You can easily sort columns or rows by the sort order you want in a different field from your mail table with the SORT function that is one of the dynamic array functions that are recently released after Office 365 .

SYNTAX

=SORT(array,[sort_index],[sort_order],[by_col])

There are 4 arguments in the function.
The first one is required, the next 3 arguments are optional.

Now, let’s take a look at what these arguments mean, i.e. what the function wants from us and what we will give it.

Argument	Description
array Required	The range, or array to sort
[sort_index] Optional	A number indicating the row or column to sort by
[sort_order] Optional	A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order
[by_col] Optional	A logical value indicating the desired sort direction; FALSE to sort by row (default), TRUE to sort by column

USE OF THE FUNCTION

Choose the fields you want from your table and state by which column and order you will sort.
When you choose a field for the array argument only, the data is sort based on the Ascending order.
If multiple columns are selected in the array argument, the column by which the sorting will be done is chosen.
You can choose the Descending order in the sort_order argument if you want. If you don’ choose it, the sort is always Ascending.
In the by_col argument, you can sort by column i.e. from left to right. If not chosen, the sorting will always be from top to bottom.

Let’s have an example and see what happens when we choose the array argument only.

Now, let’s choose multiple columns and state the sort_index argument as well.

Since we didn’t use the sort_order argument in the formula below, prices are sorted from the lower to the higher. Now, let’s use the sort_order argument in the same function and see our data sorted from the higher to the lower.

Lastly, let’s sort the data from left to right and now from top to bottom.

We will be talking about the other New Dynamic Array functions in our next articles.
And then we will be able to get things done way easier by using these new functions together. LONG LIVE THE NEW DYNAMIC ARRAY FUNCTIONS!

See you in other articles, bye. 🙋🏻‍♂️
You can share this article and help a lot of people get informed as well. 👍🏻

Excel file trickster msexcel office insider sırala sırala fonksiyonu Sıralama SORT

Power BI: Let your data speak to you

Our 4th CodeRunner event took place in Istanbul with the Istanbul Metropolitan Municipality. We had a fun event on the “Power BI: Let your data speak to you” topic.

You can download our presentation to get detailed information on Power BI.

Information Technologies Legal News in April

INFORMATION TECHNOLOGIES LEGAL NEWS IN APRIL

This month, Covid-19 was at the center of information technology updates again.

It has been announced that an energy investment of approximately 130 trillion dollars of the world economies is required for the comprehensive decarbonization strategies.
In the January-March period of 2020, when the Corona virus pandemic was effective, the total number of Netflix subscribers reached 182.9 million with an increase of 15.8 million.
Video communication platform Zoom announced new features that increase conversation privacy and security with the v4.6.10 update.
Apple and Google are developing an application against the Corona virus that can detect whether you have been in contact with someone infected with the virus or not.
The explosion of online shopping due to the Corona virus pandemic has added another $24 billion to the fortune of its founder and boss, Jeff Bezos, as Amazon’s shares have been thoroughly valued.
In the lawsuit filed by Hagens Berman law firm in California Northern District Court, Amazon was accused of “illegal price increases during the Covid-19 outbreak”.
Social media company Facebook announced that it has invested $5.7 billion in mobile internet company Jio Platforms, owned by Indian billionaire businessman Mukesh Ambani.
The Netherlands has banned the use of the video conferencing program Zoom for distance education due to safety concerns.
The United Nations Children’s Fund (UNICEF) and Microsoft have established a digital education platform for students affected by the new type of coronavirus (Covid-19) pandemic.
China-based e-commerce platform Alibaba’s cloud technologies company Alibaba Cloud Intelligence has announced that it will invest an additional 200 billion yuan -$28.5 billion, in the next three years in cloud infrastructure.
Google Meet got new features. The most attention-grabbing point of the updates was that 16 participants could be seen on a single screen.