Unanswered

Using ClearCollect() within an If function?

(1) Share

Report

Posted on by MTv Microsoft Employee

Are we allowed to use the ClearCollect( Collection, Item, ... ) function within If( Condition, ThenResult [, DefaultResult ] ) functions?

I'm able to use the Kusto Connector successfully within a ClearCollect function from a gallery's OnSelect property; but when I try to wrap it inside an If function to avoid unnecessary calls to Kusto, clicking on "Capture Schema" does nothing. Moving it back outside the If function allows it to work again.

I really would like to avoid making any unnecessary calls to Kusto if I can avoid them, and this is my first approach.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,024 Most Valuable Professional on at

Like (0)

Report

@MTv

Can you please share the code that is not working.

Was this reply helpful? Yes No
MTv Microsoft Employee on at

Like (0)

Report

# sorry for the lack of formatting....
# columns and values changed to protect the innocent ^^ 😎

If(
ThisItem.Category = "International",
ClearCollect(
InternationalCollection,
AzureDataExplorer.listKustoResultsPost(
"https://***.kusto.windows.net",
"***",
"Dim_***() | where Id == '" & ThisItem.Name & "'"
).value)
);
If(
ThisItem.Category = "Domestic",
ClearCollect(
DomesticCollection,
AzureDataExplorer.listKustoResultsPost(
"https://***.kusto.windows.net",
"***",
"Dim_Customer***() | where Id == '" & ThisItem.Name & "'"
).value)
);

Was this reply helpful? Yes No
WarrenBelz 153,024 Most Valuable Professional on at

Like (0)

Report
@MTv ,

I thought you were referring to a Power Apps collection - what is this bit for

AzureDataExplorer.listKustoResultsPost( . . . .

also the code is not PowerFX - it looks more like SQL

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @MTv

Here is a working a record in a power app collection=>
If( LookUp(Employee3; ID=ThisItem.ID).ID >0;
RemoveIf(Employee3; ID=ThisItem.ID);
Collect(Employee;ThisItem)
)
if the record is found in the collection then remove it, otherwise put it in the collection.

Thank You

Was this reply helpful? Yes No
MTv Microsoft Employee on at

Like (0)

Report

I am using a PowerApps collection. That's using the PowerApps' Kusto Connector to populate the Collection.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @MTv ,

You may try it with the Switch function:

Switch( ThisItem.Category, "International", ClearCollect( InternationalCollection, AzureDataExplorer.listKustoResultsPost( "https://***.kusto.windows.net", "***", "Dim_***() | where Id == '" & ThisItem.Name & "'" ).value ) "Domestic", ClearCollect( DomesticCollection, AzureDataExplorer.listKustoResultsPost( "https://***.kusto.windows.net", "***", "Dim_Customer***() | where Id == '" & ThisItem.Name & "'" ).value ) );

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No