Answered

How to append to table variable? (preview)

(0) Share

Report

Posted on by iCodeSometime

Hello. I'm pretty new to PowerFX in general, so not positive if this is missing functionality, or if I'm just not searching for the right keywords.

I'm asking the user for some selections using an adaptive card, splitting that into a table variable, and asking if there are more options they'd like to select (i.e. the next page of results)

From my searching, it seems like it should be something like

Collect(
 Topic.Selections, // Table Variable
 Split(Topic.NewSelections, ",")) // String variable

Or from the YAML for clarity

 - kind: SetVariable
 id: setVariable_igZwOP
 variable: Topic.Selections
 value: |
 =Collect(
 Topic.Selections, // Table Variable
 Split(Topic.NewSelections, ",")) // String variable

But I get an error that 'Collect' is an unknown or unsupported function.
Is Collect something that's just not implemented for the preview yet? Or is there a better way to do this?
In this case, I could just append to the string and split it at the end, but I'd like to figure out how table variables work.

Categories:

General

All responses (4)

Answers (1)

iCodeSometime 17 on at

Like (0)

Report
Re: How to append to table variable? (preview)

Apologies, I'd thought it was working at first, but turns out it was creating a table of tables, and I just hadn't realized.

For anyone else coming across this, here is a working version:

- kind: SetVariable id: setVariable_ELzDVx variable: Topic.loopItem value: "\"\"" - kind: Foreach id: foreach_afSDFIs items: =Split(Topic.NewSelections, ",") value: Topic.loopItem actions: - kind: EditTable id: editTable_rX8Wz9 changeType: Add itemsVariable: Topic.Selections value: "={ Value: Topic.loopItem}"
HenryJammes on at

Like (1)

Report

Re: How to append to table variable? (preview)

Awesome!
General Availability for the unified authoring canvas is next week @iCodeSometime, so production support is really just around the corner 🙂
iCodeSometime 17 on at

Like (1)

Report
Re: How to append to table variable? (preview)

Thanks so much.

I was able to get this working with
- kind: EditTable id: editTable_fEiaAp changeType: Add itemsVariable: Topic.Selections value: | =Split(Topic.NewSelections, ",")

I also discovered another new feature `- kind: Foreach`, which is cool.

I am liking this preview version so much better already, seems like it will be great. Excited for it to be released 🙂
Verified answer

HenryJammes on at

Like (0)

Report
Re: How to append to table variable? (preview)

Hi @iCodeSometime,

Indeed, you can't use Collect or Set in Power Fx in PVA.
But an update is coming to the PVA canvas to address table manipulation requirements.
In the meantime, you can probably work around this by switching to the Code Editor view:

After the node where you have your Table variable:

YAML
- kind: EditTable
      id: sendMessage_g5Ls09
      changeType: Add
      itemsVariable: Topic.YourTable
      value: "={ id: \"XXX\", name: \"XXX\" }"
I'm not sure what you're appending, so I used a 2-column record with an id and a name property.

It will show as a new node in the canvas:

Let me know if that unblocks you.
Henry

@iCodeSometime