Hello guys
I'm trying to get a match between a Gallery and a Table with the LookUp function.
I get an error message "Invalid formula. A value compatible with "DataSource" was expected. "
It seems this is not possible... but I think there is maybe another way to achieve this? Or am I doing something wrong?
What I try to achieve:
In PowerApps I can select an "Order" from a Gallery which is connected with a SP List.
on the new page--> (Please see screenshot for more understanding) I can edit the form
FormA (Flugbuchungen_Formular) --> Editable text fields and selectable values and an unique ID number --> SP List
FormB (Form4) --> not editable/visible fields which copies the values/texts from FormA (actually 1:1 the same informations) --> Excel file
When I hit the "save" button --> it submits the Forms --> Form1 to a SP List // --> Form2 to a Excel list (OneDrive)
((the save button does the following;
SubmitForm(Flugbuchungen_Formular);; SubmitForm(Form4);; Navigate(Hauptseite;ScreenTransition.Fade)))
which works... for new entries
if I want to edit an existing Table entry I need to declair (at the item field) which object or row have to be modified... and there is my problem:
with this I get the following error: "Invalid formula. A value compatible with "DataSource" was expected. "
If(Form4.Mode = FormMode.Edit;
LookUp(
Tabelle5.'Antrag ID'; Gallery2.Selected.'Antrag ID' = Tabelle5.'Antrag ID'
).'Antrag ID'
)
or error message "Some types are incompatible for comparison. These types cannot be compared"
If(Form4.Mode = FormMode.Edit;
LookUp(
Tabelle5.'Antrag ID'; Gallery2.Selected.'Antrag ID' = Tabelle5.'Antrag ID'
)
)
Is there another way?
Thank you in advance
