Power Apps

What is Power Apps?

  • Is a tool of Microsoft Power Platform to develop applications.
  • You can use Power Apps with Power Automate and Power BI to build powerful applications.
  • Collection of apps, services, connectors.
  • A data platform to build customs apps according to your business needs.
  • Custom apps can connect to data platform or online and on-premises data sources such as SharePoint , Excel, Office 365, Dynamics, SQL Server.
  • Allows users to build apps without writing code.
  • Benefit of using power app is that it allows many data sources in a single app.

Power Apps Components

Power Apps Home Page

  • Here you can develop apps from sample apps, templates or blank screen.

Power Apps Studio

  • Here you can fully customise your app to meet your business goals.

Power Apps Admin Center

  • Plaform to manage your power apps. Define your environments, data connections, manage environment role and data policies.

Data sources, connections, and gateways

  • Popular data sources: common data service, sharepoint, sql server, dynamic 365, office 365 users, office 365 outlook, excel, one drive for business, onedrive, dropbox.
  • Some connectons allow power apps to read and write data.
  • Some cloud services such as salesforce or twitter can be a datasource.
  • For on-premises data, you use gateway to provide reliable connection. The gateway will be implemented on a non-premises computer and communicate with power apps.

January 2022 Market Overview

NasdaqS&P 500Dow
Jan – 315832.79(+187.83)4796.56(+30.38)36585.06(+246.76)
Jan – 415622.71(-210.08)4793.54(-3.02)36799.65(+214.59)
Jan – 5 15100.17(-522.54)4700.58(-92.96)36407.11(-392.54)
Jan – 6 15080.86(-19.31)4696.05(-4.53)36236.47(-170.64)
Jan – 7 14935.9(-144.96)4677.03(-19.02)36231.66(-4.81)
Week 2
Jan – 1014942.83(+6.93)4670.29(-6.74)36068.87(-162.79)
Jan – 1115153.45(+210.62)4713.07(+42.78)36252.02(+183.15)
Jan – 12 15188.39(+34.94) 4726.35(+13.28) 36290.32(+38.30)
Jan – 1314806.81(-381.58) 4659.03(-67.32) 36113.62(-176.70)
Jan – 1414893.75(+86.94) 4662.85(+3.82) 35911.81(-201.81)
Week 3
Jan 1814506.89(-386.86) 4577.11(-85.74) 35368.47(-543.34)
Jan 1914340.25(-166.64) 4532.76(-44.35) 35028.65(-339.82)
Jan 2014154.02(-186.23) 4482.73(-50.03) 34715.39(-313.26)
Jan 2113768.92(-385.10) 4397.94(-84.79) 34265.37(-450.02)
Week 4
Jan 2413855.13(+86.21) 4410.13(+12.19) 34364.50(+99.13)
Jan 2513539.30(-315.83)4356.45(-53.68) 34297.73(-66.77)
Jan 2613542.12(+2.82) 4349.93(-6.52) 34168.09(-129.64)
Jan 2713352.78(-189.34) 4326.51(-23.42) 34160.78(-7.31)
Jan 2813770.57(+417.79) 4431.85(+105.34) 34725.47(+564.69)
Week 5
Jan 31 14239.88(+469.31) 4515.55(+83.70) 35131.86(+406.39)


Jan 31

  • Strong: Consumer Discretionary, Information Technology, Communication Services
  • Weak: Energy, Consumer Staples
  • Tech stocks rebound

Jan 28

  • Strong: Information Technology, Communication Services, Real Estate
  • Weak: Energy
  • Investor concern: inflation and interest rates
  • End of month balance sheet adjustments

Jan 27

  • Strong: Consumer Staples, Energy, Utilities, Materials
  • Weak: Consumer Discretionary, Real Estate, Information Technology, Financials
  • Fed expectations saga continued today to close the market in red
  • Semiconductor sector is weak
  • Supply chain issues causing tech sector to decline
  • Airline industry challenges high wages, fuel cost, maintenance cost and airport parking

