I'm building some custom logic to send an array of files uploaded to my agent in an HTTP request to either an Agent Flow or Power Automate flow for async processing.
I'm facing an issue with adding a record to my array variable. See attached image. What I've done:
Set a Table variable "FilesToSend" as an empty array
Loop over my "System.Activity.Attachments" table
Modify my "FilesToSend" table by adding a current record
Now instead of just adding the record I want to append it as an object like:
{
fileName: CurrentItem.Name,
fileUrl: CurrentItem.ContentUrl,
contentType: CurrentItem.ContentType
}
However, to my knowledge there are no PowerFx functions available in the Co-pilot topic designer for Set or Collect (looking at both the auto-complete and the formula references here).
Co-Pilot Topic Designer: Power Fx Function for Adding Record to Table in Loop?
I have solved my own question! To accomplish this:
Click + > Set a variable value
Select the current item within the loop
You can create objects (or records) as variables, so go to Formulas and expand
Create a JSON structure for your record { filename: Topic.CurrentItemName, ... }
Click + > Modify items in a list
Select your table variable set outside the loop
Select "Change Type" to "Add Item"
Select the variable record you just created
In this way you can add records to a custom table variable after manipulating them for any format you wish (i.e. preparing them in a specific structure for an HTTP request).
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
47
Share
Report
All responses (
Answers (
