
Announcements
Hi all,
I am new and struggling with an Automate that I am trying to setup that takes the PM value from the Dataverse table an updates the column in my Sharepoint library with that Value.
The Dataverse table contains columns called Project Number & PM Name
The Sharepoint library is made up of folders where the Project Number exists in the Folder Name (Screenshot Attached)
At the start of each day I would like for each project number in the Dataverse table, look for where that exists in the Folder Name of the SharePoint library and update the PMName field.
So far I have
Step 1 - List rows from Dataverse Table
Step 2 - Create Apply to Each
Step 3 - (this is where i'm stuck)
Thanks,