Trying to update a Sharepoint list of from a file that is unknowed by Flow

[Wawan4137]

Hi,

I'm actually building an application that need to delete and add items in multiple lists from multiple excel file and I don't know how to get Value of each field of my Excel Table because Flow don't know it. Can you please help me on this if it's possible ?

Deleting items is working, it's for adding items. I only know the name of the field that is already the same for every Excel file and list but not the value of the line.

[abm]

Hi @Wawan4137 

Are you planning to create list items from an Excel sheet? Then why not use Create Item SharePoint action step instead of HTTP?

Thanks

[Wawan4137]

Hi @abm , I can't use the create sharepoint action because when i use it, it didn't know the fields of the list because i'm using a dynamic field

[abm]

Hi @Wawan4137 

Thanks for your quick reply. Ok I understood. So if you thinking you can't see the Dynamic content of your Excel sheet under the HTTP Body parameter that's because of the data type. Add a compose above the step. You should be able to see all the dynamic contents from excel sheet. Once you mapped the compose you can use the compose output in your HTTP body.

[Wawan4137]

Wow really thank you for your answer but i'm a beginner and I didn't understood all of your last message, can you maybe send me an example please ? 😅

[abm]

Hi

Just above your HTTP SharePoint action step add a compose action step. You should be able to see the Excel column values. Once you mapped the Excel column mapped value you can use the output of the compose to your HTTP. Please see below steps. Add these inside your Apply to each loop.

Thanks