ForAll Collection

(0) Share

Report

Posted on by FENGYANG

249

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
 }
 )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (3)

Sort by

AhmedSalih

6,680 Moderator on at

Like (2)

Report

Copy link

Link copied!

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

Was this reply helpful? Yes No

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
FENGYANG 249 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
FENGYANG 249 on at

Like (0)

Report
Copy link

Link copied!

Please see screenshot below
"Last(ThisRecord.Attachments).DisplayName" is error

Was this reply helpful? Yes No
FENGYANG 249 on at

Like (1)

Report
Copy link

Link copied!

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);

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

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

Was this reply helpful? Yes No
Verified answer

FENGYANG 249 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
FENGYANG 249 on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @FENGYANG,

Since we are using Last() we will only fetch the last attachment. Should you want to see all attachment names, separated by an enter / line break you can change the label text property to:

Concat(ThisItem.Attachments,DisplayName,Char(10))

I hope this helps!

Was this reply helpful? Yes No