I am trying to build a flow for copying some values from a SharePoint Excel Spreadsheet to a SharePoint List.
When Excel is modified -> create new item in SharePoint List.
The problem is that I am not able to insert a value from Excel in SharePoint List as one of my list's column is a Lookup Column.
Any ideas how should I proceed?
Thank you for your reply, @ChristianAbata.
My mistake, the trigger is "When a file is created or modified". Here is my Flow:
Last two columns are Lookup columns.
Any idea how should I insert the corresponding ChildKpi and Team from Excel File ?
oh @jeneaMD I understhand please when you clic on the dropdown field you are going to see you chooice options and in the end another that says Enter custom value, when you clic on that you are going to be able to see your dynamic content.
I don't have normal dynamic content, @ChristianAbata:
I need to put the corresponding values from Excel and I don't have this options in dynamic content.
mmm @jeneaMD extrange jejejej is difficult to understand because in your first screanshot I did't see get Items sharepoint but in your last screanshot I see Get items properties in the list of dynamic content O.o
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.