Unanswered

System.Activity.Attachments - How to work with the table

(1) Share

Report

Posted on by WillM83

Hi everyone,

I’m looking to read the contents of Activity.Attachments in Copilot Studio. Currently, I receive a table as the result. I’m not sure how to handle this table object or data type in my Copilot project. My goal is to forward this table (referred to as @Attachments) to a webhook. Alternatively, I would also consider storing these attachments or information somewhere and then just providing the URL.

Has anyone dealt with something similar or have any suggestions on how to approach this?

Thanks!

Categories:

Copilot Studio skills development

I have the same question (0)

All responses (3)

Answers (0)

fchopo 8,003 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @WillM83

You can convert the table object to a Record, using the following expression:

Set( recordObject, First(Activity.Attachments) )

Where recordObject is a record variable you should create before assigning the value. Once you have the recordObject, you can access the values in each column like: recordObject.email for instance.

Hope that helps!

Ferran

Was this reply helpful? Yes No
CU23011457-0 2 on at

Like (1)

Report
Copy link

Link copied!

Hello everyone,

have you been able to find out more since your question?

I'm trying to attach a file in the chat and then extract the information using AI Prompts. So far I have the problem that I can't process the file that I think is in ‘System.Activity.Attachments’ because many PowerFx formulas are not supported.
At the moment I'm trying to get on with the blob obtained with ‘First(System.Activity.Attachments).Value’.

Do you have any other ideas?

Many thanks in advance!

Was this reply helpful? Yes No
DougM_Barhead 25 on at

Like (0)

Report
Copy link

Link copied!

I can get the content of the file using First(System.Activity.Attachments).Value

But, I can't pass that blob on to Power Automate - same as OP

BTW @fchopo Set does not seem to work in PowerFX for Copilotstudio.

Was this reply helpful? Yes No