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.
Solved! Go to 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")
@TerjeFR can you take both the json, from one PowerApps (from flow run) and one from compose action and provide the json here?
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}]
With JSON directly:
Directly from "Ask in PowerApps":
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);
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")