If anyone can please help me or provide suggestions with this weird behavior:
Problem:
Two of the display values on my ComboBoxes don't appear right after submitting a form called "EVENTS". However, when I go back to the app and click the item from gallery to view the form, the display value appears (well at least sometimes). What's even more weird, is that there seems to be no problem in the database (I'm using Dataverse), all the values are accurate and appear in Dataverse from the moment of the form submission.
Context:
I'm using Dataverse as a database. To say more about the structure, I have a table called "EVENTS" and two of the columns in the "EVENTS" table are called "WITNESS" and "ENTERED BY", which are "EMPLOYEE lookup datatypes. The "EMPLOYEE" table has columns "TERMINATED" (which means they don't work with us anymore, I promise it's not a hit list) which is a Yes/No Choice datatype and "ID EMPLOYEE" (for example, "EMP-0829") an autonumber datatype.
In PowerApps, the first ComboBox called "ENTERED BY" has "Items" field with the following formula:
Filter(
SortByColumns(
Choices([@'ÉVÉNEMENTS/EVENTS'].'ENTRÉ PAR/ENTERED BY'),
"cra42_nomcompletfullname"
),
'TERMINÉ/TERMINATED' <> 'TERMINÉ/TERMINATED (EMPLOYÉ(E)S/EMPLOYEES)'.Yes
)
The second ComboBox called "WITNESS" has "Items" field with the following formula:
Filter(
SortByColumns(
Choices([@'ÉVÉNEMENTS/EVENTS'].'TÉMOIN/WITNESS'),
"cra42_nomcompletfullname"),
'TERMINÉ/TERMINATED' <> 'TERMINÉ/TERMINATED (EMPLOYÉ(E)S/EMPLOYEES)'.Yes &&
'ID EMPLOYÉ(E)/EMPLOYEE' <> "EMP-0829" && 'ID EMPLOYÉ(E)/EMPLOYEE' <> "EMP-0013" &&
'ID EMPLOYÉ(E)/EMPLOYEE' <> "EMP-0026" && 'ID EMPLOYÉ(E)/EMPLOYEE' <> "EMP-0038" &&
'ID EMPLOYÉ(E)/EMPLOYEE' <> "EMP-0037" && 'ID EMPLOYÉ(E)/EMPLOYEE' <> "EMP-0036"
)
Furthermore, the DisplayFields was changed for both ComboBoxes to: ["cra42_nomcompletfullname"] which is the logical name of the name field in the "EMPLOYEE" table. Otherwise, by default it shows the "ID EMPLOYEE" (which by the way is also the default value of the lookup field in the "EMPLOYEE" column of the "EVENTS" table)
Also, just noticed the same thing happens with "EVENT LOCATION" (see photo) which is also a lookup field from table "DEPARTMENTS".
Here's its "Items" field in the "EVENTS" form:
Filter(
SortByColumns(
Choices([@'ÉVÉNEMENTS/EVENTS'].'LIEU DE L''ÉVÈNEMENT/EVENT
LOCATION'),"sse_nomname"),'CACHÉ/HIDDEN'<>'CACHÉ/HIDDEN (DÉPARTEMENT/DEPARTMENTS)'.Yes
)
So is there a solution or is this a bug that can only be fixed by the PowerApps folks?
Thanks in advance!
