Open lucahttp opened 1 week ago
I has been working on a solution that seems that works, https://github.com/lucahttp/Power-Fx-.NET-Interactive and the latest tries are here https://github.com/lucahttp/PowerFXPolyglot
but for some reason it says after compile that there is not ClearCollect command available for PowerFX
System.AggregateException: One or more errors occurred. (Errors: Error 21-22: Caracteres inesperados. La fórmula contiene "Error" donde se esperaba "ParenClose".
Error 21-22: Caracteres inesperados. Se usan caracteres en la fórmula de forma inesperada.
Error 12-13: 'ClearCollect' is an unknown or unsupported function.
Error 13-21: El nombre no es válido. No se reconoce "Products".)
---> System.InvalidOperationException: Errors: Error 21-22: Caracteres inesperados. La fórmula contiene "Error" donde se esperaba "ParenClose".
Error 21-22: Caracteres inesperados. Se usan caracteres en la fórmula de forma inesperada.
Error 12-13: 'ClearCollect' is an unknown or unsupported function.
Error 13-21: El nombre no es válido. No se reconoce "Products".
at Microsoft.PowerFx.CheckResult.ThrowOnErrors()
at Microsoft.PowerFx.RecalcEngine.EvalAsync(String expressionText, CancellationToken cancellationToken, ParserOptions options, ReadOnlySymbolTable symbolTable, RuntimeConfig runtimeConfig)
at Microsoft.PowerFx.RecalcEngine.EvalAsync(String expressionText, CancellationToken cancellationToken, RecordValue parameters, ParserOptions options)
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
at Microsoft.PowerFx.RecalcEngine.Eval(String expressionText, RecordValue parameters, ParserOptions options)
at PowerFxDotnetInteractive.PowerFxExpression.EvaluateSingleExpression(String originalExpression, String expression, ReadOnlySymbolValues symbolValues)
at PowerFxDotnetInteractive.PowerFxExpression.<>c__DisplayClass9_0.<Evaluate>b__0(String expression)
at System.Linq.Enumerable.SelectArrayIterator`2.Fill(ReadOnlySpan`1 source, Span`1 destination, Func`2 func)
at System.Linq.Enumerable.SelectArrayIterator`2.ToList()
at PowerFxDotnetInteractive.PowerFxExpression.Evaluate(ReadOnlySymbolValues symbolValues)
at PowerFxDotnetInteractive.PowerFxKernel.HandleAsync(SubmitCode submitCode, KernelInvocationContext context)
at Microsoft.DotNet.Interactive.Kernel.<>c__DisplayClass82_0`1.<SetHandler>b__0(KernelCommand _, KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\Kernel.cs:line 878
at Microsoft.DotNet.Interactive.Commands.KernelCommand.InvokeAsync(KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\Commands\KernelCommand.cs:line 189
at Microsoft.DotNet.Interactive.Kernel.HandleAsync(KernelCommand command, KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\Kernel.cs:line 330
at Microsoft.DotNet.Interactive.KernelCommandPipeline.<BuildPipeline>b__6_0(KernelCommand command, KernelInvocationContext context, KernelPipelineContinuation _) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 60
at Microsoft.DotNet.Interactive.KernelCommandPipeline.SendAsync(KernelCommand command, KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 41```
I'm receiving the following error inside Polyglot notebooks, tbh im not experimented on C Sharp or Nuget Packages
seems that is trying to get libraries that have higher versions that the last published, for example the one of dataverse
requested: version (>= 1.3.0-build.20240423-1001) latest: Microsoft.PowerFx.Dataverse.Eval 1.2.0-build.20231002-1005 url
i was thinking to rebuild the lib following this example
Install Power Fx - Local Build
i nuget:D:\GitHub\Power-Fx-.NET-Interactive\src\bin\Debug\
r "nuget:PowerFx.NET.Interactive"
but I have another questions, how to build this D:\GitHub\Power-Fx-.NET-Interactive\src\bin\Debug\ what I need, the csharp sdk and run a donet build or something like that?