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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,597)