cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Robertjde
Helper V
Helper V

add collection

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

 

Dude.PNG

10 REPLIES 10
mdevaney
Super User
Super User

@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."

@mdevaney unfortunately it doesn't work

 

dude2.PNG

@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."

@mdevaney 
not compatible the column Image

@Robertjde 

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

Its Works! @mdevaney 

dude3.PNG

 

dude4.PNG

@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."

@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!

 

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! 😁

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,558)