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
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!