Power Automate + Power Apps: Getting Json with "Ask in PowerApps" doesn't work in the flow, but if pasted in a compose, it works

[TerjeFR]

Hello

Anyone else experienced that the Json with "Ask in PowerApps" doesn't work in the flow, but if pasted in as compose, it works?

I'm taking a gallery on Power Apps, making a JSON in "OnSelect" on a button and importing it in the flow to populate an excel file with a table.

Overview of flow:

With "Ask in Powerapps":

With the "Ask in PowerApps" output written to a .txt file and pasted instead:

Why does the pasted JSON work, but when i try to do it directly, it doesn't do the same thing? 🙂

When I do it directly, it creates the excel file and the table, but table is empty. When run with the pasted JSON, the table is full.

[annajhaveri]

@TerjeFR  can you take both the json, from one PowerApps (from flow run) and one from compose action and provide the json here?

[TerjeFR]

The JSON that gets created from Power Apps is the same JSON that i pasted manually. The only difference is the method of how the flow gets the JSON provided. In theory it should be the same, but I don't know if I have to make any additional steps to get the JSON I get directly from Power Apps to work the same way.

From Power Apps, creating the JSON to import:

ForAll(Gallery1.AllItems,Collect(colDataExported,{
    Kontrollobjekt: ThisRecord.QaRecordName,
    Link: ThisRecord.DocumentLink,
    Sjekkliste: ThisRecord.ChecklistID,
    EKstatus: ThisRecord.SubmissionID.StatusEK,
    EKsign: ThisRecord.SubmissionID.SignEK,
    EKdato: ThisRecord.SubmissionID.DateEK,
    EKkontrolldokument: ThisRecord.DocumentationEK,
    SKstatus: ThisRecord.SubmissionID.StatusSK,
    SKsign: ThisRecord.SubmissionID.SignSK,
    SKdato: ThisRecord.SubmissionID.DateSK,
    SKkontrolldokument: ThisRecord.DocumentationSK,
    Godkjentstatus: ThisRecord.StatusApproval,
    Godkjentsign: ThisRecord.SignatureApproval,
    Godkjentdato: ThisRecord.DateApproval
    }));

EksporttilExcelMalv2.Run("", "", "", JSON(colDataExported,JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes));

Clear(colDataExported);

The JSON that is created, and works when pasted, but not directly:

[{"EKdato":"2022-09-20","EKkontrolldokument":"www.bygg.no","EKsign":"jgro","EKstatus":3,"Godkjentdato":"2022-09-15","Godkjentsign":"TFR","Godkjentstatus":"Signert","Kontrollobjekt":"1111111111111111","Link":"www.bygg.no","SKdato":"2022-09-20","SKkontrolldokument":"www.bygg.no","SKsign":"jgro","SKstatus":3,"Sjekkliste":"BK10"},{"EKdato":"2022-09-02","EKkontrolldokument":null,"EKsign":"jgro","EKstatus":3,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"2222222222222222","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK21"},{"EKdato":"2022-09-02","EKkontrolldokument":null,"EKsign":"jgro","EKstatus":3,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"3333333333333333","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK31"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":1,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"4444444","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":4,"Sjekkliste":"BK81"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Femte kontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK82"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Spesialkontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK40"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"BK 41 kontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK41"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Kontroll 100","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK42-1"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Kontroll 100","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK42-2"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Ny kontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK42-3"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Ny kontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK43-1"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Ny kontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK43-2"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Ny kontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":"BK40"},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Ny kontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":null},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Ny kontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":null},{"EKdato":null,"EKkontrolldokument":null,"EKsign":null,"EKstatus":null,"Godkjentdato":null,"Godkjentsign":null,"Godkjentstatus":null,"Kontrollobjekt":"Ny kontroll","Link":null,"SKdato":null,"SKkontrolldokument":null,"SKsign":null,"SKstatus":null,"Sjekkliste":null}]

[TerjeFR]

With JSON directly:

Directly from "Ask in PowerApps":

[TerjeFR]

The same happens when i try to create an HTML that i convert into PDF. Everything works if I paste JSON into the

Power Automate flow, but when I try to have it imported directly from Power Apps - Gallery, I get nothing.

Is there a simple fix I can't see? 🙂

Power Automate flow:

JSON created from Power Apps Gallery:

ForAll(Gallery1.AllItems,Collect(colDataExported,{
    Kontrollobjekt: ThisRecord.QaRecordName,
    Link: ThisRecord.DocumentLink,
    Sjekkliste: ThisRecord.ChecklistID,
    EKstatus: ThisRecord.SubmissionID.StatusEK,
    EKsign: ThisRecord.SubmissionID.SignEK,
    EKdato: ThisRecord.SubmissionID.DateEK,
    EKkontrolldokument: ThisRecord.DocumentationEK,
    SKstatus: ThisRecord.SubmissionID.StatusSK,
    SKsign: ThisRecord.SubmissionID.SignSK,
    SKdato: ThisRecord.SubmissionID.DateSK,
    SKkontrolldokument: ThisRecord.DocumentationSK,
    Godkjentstatus: ThisRecord.StatusApproval,
    Godkjentsign: ThisRecord.SignatureApproval,
    Godkjentdato: ThisRecord.DateApproval
    }));

EksporttilPDFviaHTML.Run(JSON(colDataExported,JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes));

Clear(colDataExported);

[TerjeFR · Accepted solution]

I think I've found the error. The HTML / Excel table needs jo have the content from Power Apps inside a JSON code:

json("Content from Power Apps")