add collection

[Robertjde]

Hello everybody,

I would like to save my attachments in a collection and define a FileName.

I tried this, unfortunately without success!

Collect(Dude;Anhänge.Attachments; {FileName: Text(Now();"[$-en-GB]hhmmss" & ".jpg")} )

The collection is then stored in 2 rows, but I need it as one entry

[mdevaney]

@Robertjde

Can you please try this?

Collect(
    Dude;
    {
        FileName: Text(Now();"[$-en-GB]hhmmss" & ".jpg"),
        Image: Anhänge.Attachments.Image;
        Name: Anhänge.Attachments.Name;
        Value: Anhänge.Attachments.Value
    }
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Robertjde]

@mdevaney unfortunately it doesn't work

[mdevaney]

@Robertjde 
And the error message is?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Robertjde]

@mdevaney 
not compatible the column Image

[mdevaney]

@Robertjde 

It doesn't look like the image is working in your original screenshot either...

[Robertjde]

Its Works! @mdevaney 

[mdevaney]

@Robertjde 
I am having trouble replicating your current collection.  How did you do it?  This code produces only Name & Value columns.

Anhänge.Attachments

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Robertjde]

@mdevaney 

I linked an edit form to a sharepoint list to get attachment control.
Then added a button to create the collection.

Formulas are at the top of the post. Actually nothing more!

[Robertjde]

Does anyone here have an idea how I can change this formula so, that the timestamp is saved as a JPG under FileName in my collection?

I only need a solution for this to complete my application.

Any help is welcome! 😁