Hi all,
our customer is tracking employee tasks via individual excel lists where the employee is adding performed tasks in the excel. The excel is located on sharepoint.
They now want to have these tasks created as a record on a custom entity. I was trying to do this via PA flow but I am not getting anywhere.
Does anybody have a solution or a flow idea / instructions for this?
1. Employee adds a row to excel on sharepoint
2. flow needs to identify new entries every day and create a record for each entry
3. If possible one flow for all 15 employees
Any help is appreciated.
Rgds
Christian K.
Hi Leah,
thank you for your input. This already helps quite a lot.
I am struggling a bit with how to filter it that it will only update the CRm with the latest items from the list and not always use the whole list. Any ideas here how to restrict this?
Rgds
Christian
Hi Christian K,
In Power Automate, you can search for SharePoint and you’ll find the trigger on which for Item created in SharePoint.
1.Set trigger:
https://docs.microsoft.com/en-us/connectors/sharepointonline/#when-an-item-is-created
2.Add anew row in dataverse:
Select one entity you need and set value from sharepoint column:
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156