Nam Hoang Nguyen

Short Answer (Summary)
Power Apps cannot directly retrieve more than the delegation limit (max 2,000 per query), but you can load 10,000+ SharePoint items by breaking the data into batches, using index columns, and looping through ranges to build a full collection. This is a known workaround used by Power Apps makers.

🧩 2. Proven Methods to Retrieve 10,000+ Items
✅ Method 1 — Use an Index Column + Batch Retrieval (Most Reliable)
This is the most widely used method for large lists.
You add a numeric “Index” column in SharePoint (1,2,3,…10000) and retrieve items in 2,000‑record batches.

Steps
Add a Number column in SharePoint called Index.

Populate it (Power Automate or script).

In Power Apps, loop through ranges:

powerapps
Clear(colBigList);

ForAll(
Sequence(5), // 5 batches → 5 × 2000 = 10,000
Collect(
colBigList,
Filter(
‘MySharePointList’,
Index > ((Value – 1) * 2000) &&
Index <= (Value * 2000)
)
)
)

Why it works
Each batch uses a delegable filter (>, <, <=, >= on a number column).

You can scale to 100k+ items by increasing the Sequence() count.

✅ Method 2 — Use a “Range Table” + ForAll Loop
This method uses a helper table (local or SharePoint) that stores ranges like:

RangeID Start End
1 1 2000
2 2001 4000
3 4001 6000
… … …
Then loop through it:

📋 3. Implementation Checklist
Before Power Apps

• Add Index column
• Populate index values
• Index the column in SharePoint
• Confirm list has no non-delegable filters

In Power Apps

• Set delegation limit to 2000 (App settings → Advanced)
• Use Sequence() to create batch loops
• Use Filter() with delegable numeric comparisons
• Collect batches into a single collection

🎯 Final Takeaway
You can retrieve more than 10,000 SharePoint items in Power Apps, but only by chunking the data into delegable batches using an indexed numeric column or a range table.

Why these fields are special

SharePoint treats these four columns as system-managed metadata:

Created — timestamp when the item was first saved

Created By — user who created the item

Modified — timestamp of the last update

Modified By — user who last updated the item

By default, Power Automate cannot directly modify them because SharePoint locks them to preserve audit integrity.

This is the best way by Using the SharePoint REST API with “bypass” header

You can override system fields if you call the REST API with:

Short answer and core takeaway 

AI will transform software development rapidly but is very unlikely to completely replace all software developers this year or in the immediate future. The most realistic near‑term outcome is widespread augmentation of developer work (automation of routine tasks, faster prototyping, and higher productivity) combined with selective displacement in narrow roles — not wholesale extinction.  

Why full replacement is unlikely (key reasons) 

• Technical limits and scope — Current generative models excel at pattern completion, scaffolding, and routine code generation, but they struggle with long‑running system design, ambiguous requirements, debugging complex emergent behavior, and integrating across large, evolving codebases. These are core parts of senior engineering work that require context, judgment, and iterative testing.  

• Economic and organizational incentives — Companies often find it cheaper and less risky to augment engineers with AI tools than to eliminate teams entirely; many firms are using AI to boost productivity rather than to replace institutional knowledge and cross‑team coordination.  

• Human factors and trust — Stakeholders (product managers, customers, regulators) demand accountability, explainability, and safety for production systems; humans remain necessary for risk assessment, ethics, and final acceptance.  

• New roles and demand — AI adoption creates demand for roles like prompt engineers, ML ops, model auditors, and AI‑augmented product designers; some jobs are displaced, but others are created or reshaped.  

What is likely to happen this year and the next 3–5 years 

• Short term (this year) — Rapid adoption of AI assistants (Copilot‑style) for code completion, tests, and documentation; hiring slowdowns in some entry‑level roles; productivity gains for teams that adopt tools well.  

• Medium term (2–5 years) — Routine, repetitive programming and boilerplate generation become largely automated; emphasis shifts to system architecture, integration, security, and domain expertise; reskilling and role transitions accelerate.  

