Collect inside of ForAll behave differently than ForAll inside Collect - why?

(0) Share

Report

Posted on by Z_Lukowski

216

Hi Power Users,

I have created two different functions which I thought should work in the same way:

#1)

#2)

filter part of this function is working properly, was tested before (let's skip the delegation for now),

#1 is working properly, returning me collection with Level (in text, based on choice field) and Threshold (number) - total of X records

#2 however is also creating X records, creating proper column names (they are only defined in this function, so I know this part is workings), but data is empty:

I cannot understand the difference between those functions, for me they both should return populated collection. I just need to understand this code, no need for alternative solutions as I already have #1 working, if you have any idea, let me know.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Z_Lukowski

not a solution, but a suggestion.

your datasource is 'Reporting Units' and it has a column called 'Threshold Configs'.

that column returns a Table which has a column called 'Type'.

'Type' column is a choice column?

If yes, in your #2 code

Text(Type.Value) = "Application Phase"

Was this reply helpful? Yes No
Z_Lukowski 216 on at

Like
a
(0)

Report
Copy link

Link copied!

@Alex_10 Filter is working properly, If I change the Text(Type) to Text(Type.Value) then it produce an error:
You tell me why, I also thought at the start that I should use Text(ChoiceName.Value), but Text(ChoiceName) works correctly.

Was this reply helpful? Yes No
Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Z_Lukowski

I see now.

Your datasource is Dataverse.

It works in a different way then SharePoint and many other data sources.

Cannot test as have a limited access to Dataverse.

The code looks something like:

Type.PrimaryColumnNameInThresholdConfigs = "Application Phase"

OR

Type.PrimaryColumnNameInThresholdConfigs = 'Type (Threshold Configs)'.'Application Phase'

Was this reply helpful? Yes No