Power Platform Community Forum Thread Details

Hi,

Firstly this is my first app based on Dataverse.

I've make app based on @RezaDorrani tutorial:
Power Apps Editable Grid using Gallery & Modern Controls (2023) - YouTube

All data loaded from Dataverse table. Main table is ACTIVITY (custom table). Another tables are ORDER, WORKERS

Gallery Item property is ACTIVITY. All dropdown/combobox/text input, are editable. At the backend there is help table called colGridUpdate.

Some of dropdown are choice column (FAKTUROVAT)
Some are LookUp into another table and value are stored into text area - (PRACOVNIK)/ WORKER (red)
Some are lookup colum - in dataverse it is lookup column into ORDER. (yellow)

Snímka obrazovky 2024-05-15 125236.png

In WORKER dropdown controler - there is delegation warring.
In item property:

Sort(Pracovníci;"new_name";SortOrder.Descending).

I don't need sorting. But when I put only "Pracovníci" doesn't show any data in modern dropdown.
DefaultSelectedItems :

LookUp(Pracovníci;'Pracovník (new_name)' = ThisItem.Pracovník)
When I try put only ThisItem.Pracovnik - error (expected table) it is correct??

Is there problem with syntax, when using Dataverse in power apps ?
Sometimes when I refresh gallery items. This dropdown doesn't contains values (maybe it is because delegation waring)??

-----------------------------------------
CHOICE column in Dataverse - modern dropdown FAKTUROVAT
Items: Choices(Aktivity_1.Fakturovat).

But why in value is something "this datatype is not supported" - it is correct or somewhere is syntax problem??
DefaultSelectedItems : {Value: ThisItem.Fakturovat} - this is the only one correct syntax of DV choice column?

The last thing - all controlers on property OnChange has Select(ButtonCanvas1_3)
This update colGridUpdate table. This is code of property OnSelect:

If(

IsBlank(

LookUp(

colGridUpdates;

Aktivita = ThisItem.Aktivita

)

);

Collect(

colGridUpdates;

ThisItem

);;

UpdateIf(

colGridUpdates;

Aktivita = ThisItem.Aktivita;

{

Datum: datp_datum_pozadavky_3.SelectedDate;

Požadavek: dpd_pozadavek_lookup_3.Selected;

Popis: txt_popis_3.Value;

Pracovník: Concat(cmbox_uzivatelia.SelectedItems; 'Pracovník (new_name)';" , ");

Zakázka: dpd_zakazka_lookup_3.Selected;

Fakturovat: drp_fakturovat_choice_3.Selected.Value;

Středisko: drp_stredisko_choice_3.Selected.Value;

'Mimo pracovní dobu': drp_mimo_prac_dobu_choice_3.Selected.Value;

Množství: Value(numb_input_mnoztvi.Text);

'Fakturovatelné množství': Value(numb_input_FA_mnoztvi.Text);

'Výjezd lokálně': dpd_vyjezd_lokal_3.Selected.Value;

'Výjezd km': Value(numb_input_vyjezdKM.Text);

Auto: dpd_auto_lookup_3.Selected;

pomoc_cas_na_ceste: Value(numb_input_cas_na_ceste.Text);

pom_pocet_pracovnikov: CountRows(cmbox_uzivatelia.SelectedItems)

}

)

But when I show records of colGridUpdate - the columns are representing with ? - it's correct?? Or setting this value into table must have another syntax?

Can anybody give me advice, if I use modern input controlers correctly. If I correctly use choice/ lookup columns from Dataverse.

Thanks for any advice, Tomas.

Categories:

Building Power Apps