• Longer term (5+ years) — Outcomes depend on model advances, regulation, and business choices: some highly standardized development work could be largely automated, while complex, creative, and safety‑critical engineering will still need humans. 

Quick comparison: task types and AI risk 

Task	Likelihood of automation (near term)	Human value that remains
Routine CRUD, boilerplate code	High	Domain knowledge, integration choices
Unit tests, documentation, refactors	High	Design intent, prioritization
System architecture, cross‑team design	Low	Strategic judgment, tradeoffs
Debugging complex production incidents	Low–Medium	Context, root‑cause reasoning
Product discovery, stakeholder negotiation	Low	Empathy, persuasion, ethics

Practical steps for developers who want to stay valuable 

• Master AI tools — Learn to use and evaluate code assistants, prompt engineering, and model outputs safely. 

• Deepen system and domain expertise — Focus on architecture, reliability, security, and business context that models can’t easily infer. 

• Strengthen soft skills — Communication, cross‑team leadership, and product judgment become differentiators. 

• Invest in continuous learning — Upskill in ML fundamentals, observability, and AI governance to move into higher‑value roles.  

Risks, policy, and what to watch 

• Concentrated displacement — Entry‑level and highly standardized roles are most exposed; social safety nets and retraining programs will matter.  

• Quality and safety tradeoffs — Faster code generation can increase technical debt and subtle bugs if human review and testing are reduced.  

• Regulation and corporate choices — How companies and regulators treat liability, IP, and model transparency will shape whether AI augments or replaces people.  

Single most important takeaway: AI will change what software developers do and how they work, but it will not make experienced, context‑aware engineers obsolete overnight. 

A Modern Blueprint for Enterprise Digital Transformation 

SharePoint is already a powerful content and collaboration platform—but when you combine it with Power Apps, Power Automate, and Power BI, it becomes a full-scale digital transformation engine. These tools turn SharePoint from a document repository into a dynamic, automated, insight‑driven business hub. 

Below is a detailed breakdown of how each component elevates SharePoint and how they work together to transform enterprise operations. 

1. Power Apps + SharePoint 

Transform Lists & Libraries into Enterprise‑Grade Applications 

Power Apps allows organizations to build custom business applications on top of SharePoint without writing code. 

Key Benefits 

• Replace manual forms with responsive, mobile-ready apps 

• Standardize data entry using validation, rules, and guided workflows 

• Extend SharePoint lists into full business applications 

• Enable field workers with mobile apps connected to SharePoint data 

• Integrate with external systems (ERP, CRM, HRIS, SQL, Azure services) 

Common Use Cases 

• Employee onboarding apps 

• Asset management & tracking 

• Helpdesk & ticketing systems 

• Inspection & compliance apps 

• Project intake & approval portals 

Power Apps essentially turns SharePoint into a low-code application platform. 

2. Power Automate + SharePoint 

Automate Processes, Reduce Manual Work, and Improve Compliance 

Power Automate connects SharePoint to hundreds of systems and automates repetitive tasks. 

Key Benefits 

• Automate approvals (documents, requests, onboarding, procurement) 

• Trigger workflows when items are added/updated in SharePoint 

• Integrate SharePoint with email, Teams, ERP, CRM, and more 

• Enforce governance with automated notifications and escalations 

• Reduce human error by standardizing processes 

Common Use Cases 

• Document approval workflows 

• Automated reminders for deadlines or expirations 

• Data synchronization between SharePoint and other systems 

• Auto‑provisioning of project sites or folders 

• Compliance workflows (retention, audit trails) 

Power Automate turns SharePoint into a process automation engine. 

3. Power BI + SharePoint 

Turn SharePoint Data into Actionable Insights 

Power BI brings analytics and visualization to SharePoint data, enabling data‑driven decision‑making. 

Key Benefits 

• Visualize SharePoint list data with dashboards and KPIs 

