web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Error running flow fro...
Power Apps
Unanswered

Error running flow from Power Apps

(0) ShareShare
ReportReport
Posted on by 216
I have tried to update my PowerApps flow to use the V2 trigger. I basically want the user to export records from the gallery and the flow uses File as the input. But I'm getting the following error when I run it.
ExportChangesToExcel.Run failed: {
"error": {
"code": "TriggerInputSchemaMismatch",
"message": "The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected String but got Null.'."
}
}
 
Any idea what I'm doing wrong here?
My code is:
//Create a collection for the data export
ClearCollect(colExport, {});
ForAll(GalleryAllRequests.AllItems, Collect(colExport, {ChangeNo: ThisRecord.ChangeNo.Text, Title: ThisRecord.Title4.Text, Origator: ThisRecord.Originator.Text, ChangeOwner: ThisRecord.ChangeOwner.Text, DateRaised: DateValue(ThisRecord.DateRaised.Text), Status: ThisRecord.StatusBtn.Text}));
RemoveIf(colExport, IsBlank(Title));
 
Set(varFileLink, 'ExportChangesToExcel'.Run({file:{contentBytes: JSON(colExport,JSONFormat.IgnoreUnsupportedTypes), name:Concatenate(varEV.projectname, "-", Now())}}).filelink);
Launch(varFileLink);
Categories:
I have the same question (0)
  • Suggested answer
    Pstork1 Profile Picture
    68,707 Most Valuable Professional on at
    You can't pass a dynamic JSON collection as a file object. Instead you should be passing it as a string and then run a ParseJSON action on that string in the flow to unpack the collection and turn it back into a typed array.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard