Hi,
i am using the JSON formula to structure my collection and transfer it to an PowerAutomate workflow.
I want to add another Column from type "lookup" (to users table) now. It doesnt bring any error, but when i show the structure in a label, the lookup column is missing. For normal text columns, it works fine. Any idea?
//JSON Struktur erstellen
Set(varJSONUrlaubspläne,JSON(ShowColumns(colSelectedMitarbeiter,"creda_vorname","creda_nachname","creda_personalnummer","creda_urlaubstagesoll","creda_verplantetage","creda_januar","creda_februar","creda_marz","creda_april","creda_mai","creda_juni","creda_juli","creda_august","creda_september","creda_oktober","creda_november","creda_dezember","creda_Vorgesetzter"),JSONFormat.IndentFour));
//PowerAutomate Workflow aufrufen und Link zur neuen Datei in Variable zwischenspeichern
'AZE-ExportUrlaubspläne'.Run(varJSONUrlaubspläne,User().Email);
------------------------------
Fabian Heil
------------------------------