Sync trouble between Sharepoint (Excel) and Forms

(1) Share

Report

Posted on by JV-25071259-0

Hi,

We have a flow that :

1 - Gets the content from an excel file stored in sharepoint which is synchronized with a MS Form (contains the responses)

2 - Convert the binary content obtained from the step 1 into a proper .xlsx file in our local system.

We see that when we open the excel manually from the forms (open results in excel) the registers are updated , but when we run the power automate flow it gets outdated and we get the version of the file that was manually opened the last time.

Is there a way to update the file before getting the content?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

ted14 55 on at

Like
a
(2)

Report
Copy link

Link copied!

What's the trigger for this flow - Could it be running before the Excel is updated?

Was this reply helpful? Yes No
AnthonyAmador 2,557 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

Which action in power automate are you using to get the file?

Was this reply helpful? Yes No
JV-25071259-0 12 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello Anthony,

Get the content of the file

1.- Site address:

We identify the group where the Microsoft Forms is located

2.- file identifier:

We select the excel file where the miscrosoft forms data is loaded

Thank you...!!!!

Was this reply helpful? Yes No
AnthonyAmador 2,557 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

Hi, thanks for the details.

This seems like a problem with the SharePoint action retrieving an out-of-date file, maybe the SharePoint file is not updated unless you go to the SharePoint site and refresh it.

I suggest opening a support ticket with Microsoft or downloading the file using UI Automation instead of the action, doing it the same way you are doing it manually to avoid issues.

Hope this helps.
Anthony

Was this reply helpful? Yes No
JV-25071259-0 12 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you Antony..!!

Greetings,

Was this reply helpful? Yes No