• Embed reports directly into SharePoint pages 

• Combine SharePoint data with ERP, CRM, and cloud data sources 

• Enable leadership dashboards for real‑time insights 

• Improve transparency and accountability 

Common Use Cases 

• Operational dashboards 

• Project portfolio reporting 

• Employee performance or workload analytics 

• Compliance and audit dashboards 

• Service desk analytics 

Power BI turns SharePoint into a business intelligence hub. 

4. The Combined Power Platform + SharePoint Advantage 

When these tools work together, organizations unlock enterprise‑level transformation. 

Capability	SharePoint	Power Apps	Power Automate	Power BI	Combined Impact
Data Storage	✔️	—	—	—	Centralized, secure data
Custom Apps	—	✔️	—	—	Tailored business solutions
Automation	—	—	✔️	—	End‑to‑end process automation
Analytics	—	—	—	✔️	Real‑time insights
Enterprise Transformation	—	—	—	—	Unified digital ecosystem

What this means for the enterprise 

• Faster digital solution delivery 

• Reduced reliance on custom development 

• Lower operational costs 

• Improved employee productivity 

• Stronger governance and compliance 

• Better data‑driven decisions 

This is the foundation of a modern, scalable, and intelligent digital workplace. 

5. Example: End‑to‑End Digital Transformation Scenario 

“Employee Onboarding Automation” 

Before: Manual forms, email approvals, inconsistent processes, no visibility. 

After (with SharePoint + Power Platform): 

• SharePoint stores onboarding data and documents 

• Power Apps provides a guided onboarding request form 

• Power Automate routes approvals to HR, IT, and managers 

• Power BI dashboard tracks onboarding progress, bottlenecks, and SLA compliance 

This single solution can save hundreds of hours per year and dramatically improve employee experience. 

6. Why Now? 

The Business Case for Transformation 

• Hybrid work demands digital workflows 

• Organizations need agility without heavy IT investment 

• Low-code platforms reduce development time by up to 70% 

• Data-driven decisions are now a competitive necessity 

• Automation reduces operational costs and errors 

It’s the right moment for businesses to modernize their SharePoint ecosystem and accelerate digital transformation. 

Thank you, Trump, for pushing forward a set of tariffs that economists warn could cost the average U.S. household more than $2,000 in 2025. These tariffs—described by many analysts as legally questionable and economically risky—function like a hidden tax on American families. When tariffs raise the cost of imported goods, companies often pass those increases directly to consumers. That means higher prices on everyday essentials: groceries, clothing, electronics, household items, and countless products that rely on global supply chains.

Experts have pointed out that these policies don’t just affect luxury goods or niche markets. They ripple through the entire economy, raising costs for manufacturers, retailers, and ultimately the people who buy their products. For a typical household already navigating inflation and rising living expenses, an extra thousand dollars a year is not a small burden.

So yes—thank you for the “America First” policy that ends up charging Americans more at the checkout line. A policy framed as tough on foreign competitors ends up being toughest on the very people it claims to protect.

Robin Hood: A legendary folk figure known for “taking from the rich to give to the poor,” representing a shift of resources toward those with fewer advantages.

President Trump: Critics argue that his policies “take from the poor to give to the rich,” representing a shift of resources toward those who are already economically advantaged.

The Supreme Court on February 20, 2026, invalidated the core legal authority used to impose a large portion of President Donald Trump’s tariff program, holding that the statute relied on does not authorize the President to impose those tariffs. Chief Justice John Roberts wrote the majority opinion in a 6–3 decision; Justices Clarence Thomas, Samuel Alito, and Brett Kavanaugh dissented.  

What the Court actually struck down 

• Legal basis — The Court found that the administration’s use of an emergency powers statute (the 1977 law commonly cited in coverage) did not permit the broad, indefinite imposition of tariffs the President had announced.  

