You’re offline. This is a read only version of the page.
Announcements
233
Hello, I am still ready new when it comes to flows.
We have an excel doc on OneDrive of coworker info for our dept. This sheet can only be edited by another person on our team. I don't want to have to make the same changes on my list that he does. So, what I want is when he makes the changes in OneDrive it will update my SharePoint List which I use with several Power apps.
Right now, I have a made a test Flow using a copy of the file stored on my own OneDrive that updates an Excel File stored in my SharePoint doc library. I think all I have to do is share the Flow and the SharePoint doc with him and have him edit the Flow to point to the Master Doc on his OneDrive. I know this won’t be in real time, so I have a recurrence setup to run once a week.
The Issue I am having is that once the Flow is pointing at his OneDrive doc and it’s updating our shared SharePoint list. I am using the Same Flow to try and update the SharePoint List but for the *id field It only gives me the Size of the file for the dynamic content.
Am I going about this all wrong?
Do I need to make another flow to update the List?
Is there are way to skip the Shared SharePoint Excel file and just update the SharePoint list from the OneDrive doc on another users OneDrive?
This is the flow i have so far.
Hi @Chrisguff12,
Do you want to sync the SP list with the Excel file on OneDrive?
Could you please share a bit more about your scenario?
1). Fetch all Excel elements
2). Do a SharePoint “Get Items” or Get Item action and search for the corresponding ID for each.
3). Insert or update depending on if the item exists or not.
Share
Report
All responses (
Answers (
int(items('For_each_item_in_Excel')?['ID'])For the filter the array, we need to check if we have an item or not. We need to use the Length function that will
return the number of items found.
addDays(outputs('Reference_Date'),sub(int(item()?['Date']),2))
