Power Platform Community Forum Thread Details

I have an excel spreadsheet with the VideoId,Name, State ,Description ,PublishedDate, LastViewDate ,Size (in Bytes) ,Views ,Likes, ContentType, PrivacyMode, Creator, Owners ,ContainerId, ContainerName, ContainerType ,ContainerEmailId ,ContainerAadId, MigratedDestination ,ContainerVideosInClassicUI ,IsEligibleForMigration

another excel spreadsheet that has all the containeremailid with no duplicates and arranged alphabetically

now what i want my power automate to do is check in second spreadsheet if the column 1 matches value of first spreadsheet and put in separate sheet or table forexample if the first column of second spreadsheet is gurleen@xxx.ca and it has 3 records in first spreadsheet then it will take that 3 records and put it in table and send an email to that person and then look for 2 column in second spreadsheet and map it to first one

How can i do that?

Categories:

General topics