• Scope — The decision invalidates the tariffs imposed under that emergency authority; it does not automatically nullify every tariff ever imposed by the administration, but it removes the legal foundation for the sweeping, open‑ended tariff program at issue.  

Immediate legal and administrative effects 

• Federal agencies must stop enforcing tariffs that were imposed under the invalidated authority until a lawful basis is established.  

• Customs and Border Protection (CBP) and Treasury will need guidance from the administration and possibly court orders about refunds, collection holds, and how to treat ongoing imports.  

Refunds: legal feasibility and likely paths 

• Not automatic — The Court’s ruling removes the legal authority for the tariffs, but it does not itself create an automatic refund mechanism that instantly returns money to payers. Implementation of refunds typically requires administrative action and, in many cases, congressional or executive steps to authorize and fund reimbursements.  

• Possible routes for refunds 

• Administrative refunds: Treasury/CBP could issue refunds for duties collected under the invalidated orders if they determine the collections were unlawful and have statutory authority to refund.  

• Congressional action: Congress could pass legislation directing refunds or creating a claims process and appropriation to cover reimbursements.  

• Litigation and claims: Importers, businesses, or trade groups could file claims or lawsuits seeking restitution; courts could order refunds in individual or class actions.  

Who would likely receive refunds first 

• Importers and businesses that paid duties directly to CBP are the most immediate claimants; they can seek administrative refunds or sue for restitution.  

• Consumers who paid higher retail prices because of tariffs face a more complex path: they would generally need to rely on businesses passing refunds through, class actions, or legislative remedies to recover indirect costs.  

Economic and political implications 

• Short term — The ruling removes a source of price pressure tied to those tariffs and may lower uncertainty for global supply chains; however, the timing and scale of any refunds will affect how quickly consumers and businesses see relief.  

• Long term — The decision constrains executive use of emergency economic powers for trade policy, shifting the balance toward Congress or narrower statutory authorizations for future tariff actions.  

Practical next steps for affected parties 

• Importers and businesses should preserve records of duties paid, consult trade counsel about filing administrative refund requests with CBP, and evaluate litigation options.  

• Consumers concerned about indirect costs should track whether retailers or manufacturers announce price adjustments or reimbursement programs and consider joining or monitoring class actions where appropriate.  

• Policymakers may pursue legislative fixes, clarifying statutory authority for trade measures or creating a refund framework; watch for bills and agency guidance in the coming weeks.  

Quick comparison of outcomes 

Issue	Immediate effect	Likely next step
Tariffs imposed under emergency law	Invalidated	Agencies pause enforcement; guidance issued.
Direct refunds to importers	Not automatic	Administrative claims or lawsuits; possible agency refunds.
Indirect consumer relief	Uncertain	Depends on business pass-through, litigation, or Congress.

What to watch for in the coming days 

• Agency guidance from Treasury and CBP on collections and refund procedures.  

• Legislative proposals in Congress addressing refunds or clarifying trade authority.  

• Lawsuits or class actions filed by importers, trade groups, or consumer advocates seeking restitution. 

Short answer 

Mostly Americans — U.S. importers are legally charged at the border, but the economic burden of President Trump’s tariffs has largely fallen on U.S. firms and consumers through higher prices and squeezed profits.  

How tariffs are collected versus who actually pays 

• Collection point: Tariffs are levied on imports at the U.S. border and collected from the importer of record (the firm that brings the goods into the country).  

• Economic incidence: The statutory payer (importer) can pass the cost forward or absorb it. In practice, market forces determine who bears the cost — foreign exporters, U.S. importers, downstream firms, or final consumers — and empirical evidence shows most of the burden ends up inside the U.S. economy.  

Quick comparison table of who bears the cost 

Payer	How they pay	Typical share
U.S. consumers	Higher retail prices for tariffed goods	Large; often majority of burden
U.S. firms/importers	Lower margins or higher input costs	Significant; many absorb part of tariff
Foreign exporters	Lower net price received for exports	Small to moderate; depends on market power
U.S. government	Tariff revenue collected	Small; revenue is not a transfer to consumers

