Hi there, im a newbie on power automate, grateful if someone could help, many thanks
Background:
Received a csv file daily with 9 columns, try to compare the csv file with the master list store on sharepoint with following action
a) (When column 2 value = released and column 3 value = yes) and unique id not matched with the id on the master list
Then get those related rows and output to an excel and send email to myself for followup.
b) Then get the unique id for those rows and update them to the sharepoint master list
Progress so far
First get the csv file from sharepoint
Then use base64 to convert to string
Then use the apply to each function
First SplitbyCommas to remove the first row as it's the header
Then to split by the comma
Then i was trying to compose to json format but in vain
After that get the JSON output and try to input to sharepoint list
Output issue
despite having had apply the skip function the first row cannot be skipped
Cant seems to get the value from the data
CSV file sample

Report
All responses (
Answers (