cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MH3
Post Prodigy
Post Prodigy

PowerApps Help / Flow help

Hi,

I have a Canvas application and I have a gallery and I am filtering the Gallery and getting an EXCEL sheet export it from by using Plumsail custom connector in my flow, but my flow is failing on Parse JSON, well it was working before the last time I ran the flow.

Submit Button Code:

Set(ExportCSV, "");
Clear(ExportCSVFile);
ForAll(Gallery1.AllItems,
Collect(ExportCSVFile,{UserId:UserLabel.Text,Date:DateLabel.Text,TimeSlot:TimeSlotLabel.Text,Task:TaskLabel.Text,Customer:CustomerLabel.Text,Category:CategoryLbl.Text,Project:ProjectLabel.Text,DateAsInt:DateasInt.Text,Billable:BillLabel.Text}));

Set(VarURL, ExcelFileGenerate.Run(JSON(ExportCSVFile,JSONFormat.IndentFour)).created); Launch(VarURL)

1)

Ran 6 timesRan 6 times

2) 
Succeeded last timeSucceeded last time
3)
stuck on Parse JSONstuck on Parse JSON
JSON SAMPLE SCHEMA = 

[
    {
        "Billable": "false",
        "Category": "Others",
        "Customer": "SunStar Hotels",
        "Date": "03/08/2021",
        "DateAsInt": "20210308",
        "Project": null,
        "Task": "Contd Excel File Task....",
        "TimeSlot": "10:00 AM - 10:30 AM",
        "UserId": "Muhammad Fahad Ali Khan"
    },
    {
        "Billable": "false",
        "Category": "Others",
        "Customer": "Dewan Stores (Pvt) Limited",
        "Date": "03/08/2021",
        "DateAsInt": "20210308",
        "Project": null,
        "Task": "kuch bhi",
        "TimeSlot": "10:30 AM - 11:00 AM",
        "UserId": "Muhammad Fahad Ali Khan"
    },
    {
        "Billable": "false",
        "Category": "Others",
        "Customer": "SunStar Hotels",
        "Date": "03/08/2021",
        "DateAsInt": "20210308",
        "Project": null,
        "Task": "create new task",
        "TimeSlot": "09:00 AM - 09:30 AM",
        "UserId": "Muhammad Fahad Ali Khan"
    }
]


Any Help? ?
@LauraGB @eka24 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @LauraGB  Thanks for your reply.

 

I have fixed the issue, by creating a new SAMPLE JSON and it is mapped with my data which I had passed from the gallery.

{
"UserId": "aaaaaaaaaaaaaaaa"
"Date": "03/08/2021",
"TimeSlot": "09:00 AM - 09:30 AM",
"Task": "aaaaaaaaaaaaaaaaaa",
"Customer": "aaaaaaaaaaaaaaaaa",
"Category": "aaaaaaaaaaaaaaa",
"Project": "aaaaaaaaaaaaaaaaaaaaaaa",
"DateAsInt": "20210308",
"Billable": "false"
 }

           


This worked well
fixed.png

Thanks

View solution in original post

3 REPLIES 3
LauraGB
Kudo Collector
Kudo Collector

Whats the error details on the Parse JSON step?

 

I'm going to guess the schema doesn't match your sample data and the Power App is producing different data than it did before. What's the schema?

 

L

Hi @LauraGB  Thanks for your reply.

 

I have fixed the issue, by creating a new SAMPLE JSON and it is mapped with my data which I had passed from the gallery.

{
"UserId": "aaaaaaaaaaaaaaaa"
"Date": "03/08/2021",
"TimeSlot": "09:00 AM - 09:30 AM",
"Task": "aaaaaaaaaaaaaaaaaa",
"Customer": "aaaaaaaaaaaaaaaaa",
"Category": "aaaaaaaaaaaaaaa",
"Project": "aaaaaaaaaaaaaaaaaaaaaaa",
"DateAsInt": "20210308",
"Billable": "false"
 }

           


This worked well
fixed.png

Thanks

LauraGB
Kudo Collector
Kudo Collector

Congrats on fixing the issue.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,983)