Functions are not working by itself

[Anonymous]

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..

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

[yashag2255]

Hi @Anonymous , 

Please refer to the attached screenshot and modify the Screen2 Gallery Items. 

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]

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 · Accepted solution]

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,

[Anonymous]

Hello @v-xida-msft ,

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

Regards,

Rodrigo Honorio