How to Read and Write from Dynamic Excel Files with Microsoft Flow

Read and Write Dynamic Excel Files using standard SharePoint and Excel connectors.

[MrMeltdown]

Excellent. Just the right level of complexity for someone trying to figure this stuff out.

[nockid]

Hi John - thanks for the great video. One question: is it possible to READ / WRITE into single cell locations in an XLS vs a Table / Row only?

[pwagma]

Hi Ninja, thanks for this video, it is incredible. I cannot believe all the workaround we need to do.
But after a few hours watching your video and trying I was able to make it work, maybe 90%.
My purpose is when a file is approved, "sign" the excel with the time and name of the user/time of approval.
But I have 2 problems:
1) and less important the time is not following my settings, and it gives me a wrong time (GMT-0 vs Default GMT-3)
2) and most important: I cannot move the file after I do this. It worked before using the ID from "get file properties", and I also tried using the Graphic API file ID, but it just doesn't let me, it's like "the file is being used so you cannot move it".

Thanks in advance. Your blog and videos are very useful, maybe the amount of views doesn't show it, but please keep it up because for newbies this is gold.

[mattmolkoski]

Hi John,

Thanks for the great video. I'm getting a little tripped up on the first step, "Filter Array". When I try to add Value to that, Microsoft Flow is only giving me "Body" as a dynamic option. If I try to type in the comments, no luck with that here.

Any suggestions on what I'm doing wrong?

[jansevenich]

Hi John, thanks for the great video. Can you please help me with the Excel table id? You look in your video for the first table in the file. How can i look for the name of the table when i have some different tables? I don´t find anything. Thanks for your help.

[jezzejaysoncuevas]

How did you to have an Items field in your Add a row into a table?

[EeLane]

how m i not a subscriber :-o *hit subscribed*