Hi @R3dKap,
Do you want to retrieve data from a CSV file stored in your SharePoint library using Microsoft Flow?
If you want to retrieve data from a CSV file stored in your SharePoint library using Microsoft Flow, I afraid that there is no way to achieve yourt needs in Microsoft Flow currently. There is no way to analyze a CSV file within Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
But you could consider take a try to convert the CSV file into a Excel file manually and then retrieve data from the Excel file within your flow. I have made a test on my side and please take a try with the following workaround:
I have created a CSV file in my SharePoint library and the data structure of it as below:
I also created a SharePoint list on my side, the data structure of it as below:
If you have converted your CSV file into a Excel file manually, please take a try with the following workaround:
- Add a proper trigger, here I use Flow button trigger.
- Add a "Get rows" action, File name field set to Id dynamic content of the "Create file" action, Table name field set to Table1 as a custom value.
- Add a "Apply to each" action, input parameter set to output of "Get rows" action.
- Within "Apply to each" action, add a "Get items" action, specify Site Address and List Name. The Filter Query field set to following formula:
Last_x0020_name eq 'item(...)' and First_x0020_name eq 'item(...)'
The first item(...) expression read as below:
item()?['Last name']
The second item(...) expression read as below:
item()?['First name']
Note: The above item(...) is wrapped with a single quotes.
Add a Condition, click "Edit in advance mode", type the following formula:
@empty(body('Get_items')?['value'])
Within "If/yes" branch of Condition, add a "Create item" action, specify Site Address and List Name. Last name field set to following formula:
item()?['Last name']
First name field set to following formula:
item()?['First name']
Email field set to following formula:
item()?['Email']
Within "If/no" branch of Condition, add a "Apply to each 2" action, input parameter set to output of "Get items" action. Within "Apply to each 2" action, add a "Update item" action, specify Site Address and List Name, Id field set to ID dynamic content of "Get items" action, Email field set to following formula:
items('Apply_to_each')?['Email']
Image reference:
The flow works successfully as below:
Best regards,
Kris