Evidence and why economists reach this conclusion 

• Empirical studies and central-bank analyses of the 2025 tariff increases find that roughly 80–96% of the economic burden was borne by U.S. firms and consumers rather than foreign governments. That result comes from observing price changes, import values, and duty receipts.  

• Mechanisms: firms facing tariffs can (1) raise consumer prices, (2) accept lower profit margins, or (3) shift sourcing — but shifting often raises costs or is slow, so consumers and domestic firms absorb most of the cost.  

Practical implications to watch 

• Retail prices for tariffed categories (electronics, appliances, etc.) — rising prices indicate consumers are paying.  

• Importer margins and corporate earnings — falling margins suggest firms are absorbing tariffs.  

• Trade flows and supplier substitution — if imports shift to other countries, tariffs change trade patterns but don’t eliminate import demand; that can blunt the intended effect on the trade deficit.  

Bottom line 

Legally the tariff is charged to the importer, but economically the cost is passed through to U.S. consumers and firms in most cases. Tariffs change prices and trade patterns, but they do not magically make foreign countries pay the bill; market adjustments determine who ultimately shoulders the cost. 

A trade deficit simply means the U.S. imports more than it exports. In 2025, that gap totaled $901.5 billion. But the cost is not borne by one group — it’s spread across the economy in different ways. 

1. U.S. Consumers (Indirectly) 

Consumers “pay” through spending on imported goods. 

• When Americans buy imported electronics, clothing, cars, etc., those dollars flow abroad. 

• This is the primary driver of the deficit — not a tax or government payment. 

• Imports rose in 2025, contributing to the deficit.  

Effect: Consumers get cheaper goods, but domestic producers face more competition. 

2. Foreign Investors (Directly Finance It) 

This is the most important but least understood part. 

A trade deficit must be matched by a capital surplus — meaning foreigners invest in the U.S. by: 

• Buying U.S. Treasury bonds 

• Purchasing U.S. real estate 

• Investing in U.S. companies 

• Holding U.S. dollars as reserves 

In effect, foreigners “pay” for the deficit by sending capital back into the U.S. This is why the U.S. can run large deficits year after year. 

3. U.S. Workers in Import‑Competing Industries 

Some industries bear the cost through: 

• Job losses 

• Lower wages 

• Reduced market share 

High tariffs in 2025 did not significantly shrink the deficit, but they did shift trade patterns.  

Effect: Workers in manufacturing-heavy sectors may feel the pain more than consumers. 

4. Future U.S. Taxpayers (Indirectly) 

Because foreigners buy U.S. government debt to recycle trade dollars, the U.S. accumulates obligations: 

• Interest payments on Treasury bonds 

• Future repayment of principal 

This is not an immediate “payment,” but it means future taxpayers service the debt that helps finance the deficit. 

5. Foreign Exporters (Opportunity Cost) 

Foreign countries accept U.S. dollars instead of goods in return. They “pay” by: 

• Accumulating dollar assets instead of consuming their own production 

• Becoming dependent on U.S. demand 

This is why countries like China, Japan, and others hold large U.S. dollar reserves. 

🧭 So Who Really Pays? 

Here’s the simplest breakdown: 

Group	How They “Pay”
U.S. consumers	Buy imports → dollars flow abroad
Foreign investors	Send capital back → finance the deficit
U.S. workers	Job/wage pressure in import‑competing sectors
Future taxpayers	Service debt bought by foreign investors
Foreign exporters	Accept dollars instead of goods

No single group writes a check for $901.5 billion. Instead, there is a global balance between consumption, investment, and debt flows. 

The U.S. trade gap barely narrowed to about $901.5 billion in 2025 even though tariffs were in place because imports rose to a record high, exports were uneven (with some large one‑off swings), and the tariff effects were offset by other stronger forces in the economy.  

Key reasons the deficit stayed large in 2025 

