cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Functions are not working by itself

Hello,

 

There is a some problem with my functions, because independent the option that i selected, ever the second distinct is not working, maybe the function is memorizing my frist option. Below, we can see the exemple and my first option selected was "Equipamentos", because that we can see just a "Reclamação Equip.", the answer of database.

If i select the "Químicos" em my first screen, in the second screen must show two option: "Kit Reagentes" and "Reclamação Químicos", but i can see just "Reclamação Equip.", if i actualize the function, the sistem load and if i selected "Químmicos" first, i will see the two option: "Kit Reagentes" and "Reclamação Químicos", but if i back to first screen and select other option, i will show the Químicos results..

1.png

First Screean Function: Distinct(TabelaFormulário,Primeira_x0020_Página)

Second Screen Function:  Distinct(Filter(TabelaFormulário, Primeira_x0020_Página = Gallery1_7.Selected.Result),Segunda_x0020_Página)

 

Maybe it is similar a "Manual Calculator", i dont know if there is the option in powerapps, but it have been working for 2 months with this sisten and then yesterday it didnt work more, maybe i selected a option to change the automatic calculator to manual calculator..

 

Actually, i need to actualize all the time my databases to show some information in my powerapps..

 

Anyone can help me?

Thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @Anonymous ,

Do you mean that the Distinct function could not work any more within your app?

 

I could not find any syntax error with the formulas that you provided. Based on the issue that you mentioned, I think this issue is related to the PowerApps version 3.19052.19. The user @pr0g has faced similar issue with you, please check the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/A-bug-has-occurred-since-the-last-version-of-powerapps-3-19052/m-p/289747#M83703

 

There are some known issues (e.g. Gallery.Selected could not work, CountRows(Gallery.AllItems) could not work, ... etc ) with the PowerApps version 3.19052.19. Now PowerApps has released a new version -- 3.19052.20, these issues occurred in version 3.19052.19 has been fixed.

 

On your side, please consider re-create a new app based on the latest version PowerApps, then try your formula again, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
yashag2255
Dual Super User II
Dual Super User II

Hi @Anonymous , 
 
Please refer to the attached screenshot and modify the Screen2 Gallery Items. 
MicrosoftTeams-image (24).png

 

 
Query: Distinct(Filter(TabelaFormulário,'Primeira Página'= Gallery1.Selected.Result),'Segunda Página')
Hope this Helps. 
 
Thanks, 
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Anonymous
Not applicable

Hi @yashag2255 ,

 

It's the same function that was in second screen, but i cant choose the "'Primeira Página'", for me showed just  "Primeira_x0020_Página", i think that _x0020_ is the code of space..

 

When i created other APP, the sistem working perfectly but in this APP, i dont know why, my functions are not working..

The distinct function is a simple exemple, but there are other functions that i need to do all the time the refresh in my databases to show somethings..

 

v-xida-msft
Community Support
Community Support

Hi @Anonymous ,

Do you mean that the Distinct function could not work any more within your app?

 

I could not find any syntax error with the formulas that you provided. Based on the issue that you mentioned, I think this issue is related to the PowerApps version 3.19052.19. The user @pr0g has faced similar issue with you, please check the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/A-bug-has-occurred-since-the-last-version-of-powerapps-3-19052/m-p/289747#M83703

 

There are some known issues (e.g. Gallery.Selected could not work, CountRows(Gallery.AllItems) could not work, ... etc ) with the PowerApps version 3.19052.19. Now PowerApps has released a new version -- 3.19052.20, these issues occurred in version 3.19052.19 has been fixed.

 

On your side, please consider re-create a new app based on the latest version PowerApps, then try your formula again, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Hello @v-xida-msft ,

 

That was the problem! Thank you so much for your help, I got to fix the problem!!

 

Regards,

Rodrigo Honorio

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,456)