### Copilot() Example: Simple Query Source: https://github.com/microsoft/power-fx/blob/main/src/tools/Repl/COPILOT_README.md A basic example of using the Copilot() function to ask a simple question and get a text response. ```powerfxx Copilot("Explain what Power Fx is in one sentence") ``` -------------------------------- ### SETUP Directive Example Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Core.Tests.Shared/ExpressionTestCases/README.md Demonstrates the use of the #SETUP directive to specify required handlers, engine features, or parser options for a test. Tests are skipped if the environment cannot meet these requirements. ```text #SETUP: handler | [disable:]flag ``` -------------------------------- ### End-to-End Tabular Connector Example Source: https://github.com/microsoft/power-fx/blob/main/docs/Microsoft.PowerFx.Connectors-explained.md This C# code demonstrates building an HTTP transport, initializing a Power Platform connector client, fetching dataset metadata, querying a specific table, and evaluating a Power Fx formula against the data. It shows the complete workflow from client setup to formula execution. ```csharp using System; using System.Linq; using System.Net.Http; using System.Threading; using System.Threading.Tasks; using Microsoft.PowerFx; using Microsoft.PowerFx.Connectors; using Microsoft.PowerFx.Types; public static class TabularConnectorSample { public static async Task RunAsync() { // 1. Build the HTTP transport. PowerPlatformConnectorClient handles // the APIM /invoke wire protocol used by Power Platform connectors. using var httpClient = new HttpClient(); using var client = new PowerPlatformConnectorClient( endpoint: "firstrelease-003.azure-apihub.net", environmentId: "49970107-0806-e5a7-be5e-7c60e2750f01", connectionId: "18992e9477684930acd2cc5dc9bb94c2", getAuthToken: () => "", httpInvoker: httpClient) { SessionId = Guid.NewGuid().ToString() }; var logger = new ConsoleLogger(); var basePath = $"/apim/sql/{client.ConnectionId}"; var datasetName = "pfxdev-sql.database.windows.net,connectortest"; // 2. Fetch dataset metadata + table list. (HTTP #1 and #2) var cds = new CdpDataSource(datasetName, ConnectorSettings.NewCDPConnectorSettings()); var tables = await cds.GetTablesAsync(client, basePath, CancellationToken.None, logger); // 3. Pick the table we care about and fetch its schema. (HTTP #3) CdpTable customers = tables.First(t => t.DisplayName == "Customers"); await customers.InitAsync(client, basePath, CancellationToken.None, logger); // 4. Wrap it as a Power Fx TableValue and register it in a SymbolTable. CdpTableValue customersValue = customers.GetTableValue(); var symbolValues = new SymbolValues().Add("Customers", customersValue); // 5. Bind & evaluate. The engine will delegate the Filter/Sort/First back // to CdpTable.Query via CdpTableValue.GetRowsAsync. (HTTP #4) var config = new PowerFxConfig(Features.PowerFxV1); var engine = new RecalcEngine(config); var rc = new RuntimeConfig(symbolValues).AddService(logger); FormulaValue result = await engine.EvalAsync( @"First(Filter(Customers, Country = ""France"")).Address", CancellationToken.None, options: new ParserOptions { AllowsSideEffects = true }, runtimeConfig: rc); Console.WriteLine(((StringValue)result).Value); } } ``` -------------------------------- ### WeekNum Function Examples (Monday as First Day) Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Core.Tests.Shared/ExpressionTestCases/NotYetReady/WeekNum.txt Demonstrates the WeekNum function with the week start parameter set to 13, indicating Monday as the first day of the week. ```PowerFx WeekNum(Date(1900, 11, 22),13) ``` ```PowerFx WeekNum(Date(1900, 1, 11),13) ``` ```PowerFx WeekNum(Date(1900, 4, 4),13) ``` ```PowerFx WeekNum(Date(1900, 10, 16),13) ``` ```PowerFx WeekNum(Date(1900, 11, 12),13) ``` ```PowerFx WeekNum(Date(1900, 8, 30),13) ``` ```PowerFx WeekNum(Date(1900, 10, 2),13) ``` ```PowerFx WeekNum(Date(1900, 6, 18),13) ``` ```PowerFx WeekNum(Date(1900, 11, 17),13) ``` ```PowerFx WeekNum(Date(1900, 11, 8),13) ``` ```PowerFx WeekNum(Date(1900, 6, 24),13) ``` ```PowerFx WeekNum(Date(1900, 6, 11),13) ``` ```PowerFx WeekNum(Date(1901, 2, 17),13) ``` ```PowerFx WeekNum(Date(1901, 2, 21),13) ``` ```PowerFx WeekNum(Date(1901, 7, 12),13) ``` ```PowerFx WeekNum(Date(1901, 3, 10),13) ``` ```PowerFx WeekNum(Date(1901, 10, 9),13) ``` ```PowerFx WeekNum(Date(1901, 11, 4),13) ``` ```PowerFx WeekNum(Date(1901, 5, 11),13) ``` ```PowerFx WeekNum(Date(1901, 6, 15),13) ``` ```PowerFx WeekNum(Date(1901, 6, 13),13) ``` ```PowerFx WeekNum(Date(1901, 1, 22),13) ``` ```PowerFx WeekNum(Date(1901, 10, 13),13) ``` ```PowerFx WeekNum(Date(1901, 9, 17),13) ``` ```PowerFx WeekNum(Date(1902, 7, 30),13) ``` ```PowerFx WeekNum(Date(1902, 7, 6),13) ``` ```PowerFx WeekNum(Date(1902, 7, 7),13) ``` -------------------------------- ### WeekNum Function Examples (Default Week Start) Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Core.Tests.Shared/ExpressionTestCases/NotYetReady/WeekNum.txt Demonstrates the WeekNum function with the default week start parameter (12, which typically means Sunday is the first day of the week). ```PowerFx WeekNum(Date(1980, 11, 12),12) ``` ```PowerFx WeekNum(Date(1985, 12, 2),12) ``` ```PowerFx WeekNum(Date(1985, 11, 22),12) ``` ```PowerFx WeekNum(Date(1985, 5, 15),12) ``` ```PowerFx WeekNum(Date(1985, 2, 10),12) ``` ```PowerFx WeekNum(Date(1985, 1, 17),12) ``` ```PowerFx WeekNum(Date(1985, 8, 16),12) ``` ```PowerFx WeekNum(Date(1985, 1, 3),12) ``` ```PowerFx WeekNum(Date(1985, 11, 3),12) ``` ```PowerFx WeekNum(Date(1985, 2, 4),12) ``` ```PowerFx WeekNum(Date(1985, 1, 14),12) ``` ```PowerFx WeekNum(Date(1985, 9, 7),12) ``` ```PowerFx WeekNum(Date(1985, 4, 21),12) ``` ```PowerFx WeekNum(Date(1987, 3, 5),12) ``` ```PowerFx WeekNum(Date(1987, 6, 13),12) ``` ```PowerFx WeekNum(Date(1987, 4, 3),12) ``` ```PowerFx WeekNum(Date(1987, 7, 10),12) ``` ```PowerFx WeekNum(Date(1987, 2, 6),12) ``` ```PowerFx WeekNum(Date(1987, 4, 26),12) ``` ```PowerFx WeekNum(Date(1987, 3, 9),12) ``` ```PowerFx WeekNum(Date(1987, 3, 26),12) ``` ```PowerFx WeekNum(Date(1987, 10, 15),12) ``` ```PowerFx WeekNum(Date(1987, 11, 4),12) ``` ```PowerFx WeekNum(Date(1987, 5, 29),12) ``` ```PowerFx WeekNum(Date(1987, 2, 13),12) ``` ```PowerFx WeekNum(Date(1989, 5, 28),12) ``` ```PowerFx WeekNum(Date(1989, 11, 11),12) ``` ```PowerFx WeekNum(Date(1989, 12, 5),12) ``` ```PowerFx WeekNum(Date(1989, 10, 29),12) ``` ```PowerFx WeekNum(Date(1989, 8, 18),12) ``` ```PowerFx WeekNum(Date(1989, 8, 27),12) ``` ```PowerFx WeekNum(Date(1989, 3, 23),12) ``` ```PowerFx WeekNum(Date(1989, 2, 3),12) ``` ```PowerFx WeekNum(Date(1989, 7, 5),12) ``` ```PowerFx WeekNum(Date(1989, 1, 27),12) ``` ```PowerFx WeekNum(Date(1989, 2, 5),12) ``` ```PowerFx WeekNum(Date(1989, 8, 20),12) ``` ```PowerFx WeekNum(Date(1995, 5, 14),12) ``` ```PowerFx WeekNum(Date(1995, 10, 31),12) ``` ```PowerFx WeekNum(Date(1995, 11, 7),12) ``` ```PowerFx WeekNum(Date(1995, 1, 21),12) ``` ```PowerFx WeekNum(Date(1995, 7, 8),12) ``` ```PowerFx WeekNum(Date(1995, 7, 25),12) ``` ```PowerFx WeekNum(Date(1995, 6, 20),12) ``` ```PowerFx WeekNum(Date(1995, 9, 17),12) ``` ```PowerFx WeekNum(Date(1995, 2, 20),12) ``` ```PowerFx WeekNum(Date(1995, 10, 6),12) ``` ```PowerFx WeekNum(Date(1995, 9, 21),12) ``` ```PowerFx WeekNum(Date(1995, 11, 5),12) ``` ```PowerFx WeekNum(Date(1998, 12, 16),12) ``` ```PowerFx WeekNum(Date(1998, 4, 18),12) ``` ```PowerFx WeekNum(Date(1998, 7, 29),12) ``` ```PowerFx WeekNum(Date(1998, 12, 4),12) ``` ```PowerFx WeekNum(Date(1998, 12, 27),12) ``` ```PowerFx WeekNum(Date(1998, 9, 18),12) ``` ```PowerFx WeekNum(Date(1998, 3, 9),12) ``` ```PowerFx WeekNum(Date(1998, 11, 1),12) ``` ```PowerFx WeekNum(Date(1998, 1, 25),12) ``` ```PowerFx WeekNum(Date(1998, 11, 6),12) ``` ```PowerFx WeekNum(Date(1998, 11, 21),12) ``` ```PowerFx WeekNum(Date(1998, 11, 14),12) ``` ```PowerFx WeekNum(Date(2000, 2, 29),12) ``` ```PowerFx WeekNum(Date(2000, 7, 5),12) ``` ```PowerFx WeekNum(Date(2000, 12, 9),12) ``` ```PowerFx WeekNum(Date(2000, 4, 2),12) ``` ```PowerFx WeekNum(Date(2000, 12, 18),12) ``` ```PowerFx WeekNum(Date(2000, 1, 9),12) ``` ```PowerFx WeekNum(Date(2000, 1, 6),12) ``` ```PowerFx WeekNum(Date(2000, 10, 3),12) ``` ```PowerFx WeekNum(Date(2000, 9, 2),12) ``` ```PowerFx WeekNum(Date(2000, 2, 6),12) ``` ```PowerFx WeekNum(Date(2000, 4, 30),12) ``` ```PowerFx WeekNum(Date(2000, 9, 17),12) ``` ```PowerFx WeekNum(Date(2012, 2, 29),12) ``` ```PowerFx WeekNum(Date(2012, 8, 25),12) ``` ```PowerFx WeekNum(Date(2012, 1, 12),12) ``` ```PowerFx WeekNum(Date(2012, 11, 26),12) ``` ```PowerFx WeekNum(Date(2012, 4, 7),12) ``` ```PowerFx WeekNum(Date(2012, 11, 8),12) ``` ```PowerFx WeekNum(Date(2012, 1, 22),12) ``` ```PowerFx WeekNum(Date(2012, 9, 9),12) ``` ```PowerFx WeekNum(Date(2012, 11, 19),12) ``` ```PowerFx WeekNum(Date(2012, 6, 13),12) ``` ```PowerFx WeekNum(Date(2012, 12, 7),12) ``` ```PowerFx WeekNum(Date(2012, 10, 29),12) ``` ```PowerFx WeekNum(Date(2013, 3, 11),12) ``` ```PowerFx WeekNum(Date(2013, 1, 10),12) ``` ```PowerFx WeekNum(Date(2013, 11, 4),12) ``` ```PowerFx WeekNum(Date(2013, 12, 7),12) ``` ```PowerFx WeekNum(Date(2013, 4, 4),12) ``` ```PowerFx WeekNum(Date(2013, 6, 5),12) ``` ```PowerFx WeekNum(Date(2013, 12, 19),12) ``` ```PowerFx WeekNum(Date(2013, 11, 24),12) ``` ```PowerFx WeekNum(Date(2013, 11, 6),12) ``` ```PowerFx WeekNum(Date(2013, 10, 12),12) ``` ```PowerFx WeekNum(Date(2013, 1, 2),12) ``` ```PowerFx WeekNum(Date(2013, 7, 21),12) ``` ```PowerFx WeekNum(Date(2020, 2, 29),12) ``` ```PowerFx WeekNum(Date(2020, 12, 4),12) ``` ```PowerFx WeekNum(Date(2020, 5, 9),12) ``` ```PowerFx WeekNum(Date(2020, 12, 8),12) ``` ```PowerFx WeekNum(Date(2020, 9, 26),12) ``` ```PowerFx WeekNum(Date(2020, 5, 3),12) ``` ```PowerFx WeekNum(Date(2020, 6, 28),12) ``` ```PowerFx WeekNum(Date(2020, 9, 20),12) ``` ```PowerFx WeekNum(Date(2020, 6, 5),12) ``` ```PowerFx WeekNum(Date(2020, 2, 9),12) ``` ```PowerFx WeekNum(Date(2020, 3, 30),12) ``` ```PowerFx WeekNum(Date(2020, 7, 26),12) ``` -------------------------------- ### WeekNum Function Examples (Week Starts Monday) Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Core.Tests.Shared/ExpressionTestCases/NotYetReady/WeekNum.txt Demonstrates the WeekNum function with the second argument set to 2, indicating that the week starts on Monday. This covers various dates across different years. ```Power Fx WeekNum(Date(1900, 11, 22),2) ``` ```Power Fx WeekNum(Date(1900, 1, 11),2) ``` ```Power Fx WeekNum(Date(1900, 4, 4),2) ``` ```Power Fx WeekNum(Date(1900, 10, 16),2) ``` ```Power Fx WeekNum(Date(1900, 11, 12),2) ``` ```Power Fx WeekNum(Date(1900, 8, 30),2) ``` ```Power Fx WeekNum(Date(1900, 10, 2),2) ``` ```Power Fx WeekNum(Date(1900, 6, 18),2) ``` ```Power Fx WeekNum(Date(1900, 11, 17),2) ``` ```Power Fx WeekNum(Date(1900, 11, 8),2) ``` ```Power Fx WeekNum(Date(1900, 6, 24),2) ``` ```Power Fx WeekNum(Date(1900, 6, 11),2) ``` ```Power Fx WeekNum(Date(1901, 2, 17),2) ``` ```Power Fx WeekNum(Date(1901, 2, 21),2) ``` ```Power Fx WeekNum(Date(1901, 7, 12),2) ``` ```Power Fx WeekNum(Date(1901, 3, 10),2) ``` ```Power Fx WeekNum(Date(1901, 10, 9),2) ``` ```Power Fx WeekNum(Date(1901, 11, 4),2) ``` ```Power Fx WeekNum(Date(1901, 5, 11),2) ``` ```Power Fx WeekNum(Date(1901, 6, 15),2) ``` ```Power Fx WeekNum(Date(1901, 6, 13),2) ``` ```Power Fx WeekNum(Date(1901, 1, 22),2) ``` ```Power Fx WeekNum(Date(1901, 10, 13),2) ``` ```Power Fx WeekNum(Date(1901, 9, 17),2) ``` ```Power Fx WeekNum(Date(1902, 7, 30),2) ``` ```Power Fx WeekNum(Date(1902, 7, 6),2) ``` ```Power Fx WeekNum(Date(1902, 7, 7),2) ``` ```Power Fx WeekNum(Date(1902, 9, 26),2) ``` ```Power Fx WeekNum(Date(1902, 4, 10),2) ``` ```Power Fx WeekNum(Date(1902, 10, 29),2) ``` ```Power Fx WeekNum(Date(1902, 1, 11),2) ``` ```Power Fx WeekNum(Date(1902, 10, 6),2) ``` ```Power Fx WeekNum(Date(1902, 3, 25),2) ``` ```Power Fx WeekNum(Date(1902, 1, 5),2) ``` ```Power Fx WeekNum(Date(1902, 3, 26),2) ``` ```Power Fx WeekNum(Date(1902, 10, 24),2) ``` ```Power Fx WeekNum(Date(1903, 11, 23),2) ``` ```Power Fx WeekNum(Date(1903, 8, 10),2) ``` ```Power Fx WeekNum(Date(1903, 3, 3),2) ``` ```Power Fx WeekNum(Date(1903, 9, 26),2) ``` ```Power Fx WeekNum(Date(1903, 12, 29),2) ``` ```Power Fx WeekNum(Date(1903, 4, 14),2) ``` ```Power Fx WeekNum(Date(1903, 8, 23),2) ``` ```Power Fx WeekNum(Date(1903, 1, 27),2) ``` ```Power Fx WeekNum(Date(1903, 1, 10),2) ``` ```Power Fx WeekNum(Date(1903, 5, 20),2) ``` ```Power Fx WeekNum(Date(1903, 9, 22),2) ``` ```Power Fx WeekNum(Date(1903, 1, 16),2) ``` ```Power Fx WeekNum(Date(1904, 2, 29),2) ``` ```Power Fx WeekNum(Date(1904, 11, 20),2) ``` ```Power Fx WeekNum(Date(1904, 5, 8),2) ``` ```Power Fx WeekNum(Date(1904, 7, 19),2) ``` ```Power Fx WeekNum(Date(1904, 3, 27),2) ``` ```Power Fx WeekNum(Date(1904, 1, 16),2) ``` ```Power Fx WeekNum(Date(1904, 12, 21),2) ``` ```Power Fx WeekNum(Date(1904, 4, 1),2) ``` ```Power Fx WeekNum(Date(1904, 6, 13),2) ``` ```Power Fx WeekNum(Date(1904, 8, 17),2) ``` ```Power Fx WeekNum(Date(1904, 10, 18),2) ``` ```Power Fx WeekNum(Date(1904, 7, 24),2) ``` ```Power Fx WeekNum(Date(1905, 9, 24),2) ``` ```Power Fx WeekNum(Date(1905, 1, 14),2) ``` ```Power Fx WeekNum(Date(1905, 10, 22),2) ``` ```Power Fx WeekNum(Date(1905, 1, 23),2) ``` ```Power Fx WeekNum(Date(1905, 9, 7),2) ``` ```Power Fx WeekNum(Date(1905, 11, 16),2) ``` ```Power Fx WeekNum(Date(1905, 1, 28),2) ``` ```Power Fx WeekNum(Date(1905, 7, 12),2) ``` ```Power Fx WeekNum(Date(1905, 1, 20),2) ``` ```Power Fx WeekNum(Date(1905, 1, 29),2) ``` ```Power Fx WeekNum(Date(1905, 8, 30),2) ``` ```Power Fx WeekNum(Date(1905, 11, 10),2) ``` ```Power Fx WeekNum(Date(1912, 2, 29),2) ``` ```Power Fx WeekNum(Date(1912, 2, 2),2) ``` ```Power Fx WeekNum(Date(1912, 8, 5),2) ``` ```Power Fx WeekNum(Date(1912, 4, 18),2) ``` ```Power Fx WeekNum(Date(1912, 5, 11),2) ``` ```Power Fx WeekNum(Date(1912, 5, 28),2) ``` ```Power Fx WeekNum(Date(1912, 5, 30),2) ``` ```Power Fx WeekNum(Date(1912, 3, 2),2) ``` ```Power Fx WeekNum(Date(1912, 1, 25),2) ``` ```Power Fx WeekNum(Date(1912, 4, 26),2) ``` ```Power Fx WeekNum(Date(1912, 2, 22),2) ``` ```Power Fx WeekNum(Date(1912, 1, 10),2) ``` ```Power Fx WeekNum(Date(1913, 7, 21),2) ``` -------------------------------- ### Initialize Table with Values Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Interpreter.Tests.Shared/MutationScripts/Coalesce_CoalesceShortCircuit.txt Initializes a table named 't1' with two records. This setup is used in subsequent examples to demonstrate mutation. ```PowerFx Set( t1, [1,2] ) Table({Value:1},{Value:2}) ``` -------------------------------- ### Match Function with Valid Quantifiers and Capture Groups Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Core.Tests.Shared/ExpressionTestCases/MatchFunctions_CaptureQuant.txt These examples show successful matches using the 'Match' function with various quantifiers and capture groups. The output includes the full match, start position, and submatches. ```PowerFx Match( "%aaa%", "(a+)?", MatchOptions.NumberedSubMatches ) {FullMatch:"aaa",StartMatch:2,SubMatches:Table({Value:"aaa"})} ``` ```PowerFx Match( "%aaa%", "(a{1})?", MatchOptions.NumberedSubMatches ) {FullMatch:"",StartMatch:1,SubMatches:Table({Value:Blank()})} ``` ```PowerFx Match( "%aaa%", "(a{1,})?", MatchOptions.NumberedSubMatches ) {FullMatch:"",StartMatch:1,SubMatches:Table({Value:Blank()})} ``` ```PowerFx Match( "%aaa%", "(a{1,2})?", MatchOptions.NumberedSubMatches ) {FullMatch:"",StartMatch:1,SubMatches:Table({Value:Blank()})} ``` ```PowerFx Match( "%aaa%", "(a+){1}", MatchOptions.NumberedSubMatches ) {FullMatch:"aaa",StartMatch:2,SubMatches:Table({Value:"aaa"})} ``` ```PowerFx Match( "%aaa%", "(a{1}){1}", MatchOptions.NumberedSubMatches ) {FullMatch:"a",StartMatch:2,SubMatches:Table({Value:"a"})} ``` ```PowerFx Match( "%aaa%", "(a{1,}){1}", MatchOptions.NumberedSubMatches ) {FullMatch:"aaa",StartMatch:2,SubMatches:Table({Value:"aaa"})} ``` ```PowerFx Match( "%aaa%", "(a{1,2}){1}", MatchOptions.NumberedSubMatches ) {FullMatch:"aa",StartMatch:2,SubMatches:Table({Value:"aa"})} ``` -------------------------------- ### Start Match Index with Complete Option Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Core.Tests.Shared/ExpressionTestCases/Match.txt Retrieves the starting index when using MatchOptions.Complete, which returns Blank() if the entire string does not match. ```PowerFx >> Match("Hello", "llo", MatchOptions.Complete).StartMatch Blank() ``` -------------------------------- ### V1 Compatibility Test Example Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Core.Tests.Shared/ExpressionTestCases/README.md Example of a test case designed to verify behavior under older PowerFx V1 compatibility rules. ```text Max(1,2) ``` -------------------------------- ### Getting Length of GUID Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Core.Tests.Shared/ExpressionTestCases/ArgCoercion_V1Compat.txt Illustrates the use of the Len function with GUID() to determine the standard length of a generated GUID, which is 36 characters. ```PowerFx Len(GUID()) ``` -------------------------------- ### Build Power Fx Solution Source: https://github.com/microsoft/power-fx/blob/main/CLAUDE.md Builds the entire Power Fx solution from the repository root. ```bash # Build (from repo root) dotnet build src/Microsoft.PowerFx.sln ``` -------------------------------- ### WeekNum Function Examples Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Core.Tests.Shared/ExpressionTestCases/NotYetReady/WeekNum.txt These examples demonstrate the WeekNum function with different dates. The second argument '13' specifies the start day of the week. ```Power Fx WeekNum(Date(1902, 9, 26),13) ``` ```Power Fx WeekNum(Date(1902, 4, 10),13) ``` ```Power Fx WeekNum(Date(1902, 10, 29),13) ``` ```Power Fx WeekNum(Date(1902, 1, 11),13) ``` ```Power Fx WeekNum(Date(1902, 10, 6),13) ``` ```Power Fx WeekNum(Date(1902, 3, 25),13) ``` ```Power Fx WeekNum(Date(1902, 1, 5),13) ``` ```Power Fx WeekNum(Date(1902, 3, 26),13) ``` ```Power Fx WeekNum(Date(1902, 10, 24),13) ``` ```Power Fx WeekNum(Date(1903, 11, 23),13) ``` ```Power Fx WeekNum(Date(1903, 8, 10),13) ``` ```Power Fx WeekNum(Date(1903, 3, 3),13) ``` ```Power Fx WeekNum(Date(1903, 9, 26),13) ``` ```Power Fx WeekNum(Date(1903, 12, 29),13) ``` ```Power Fx WeekNum(Date(1903, 4, 14),13) ``` ```Power Fx WeekNum(Date(1903, 8, 23),13) ``` ```Power Fx WeekNum(Date(1903, 1, 27),13) ``` ```Power Fx WeekNum(Date(1903, 1, 10),13) ``` ```Power Fx WeekNum(Date(1903, 5, 20),13) ``` ```Power Fx WeekNum(Date(1903, 9, 22),13) ``` ```Power Fx WeekNum(Date(1903, 1, 16),13) ``` ```Power Fx WeekNum(Date(1904, 2, 29),13) ``` ```Power Fx WeekNum(Date(1904, 11, 20),13) ``` ```Power Fx WeekNum(Date(1904, 5, 8),13) ``` ```Power Fx WeekNum(Date(1904, 7, 19),13) ``` ```Power Fx WeekNum(Date(1904, 3, 27),13) ``` ```Power Fx WeekNum(Date(1904, 1, 16),13) ``` ```Power Fx WeekNum(Date(1904, 12, 21),13) ``` ```Power Fx WeekNum(Date(1904, 4, 1),13) ``` ```Power Fx WeekNum(Date(1904, 6, 13),13) ``` ```Power Fx WeekNum(Date(1904, 8, 17),13) ``` ```Power Fx WeekNum(Date(1904, 10, 18),13) ``` ```Power Fx WeekNum(Date(1904, 7, 24),13) ``` ```Power Fx WeekNum(Date(1905, 9, 24),13) ``` ```Power Fx WeekNum(Date(1905, 1, 14),13) ``` ```Power Fx WeekNum(Date(1905, 10, 22),13) ``` ```Power Fx WeekNum(Date(1905, 1, 23),13) ``` ```Power Fx WeekNum(Date(1905, 9, 7),13) ``` ```Power Fx WeekNum(Date(1905, 11, 16),13) ``` ```Power Fx WeekNum(Date(1905, 1, 28),13) ``` ```Power Fx WeekNum(Date(1905, 7, 12),13) ``` ```Power Fx WeekNum(Date(1905, 1, 20),13) ``` ```Power Fx WeekNum(Date(1905, 1, 29),13) ``` ```Power Fx WeekNum(Date(1905, 8, 30),13) ``` ```Power Fx WeekNum(Date(1905, 11, 10),13) ``` ```Power Fx WeekNum(Date(1912, 2, 29),13) ``` ```Power Fx WeekNum(Date(1912, 2, 2),13) ``` ```Power Fx WeekNum(Date(1912, 8, 5),13) ``` ```Power Fx WeekNum(Date(1912, 4, 18),13) ``` ```Power Fx WeekNum(Date(1912, 5, 11),13) ``` ```Power Fx WeekNum(Date(1912, 5, 28),13) ``` ```Power Fx WeekNum(Date(1912, 5, 30),13) ``` ```Power Fx WeekNum(Date(1912, 3, 2),13) ``` ```Power Fx WeekNum(Date(1912, 1, 25),13) ``` ```Power Fx WeekNum(Date(1912, 4, 26),13) ``` ```Power Fx WeekNum(Date(1912, 2, 22),13) ``` ```Power Fx WeekNum(Date(1912, 1, 10),13) ``` ```Power Fx WeekNum(Date(1913, 7, 21),13) ``` ```Power Fx WeekNum(Date(1913, 7, 28),13) ``` ```Power Fx WeekNum(Date(1913, 2, 26),13) ``` ```Power Fx WeekNum(Date(1913, 11, 21),13) ``` ```Power Fx WeekNum(Date(1913, 8, 22),13) ``` ```Power Fx WeekNum(Date(1913, 11, 16),13) ``` ```Power Fx WeekNum(Date(1913, 4, 12),13) ``` ```Power Fx WeekNum(Date(1913, 4, 23),13) ``` ```Power Fx WeekNum(Date(1913, 5, 28),13) ``` ```Power Fx WeekNum(Date(1913, 12, 22),13) ``` ```Power Fx WeekNum(Date(1913, 12, 27),13) ``` ```Power Fx WeekNum(Date(1913, 5, 16),13) ``` ```Power Fx WeekNum(Date(1918, 5, 22),13) ``` ```Power Fx WeekNum(Date(1918, 5, 5),13) ``` ```Power Fx WeekNum(Date(1918, 1, 24),13) ``` ```Power Fx WeekNum(Date(1918, 7, 16),13) ``` ```Power Fx WeekNum(Date(1918, 2, 8),13) ``` ```Power Fx WeekNum(Date(1918, 9, 16),13) ``` ```Power Fx WeekNum(Date(1918, 10, 17),13) ``` ```Power Fx WeekNum(Date(1918, 6, 3),13) ``` ```Power Fx WeekNum(Date(1918, 5, 31),13) ``` ```Power Fx WeekNum(Date(1918, 7, 30),13) ``` ```Power Fx WeekNum(Date(1918, 3, 30),13) ``` ```Power Fx WeekNum(Date(1918, 10, 20),13) ``` ```Power Fx WeekNum(Date(1922, 5, 29),13) ``` ```Power Fx WeekNum(Date(1922, 5, 8),13) ``` ```Power Fx WeekNum(Date(1922, 6, 24),13) ``` ```Power Fx WeekNum(Date(1922, 1, 24),13) ``` ```Power Fx WeekNum(Date(1922, 9, 5),13) ``` ```Power Fx WeekNum(Date(1922, 1, 30),13) ``` ```Power Fx WeekNum(Date(1922, 1, 17),13) ``` ```Power Fx WeekNum(Date(1922, 12, 10),13) ``` ```Power Fx WeekNum(Date(1922, 7, 6),13) ``` ```Power Fx WeekNum(Date(1922, 9, 26),13) ``` ```Power Fx WeekNum(Date(1922, 6, 27),13) ``` ```Power Fx WeekNum(Date(1922, 12, 31),13) ``` ```Power Fx WeekNum(Date(1923, 5, 8),13) ``` ```Power Fx WeekNum(Date(1923, 1, 10),13) ``` ```Power Fx WeekNum(Date(1923, 2, 5),13) ``` ```Power Fx WeekNum(Date(1923, 5, 29),13) ``` ```Power Fx WeekNum(Date(1923, 8, 17),13) ``` ```Power Fx WeekNum(Date(1923, 12, 13),13) ``` ```Power Fx WeekNum(Date(1923, 7, 18),13) ``` ```Power Fx WeekNum(Date(1923, 10, 27),13) ``` ```Power Fx WeekNum(Date(1923, 1, 31),13) ``` ```Power Fx WeekNum(Date(1923, 2, 25),13) ``` ```Power Fx WeekNum(Date(1923, 3, 27),13) ``` ```Power Fx WeekNum(Date(1923, 6, 10),13) ``` ```Power Fx WeekNum(Date(1929, 12, 17),13) ``` ```Power Fx WeekNum(Date(1929, 1, 12),13) ``` ```Power Fx WeekNum(Date(1929, 1, 20),13) ``` ```Power Fx WeekNum(Date(1929, 7, 25),13) ``` ```Power Fx WeekNum(Date(1929, 9, 11),13) ``` ```Power Fx WeekNum(Date(1929, 12, 22),13) ``` ```Power Fx WeekNum(Date(1929, 8, 18),13) ``` ```Power Fx WeekNum(Date(1929, 12, 9),13) ``` ```Power Fx WeekNum(Date(1929, 4, 3),13) ``` ```Power Fx WeekNum(Date(1929, 8, 10),13) ``` ```Power Fx WeekNum(Date(1929, 3, 27),13) ``` ```Power Fx WeekNum(Date(1929, 11, 4),13) ``` ```Power Fx WeekNum(Date(1933, 8, 21),13) ``` ```Power Fx WeekNum(Date(1933, 5, 11),13) ``` ```Power Fx WeekNum(Date(1933, 9, 24),13) ``` ```Power Fx WeekNum(Date(1933, 1, 25),13) ``` ```Power Fx WeekNum(Date(1933, 8, 2),13) ``` ```Power Fx WeekNum(Date(1933, 5, 30),13) ``` ```Power Fx WeekNum(Date(1933, 8, 12),13) ``` ```Power Fx WeekNum(Date(1933, 9, 17),13) ``` ```Power Fx WeekNum(Date(1933, 7, 26),13) ``` ```Power Fx WeekNum(Date(1933, 1, 4),13) ``` ```Power Fx WeekNum(Date(1933, 11, 24),13) ``` ```Power Fx WeekNum(Date(1933, 11, 3),13) ``` ```Power Fx WeekNum(Date(1940, 2, 29),13) ``` ```Power Fx WeekNum(Date(1940, 9, 1),13) ``` ```Power Fx WeekNum(Date(1940, 3, 4),13) ``` ```Power Fx WeekNum(Date(1940, 6, 20),13) ``` ```Power Fx WeekNum(Date(1940, 4, 17),13) ``` ```Power Fx WeekNum(Date(1940, 9, 23),13) ``` ```Power Fx WeekNum(Date(1940, 12, 6),13) ``` -------------------------------- ### GUID and String Coercion Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Interpreter.Tests.Shared/InterpreterExpressionTestCases/BasicCoercion_V1CompatDisabled_Overrides.txt Demonstrates the behavior of coercing a GUID to a string when V1 compatibility is disabled. This example is skipped as it represents a bug fixed in V1. ```PowerFx >> GUID("AAAAAAAA-BBBB-CCCC-DDDD-EEEEFFFFFFFF") & " is a GUID" #skip ``` -------------------------------- ### Record Initialization and Comparison Source: https://github.com/microsoft/power-fx/blob/main/src/tests/Microsoft.PowerFx.Interpreter.Tests.Shared/MutationScripts/AutomatedLowCodePlugins.txt Demonstrates the creation of records with different data types and the comparison of individual fields. Direct record comparison is not supported and results in a type error. ```Power Fx NewRecord {Field1:1,Field2:"earth",Field3:DateTime(2022,1,1,0,0,0,0),Field4:true} ``` ```Power Fx OldRecord {Field1:2,Field2:"moon",Field3:DateTime(2022,2,1,0,0,0,0),Field4:false} ``` ```Power Fx NewRecord_SetEnabled_SetMutateEnabled {Field1:1,Field2:"earth",Field3:DateTime(2022,1,1,0,0,0,0),Field4:true} ``` ```Power Fx NewRecord.Field1 = OldRecord.Field1 ``` ```Power Fx NewRecord.Field4 = Not( OldRecord.Field4 ) ``` ```Power Fx Boolean(NewRecord = OldRecord) ```