After loading Collection, notification keeps coming?

(0) Share

Report

Posted on by TimmyBoy

997

Hello,

No idea what i do wrong,

But the notification popup always even data has been found?
This one gives me an error
invalid argumenttype

ClearCollect(
 MySales;
 If(
 IsEmpty(
 Filter(
 OnlineData;
 (MonthValue = "FEBRUARY 2024")
 )
 );
 Notify("No Data."; NotificationType.Error);
 ForAll(
 GroupBy(
 AddColumns(
 Filter(
 OnlineData;
 (MonthValue = "FEBRUARY 2024")
 );
 "LogText";
 Last(Split(CODE; "-")).Value
 );
 "LogText";
 "MySales"
 );
 {
 LogText: ThisRecord.LogText;
 MySales: Text(
 Sum(ThisRecord.MySales; PRICE);
 "$#,###0.00"
 )
 }
 )


 )
)

This parts works... weird when i do 2x ;;

ClearCollect(
 MySales;
 If(
 IsEmpty(
 Filter(
 OnlineData;
 (MonthValue = "FEBRUARY 2024")
 )
 );;
 Notify("No Data."; NotificationType.Error);
 ForAll(

It works without error, but then the notification keeps popup instead only when no data has been found

What do i wrong?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @TimmyBoy

I dont know if its just the copy / paste and code snippet issue, (so apologies if so),
but I see that you do not have a , (comma) for your if.

Is it just replacing your commas with semi colons?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Verified answer

TimmyBoy 997 on at

Like (0)

Report
Copy link

Link copied!
Hello,
Well seems this little trick worked
Still not really a clue why it didn't work the previous way
But, thanks all 😉

ClearCollect( MySales; If( IsEmpty( Filter( OnlineData; (MonthValue = "FEBRUARY 2024") ) );Set(yesdata;false);; Notify("No Data."; NotificationType.Error) ; Set(yesdata;true) ) );; If(yesdata; ClearCollect( MySales; ForAll( GroupBy( AddColumns( Filter( OnlineData; (MonthValue = "FEBRUARY 2024") ); "LogText"; Last(Split(CODE; "-")).Value ); "LogText"; "MySales" ); { LogText: ThisRecord.LogText; MySales: Text( Sum(ThisRecord.MySales; PRICE); "$#,###0.00" ) } ) ) )

Was this reply helpful? Yes No