Share
Report
230Hi, I'm close to find the solution but issues persits,
I want to import data from excel sheet directly from a canvas app with the attachment control.
on my submit button I trigger the following flow:
in powerapps this is the submit formula:
ForAll(AF_Attachment_File_1.Attachments,
Collect(test,
importtest.Run(
{file:{
contentBytes: Value,
name: Name
}
})
));
Reset(AF_Attachment_File_1)
there is only one attacment max
If I want to show the collection in a gallery, this is what I see:
this is the error in the formula of the running flow button:
and finaly this is what I see in the output of the response:
[
{
"@odata.etag": "",
"ItemInternalId": "9c24b40a-3739-483a-b230-55c89a03a9c7",
"Code": "123-45",
"Statut": "Brouillon"
},
{
"@odata.etag": "",
"ItemInternalId": "5ce5b372-fe7a-4f1c-90ee-edd74b8f7656",
"Code": "789-45",
"Statut": "En cours"
},
{
"@odata.etag": "",
"ItemInternalId": "46f0c911-4ae7-4662-8f5d-4b4d1f228b05",
"Code": "112-131",
"Statut": "test"
}
]
I have all the datas I need but powerapps does not want to show me them.
I don't knwo if I have to adapt powerapps to receive information from power automate (my prefered solution) or
I I have to adapt power automate to send correctly informations to powerapps
please can someone help me?
kind regards
Categories:
I have the same question (0)
All responses (
Answers (
