Hi everyone,
I have an issue with PowerApps and I am unable to fix it. I have a Form that uses a Datacard called Klant_DataCard2. I am trying to modify the way this card gets its data to Update to the Sharepoint list item (field_2) it is connected to.
The way this Card works by default is a Combobox dropdown named DataCardValueKlant, which has a modified items list:
Ungroup(
Table(
{Mytables: Distinct(Filter('Dim Locaties VFS';'Dim Locaties VFS'[@Klant]<>Blank());Klant)};
{Mytables: Table({Value: "Nieuwe invoer"})}
);
Mytables
)
This allows me to use "Nieuwe invoer" which makes DataCardValueKlant invisible and shows the added TextVrijeInvoerKlant Text Input card control.
By default it is using Update = DataCardValueKlant.Selected).
What I want to achieve is to provide the output from the Datacard towards Sharepoint with the selected value from the DataCardValueKlant unless the selected value is "Nieuwe invoer" (in which case the controlcard goes invisible and the TextVrijeInvoerKlant now has to be filled. I want the filled-in TextVrijeInvoerKlant field to be the output going to SharePoint now (which I believe should be achieved by modifying the Update property of the Klant_DataCard2.
I have tried:
If(!IsBlank(TextVrijeInvoerKlant.Value);TextVrijeInvoerKlant.Value;DataCardValueKlant.Selected.Value)
If(DataCardValueKlant.Selected.Value<>"Nieuwe invoer";Value(DataCardValueKlant.Selected.Value);Value(TextVrijeInvoerKlant.Text))
If(TextVrijeInvoerKlant.Visible=false;DataCardValueKlant.Selected;TextVrijeInvoerKlant)
but they all give errors. Because of language settings the .Text code found online often does not work, although I can use .Value. Also the "," is replaced by ";" in the functions as a seperator.
Can anybody help me?
9
Share
Report
All responses (
Answers (