• Record imports and consumer demand. U.S. imports increased in 2025 (about +4.8% for the year), led by electronics and other durable goods, which pushed import values higher despite tariffs.  

• Tariffs changed trade patterns but didn’t eliminate demand. Tariffs redirected some sourcing away from China toward other Asian suppliers (Vietnam, Taiwan) and raised prices, but they did not stop overall import growth; businesses and consumers continued buying imported goods.  

• One‑off and compositional effects in exports. A large, unusual rise in nonmonetary gold exports and other specific items distorted year‑over‑year export totals, making the headline deficit look only slightly smaller. Those quirks mask the underlying import strength.  

• Timing and front‑loading. Firms sometimes front‑load purchases ahead of tariff changes or shift sourcing in ways that temporarily increase import volumes; monthly swings (e.g., big deficits in late 2025) reflect that timing.  

• Macroeconomic and policy offsets. Exchange rates, domestic growth, and energy trade also matter; stronger U.S. demand and a dollar that remained relatively supportive of imports limited the ability of tariffs alone to shrink the deficit.  

Quick comparison: 2025 drivers vs 2026 expectations 

Driver	2025 effect	Why it mattered	2026 expectation
Imports	Record high; +4.8% annual rise	Strong consumer/business demand; electronics and computers led imports	Likely to remain high but growth may slow as tariff front‑loading fades; sensitive to U.S. growth.
Exports	Mixed; boosted by nonmonetary gold spike	One‑off items masked underlying export weakness	Exports may recover modestly if global demand improves; volatile month‑to‑month.
Tariffs	Shifted suppliers; limited reduction in import volumes	Raised costs and changed trade partners but didn’t cut overall import demand	Tariff effects likely to fade as firms adapt; impact on deficit modest in 2026.
Macro factors	Strong U.S. demand; exchange rate and energy flows important	Growth and dollar influence import prices and volumes	If U.S. growth slows and inflation eases, deficit growth could moderate.

Outlook for the U.S. trade deficit in 2026 (practical scenarios) 

• Baseline (most likely): The deficit moderates but remains large. Tariff‑related distortions and front‑loading fade, imports keep growing but at a slower pace, and exports recover slowly — producing a somewhat smaller or similar deficit to 2025 rather than a dramatic drop.  

• Downside (wider deficit): If U.S. consumer spending stays strong or the dollar strengthens, imports could accelerate again and widen the gap. Short‑term shocks (e.g., supply chain disruptions) could also push imports up.  

• Upside (smaller deficit): If U.S. growth slows materially, domestic demand for imports falls, and global demand for U.S. exports strengthens, the deficit could shrink more noticeably. Policy changes that reduce tariffs or improve export competitiveness would also help.  

What to watch (indicators that will determine the 2026 path) 

• Monthly trade reports (imports, exports, and the goods vs services split).  

• U.S. GDP and consumer spending data — weaker spending usually reduces import growth.  

• Exchange‑rate moves (dollar strength makes imports cheaper in dollar terms and can widen the deficit).  

• Commodity and one‑off items (e.g., gold, energy) that can swing export values.  

• Trade policy signals (new tariffs, exemptions, or trade agreements) and corporate sourcing decisions.  

Bottom line 

Tariffs alone did not and could not erase the structural forces driving a large U.S. trade deficit in 2025: strong import demand, substitution of suppliers, and volatile export composition (including a big gold export swing) kept the gap near $901.5 billion. For 2026, expect moderation rather than a dramatic reversal — the deficit will be shaped by U.S. growth, the dollar, and whether tariff‑related distortions unwind or persist. Monitor monthly trade releases and macro indicators to see which scenario unfolds. 

AI is already automating tasks across white‑ and blue‑collar work. Roles that are routine, pattern‑based, data‑intensive, or highly repeatable face the highest near‑term displacement risk; roles requiring complex human judgment, manual dexterity in unpredictable environments, or deep interpersonal care are more resistant. Recent industry analyses and policy reports identify dozens of specific occupations at elevated risk this year and over the next several years.  

