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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,330)