Jan 26

  • Strong: Information Technology, Financials
  • Weak: Real Estate, Materials, Communication Services, Industrials
  • FOMC press conference – roll back policy support and risk of high inflation in coming months
  • FOMC rates near zero and will end asset purchase in march 20200

Jan 25

  • Strong: Energy, Financials
  • Weak: Information Technology, Consumer Discretionary, Communication Services, Utilities
  • Investor waiting for FOMC policy decision tomorrow

Jan 24

  • Strong: Consumer Discretionary, Energy, Industrials
  • Weak: Utilities, Health Care, Consumer Staples
  • Omicron scare, FED interest rate fear, Mixed corporate results
  • Bounce from oversold result
  • Ukraine war fear

Jan 21

  • Stock market in red
  • Strong: Consumer Staples
  • Weak: Communication Services, Consumer Discretionary, Materials
  • Fed and geopolitics

Jan 20

  • Weak: Consumer Discretionary, Materials, Information Technology, Industrials
  • Selling pressure

Jan 19

  • Strong: Consumer Staples, Utilities
  • Weak: Financials, Consumer Discretionary, Information Technology
  • Selling pressure from all the sectors
  • Increase in weekly MBA Mortgage Application Index by 2.3%
  • Increase in Housing starts by 1.4% m/m
  • Increase in permits by 9.1% m/m

Jan 18

  • Strong: Energy
  • Weak: Information Technology, Financials, Communication Services
  • Inflation pressure and interest rates hike.
  • 2-yr yield rise 1.00%, 10-yr yield flirts with 1.88%
  • Empire State Manufacturing Survey for January dropped to -0.7 from 31.9 in December.
  • NAHB Housing Market Index for January decreased to 83 from 84 in December.

Jan – 14

  • Strong: Energy, Information Technology, Communication Services
  • Weak: Real Estate, Financials, Materials, Utilities
  • Strength in the mega-caps stocks
  • Mixed bank earnings, downbeat economic data, interest rates rise

Jan – 13

  • Strong: Industrials, Utilities, Consumer Staples
  • Weak: Information Technology, Consumer Discretionary, Health Care, Communication Services
  • Growth stocks selling interest.
  • Airlines outperform after beating estimates.
  • PPI increased by 0.2% m/m.
  • Initial claims for the week ending January 8 increased by 23,000 to 230,000.

Jan – 12

  • An increase in CPI data 0.5% month-over-month in December and 7.0% year-over-year. Sharpest 12-month increase since June 1982. Core CPI, which excludes food and energy, rose 0.6% month-over-month and was up 5.5% year-over-year. This was the sharpest 12-month increase since February 1991.
  • The Treasury Budget showed a $21.3 bln deficit in December versus a $143.6 bln deficit in the same period a year ago. December marked the 27th consecutive month that the Treasury has seen a budget deficit.
  • The budget deficit over the last 12 months is $2.58 trln versus a deficit of $2.70 trln in November.
  • The weekly MBA Mortgage Applications Index increased 1.4% following a 5.6% decline in the prior week.
  • Weekly EIA crude oil inventories decreased by 4.55 mln barrels after decreasing by 2.14 mln barrels during the previous week.
  • Fed’s Beige Book for January reported that economic activity in the U.S. expanded at a modest pace in the last weeks of 2021 and that some districts observed a deceleration in the robust price increases from the previous months.
  • Jan-11 : Fed Chair Powell’s Senate confirmation hearing. Fed will end asset purchases in March, hike rates over the course of the year and allow the balance sheet to run off later in the year.
  • Jan-5 : Fed Minutes from the December meeting showed that participants thought it would be appropriate to reduce the size of the Fed’s balance sheet at a faster pace than during the previous normalization period.
  • Jan-4: Daily COVID-19 cases in the U.S. topped one million, ISM Manufacturing Index decelerated more than expected to 58.7% from 61.1% in November, it still denoted an expanding manufacturing sector.
  • Jan- 3: Higher oil prices , Big tech earnings, tax loss selling pressure.