Quick comparison table of most relevant job attributes 

Job Category	Examples	Risk Level	Why at Risk	Timeline
Administrative and clerical	Data entry clerks; payroll clerks; schedulers	High	Task automation, document parsing, scheduling by LLMs and RPA	2026–2028
Customer service and sales support	Call center agents; telemarketers; chat support	High	Conversational AI, chatbots, voice agents replacing scripted interactions	2026–2027
Content creation and basic writing	Routine copywriters; product descriptions; basic reporting	High to Medium	Generative AI produces drafts, summaries, and marketing copy quickly	2026–2029
Finance and legal support	Bookkeepers; paralegals; contract reviewers	Medium to High	Document review, contract analysis, bookkeeping automation	2026–2029
Transportation and logistics	Dispatchers; some freight coordination roles	Medium	Route optimization and autonomous systems reduce coordination roles	2027–2030
Retail and food service	Cashiers; order takers; inventory clerks	Medium	Self‑checkout, automated kiosks, inventory robots	2026–2029
Manufacturing repetitive tasks	Assembly line operators for routine tasks	Medium	Robotics and vision systems automate repetitive manufacturing work	2026–2030
Specialized creative and expert roles	Senior designers; doctors; therapists	Low	Require complex judgment, ethics, hands‑on care, or deep creativity	Long term or augmentation-focused

Which specific occupations are repeatedly flagged by recent analyses 

• Data entry, telemarketing, basic customer support, routine legal document review, and simple content generation appear across multiple industry lists as high‑risk in the near term.  

• Several corporate studies and media summaries list about 30–40 occupations that are most exposed to current generative AI and automation tools.  

Why these jobs are vulnerable 

• Task substitutability: If a job is mostly predictable steps, pattern recognition, or text/data manipulation, AI models and robotic process automation can perform it faster and cheaper.  

• Rapid improvements in generative models: Large language models and multimodal systems now handle drafting, summarizing, coding, and conversational tasks at scale, reducing demand for routine human labor.  

• Cost incentives for employers: Firms adopt AI to cut labor costs and increase throughput, accelerating displacement where automation is straightforward.  

Likely timeline and scale 

• 2026: Acceleration of displacement in clerical, customer support, and basic content roles as off‑the‑shelf AI tools are widely deployed.  

• 2027–2029: Broader impacts in finance support, retail, and some logistics as integrations and robotics mature.  

• 2030 and beyond: Continued automation of more complex tasks, but also job creation in AI development, oversight, maintenance, and human‑centric roles; net effects will depend on policy, retraining, and business choices.  

Who is less likely to lose jobs and why 

• Jobs requiring complex interpersonal care, unpredictable manual work, or high‑stakes judgment (e.g., frontline healthcare clinicians, skilled trades, therapists, senior managers) are more resistant because AI currently augments rather than fully replaces those capabilities.  

Practical steps for workers and employers 

For workers 

• Prioritize transferable skills: critical thinking, complex problem solving, people management, and digital literacy. 

• Upskill into AI‑complementary roles: prompt engineering, AI supervision, data labeling, model auditing, and domain expertise that guides AI outputs. 

• Shift toward tasks AI struggles with negotiation, empathy‑based care, creative leadership, and hands‑on technical trades. 

For employers and policymakers 

• Invest in reskilling programs and wage‑subsidized transitions for displaced workers. 

• Adopt human‑in‑the‑loop models that use AI to augment productivity while preserving meaningful human roles. 

• Consider phased automation and social safety nets to reduce abrupt displacement.  

Risks, uncertainties, and what to watch 

• Model capability leaps can shift which jobs are at risk faster than forecasts predict.  

• Adoption speed depends on regulation, labor costs, and corporate strategy; some sectors may resist rapid automation.  

• Net job numbers are uncertain: many studies show both displacement and new job creation; outcomes hinge on policy and retraining scale.