"The request was not sent or there was no response from the server ,check your internet connection"

(0) Share

Report

Posted on by TomMartin89

Hi, aware there are multiple threads on this but can't find one that relates specifically to what I'm trying to do....

I have two buttons in a PowerApp, which both:

Set a variable as a path to a file
Pass that path to Power Automate
[PA then does various things to excel file]
Pass table back to PowerApps
Success?

The only difference between the two buttons is the date in the file name being set to the variable, but one of the options fails in PowerApps with the above error message and the other one works as normal and populates a collection with the required data.

According to Power Automate, the flow runs successfully every time (even when PowerApps throws the error) and indeed I can see in the outputs that the data was retrieved and apparently passed back as a table with the correct values. Confused?

I've tried the usual stuff like removing and re-adding the flow etc.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hey @TomMartin89,

How long does your flow run? Can you give us the duration for both versions.
Power apps can't keep the connection to a flow open for too long. could be that it times out.

Was this reply helpful? Yes No
TomMartin89 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Longest run 25 seconds, and like I say successful in Power Automate every time and the data it says it passed back to PowerApps looks correct (so it can't be that the path being passed to Automate is incorrect or that would error there surely) but it errors in PowerApps for one option only.

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay so it can't be the time out. Since it's working in Power automate could you maybe start a Monitoring session and see what happens onselect for Both buttons.

Just to clarify: You always get the error for the one Button and it's always working for the other one.

could you also copy the code of both buttons in here?

Was this reply helpful? Yes No
TomMartin89 19 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for your responses - your understanding is correct.

Button 1 (the one that fails):
Set(varPath,"Duty Sheets/"&Text(Today()-(Weekday(Today(), StartOfWeek.Sunday))+1, "mmmm")&"/"&Text(Today()-(Weekday(Today(), StartOfWeek.Sunday))+1, "yyyy-mm-dd")&"_Employee_Final.xlsx");UpdateContext({varLoadDS:true}); ClearCollect( dutysheetTW, ForAll( Table( ParseJSON( DSTEST.Run("/"&varPath).table ) ), { '1': Text(Value.'1'), '2': Text(Value.'2'), '3': Text(Value.'3'), '4': Text(Value.'4'), '5': Text(Value.'5'), '6': Text(Value.'6'), '7': Text(Value.'7'), '8': Text(Value.'8'), '9': Text(Value.'9'), '10': Text(Value.'10'), '11': Text(Value.'11'), '12': Text(Value.'12'), '13': Text(Value.'13') })); UpdateContext({varLoadDS:false})

Button 2:

Set(varPath,"Duty Sheets/"&Text(DateAdd(Today(),(7- Weekday(Today(),StartOfWeek.Sunday)),TimeUnit.Days)+1, "mmmm")&"/"&Text(DateAdd(Today(),(7- Weekday(Today(),StartOfWeek.Sunday)),TimeUnit.Days)+1, "yyyy-mm-dd")&"_Employee_Final.xlsx");UpdateContext({varLoadDS:true}); ClearCollect( dutysheet, ForAll( Table( ParseJSON( DSTEST.Run("/"&varPath).table ) ), { '1': Text(Value.'1'), '2': Text(Value.'2'), '3': Text(Value.'3'), '4': Text(Value.'4'), '5': Text(Value.'5'), '6': Text(Value.'6'), '7': Text(Value.'7'), '8': Text(Value.'8'), '9': Text(Value.'9'), '10': Text(Value.'10'), '11': Text(Value.'11'), '12': Text(Value.'12'), '13': Text(Value.'13') })); UpdateContext({varLoadDS:false})
The convoluted date additions etc are just to get the date of the Sunday for the corresponding week, the paths it produces are:

Button 1:
Duty Sheets/May/2024-05-26_Employee_Final.xlsx

Button 2:
Duty Sheets/June/2024-06-02_Employee_Final.xlsx

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Okay could you try to replace the variable with a Hardcoded Path.

the rest seems to be exactly the same (Except for the collection name). This way we can see if the error is produced due to the functions in the Variable.
can you try it once like this:
Set(varPath,Hardcode here);UpdateContext({varLoadDS:true}); ClearCollect( dutysheetTW, ForAll( Table( ParseJSON( DSTEST.Run("/"&varPath).table ) ), { '1': Text(Value.'1'), '2': Text(Value.'2'), '3': Text(Value.'3'), '4': Text(Value.'4'), '5': Text(Value.'5'), '6': Text(Value.'6'), '7': Text(Value.'7'), '8': Text(Value.'8'), '9': Text(Value.'9'), '10': Text(Value.'10'), '11': Text(Value.'11'), '12': Text(Value.'12'), '13': Text(Value.'13') })); UpdateContext({varLoadDS:false})
And once like this:
/*Set(varPath,"Duty Sheets/"&Text(Today()-(Weekday(Today(), StartOfWeek.Sunday))+1, "mmmm")&"/"&Text(Today()-(Weekday(Today(), StartOfWeek.Sunday))+1, "yyyy-mm-dd")&"_Employee_Final.xlsx");*/UpdateContext({varLoadDS:true}); ClearCollect( dutysheetTW, ForAll( Table( ParseJSON( DSTEST.Run(Hardcode here).table ) ), { '1': Text(Value.'1'), '2': Text(Value.'2'), '3': Text(Value.'3'), '4': Text(Value.'4'), '5': Text(Value.'5'), '6': Text(Value.'6'), '7': Text(Value.'7'), '8': Text(Value.'8'), '9': Text(Value.'9'), '10': Text(Value.'10'), '11': Text(Value.'11'), '12': Text(Value.'12'), '13': Text(Value.'13') })); UpdateContext({varLoadDS:false})
Don't forget to comment out the variable.

Was this reply helpful? Yes No
TomMartin89 19 on at

Like
a
(1)

Report
Copy link

Link copied!

Ah yeah sorry I only changed the name of one collection while trying to eliminate things.

Hardcoding the 'faulty' path in both ways still fails - to check I also hardcoded the 'working' path into the DSTEST.Run formula which worked as expected. I've attached some images of the successful flow trigger and output for the test run.

Edited as the pictures didn't work.

Was this reply helpful? Yes No
TomMartin89 19 on at

Like
a
(1)

Report
Copy link

Link copied!

In case this points towards anything....

It works as intended on the iOS app - when I figured this out I thought I would be coming back here looking like an idiot after clearing my cache, alas it wasn't to be - cache has been cleared on Chrome/Edge and the remote Citrix session I have to use has been signed out/back in to start a new session. Still the same problem as above on PC.

Was this reply helpful? Yes No
Verified answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If it changes depending on the device you're using, it could be that you need to contact microsoft support.
since the code is working on IOS it can't be a logic error but rather a runtime error. you can't influence that.

Was this reply helpful? Yes No
TomMartin89 19 on at

Like
a
(1)

Report
Copy link

Link copied!

Makes sense, thanks for your time thus far. Will liaise with whoever does that in my org.

Was this reply helpful? Yes No