ForAll Collection

[FENGYANG]

Hello! I need a little help 

Please see screenshot below;

Why the ForAll Collection make the same data. In fact the displayname of Attachments are different.

How should I correct the code.

Thank you.

Clear(attachlist);
ForAll(
    Gallery3.AllItems,
    Collect(
        attachlist,
        {
            Name: Last(
                LookUp(
                    Gallery3.AllItems,
                    ID = ID
                ).Attachments
            ).DisplayName
        }
    )
);

[AhmedSalih]

Hello, @LaurensM , Crossed each other. 🙂

If my reply helped you, please give a 👍  , & if it solved your issue, please give a 👍  & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

[LaurensM]

Hi @FENGYANG,

Since you are using the Gallery as a datasource, you don't need to provide it with another lookup to the same source. Please try:

Clear(attachlist);
ForAll(
    Gallery3.AllItems,
    Collect(
        attachlist,
        {
            Name: Last(ThisRecord.Attachments).DisplayName
        }
    )
);

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

[FENGYANG]

@LaurensM  Hi, thank you for hlep, There seems to be a mistake.

[LaurensM]

You currently have a trailing dot after the Last() function, you will need to write .DisplayName as in your previous code. Does the error persist after adding this - if so, what particular error are you receiving?

[FENGYANG]

Please see screenshot below

 "Last(ThisRecord.Attachments).DisplayName" is error

[FENGYANG]

The type is incompatible. The 'Name' column in the data source you are updating should be of type 'Text', but you are using type 'Error'.The function 'Collect' has some invalid arguments.The specified column cannot be accessed in this context.The function 'Last' has some invalid arguments.Name: Last(ThisRecord.Attachments).DisplayName);

[LaurensM · Accepted solution]

@FENGYANG ah indeed, the attachment column does not seem to be accessible in this context. I tried a few variations but always ended up with that exact error.

What you could do is add a label to your gallery with the following text property (and set the visible property to false):

Last(ThisItem.Attachments).DisplayName

Let's name this label 'lblAttachment', your collect code would be the following:

Clear(attachlist);
ForAll(
    Gallery3.AllItems,
    Collect(
        attachlist,
        {
            Name: ThisRecord.lblAttachment.Text
        }
    )
);

I hope this helps!

[FENGYANG · Accepted solution]

@LaurensM  Thank you very much, this is so clever.

[FENGYANG]

Hi @LaurensM 

if an item has multiple attachments, I hope collect the the displayname of attachments in Gallery.

I have tyied some ways, but these did not work,