Reimport for 1 column from Excel to SharePoint does not word

[Delany]

Hello 🙂

I have a little problem with one of my workflows. Most of it works perfectly, but one column is making some troubles for me. Because I am not very good with the technical backround of power automate, I cannot find the cause of the problem.

I made a flow, which should import new or changed items from excel to sharepoint. I also should delete items, which are in sharepoint, but noch in excel.

So far so good. The creation and deletion works as it should. But one of my colums does not get the value form excel. I think the name of the column is probably the problem, but I cannot change the name, so I hope there is a way to make it work.

I used this tutorial for my flow: Power Automate - Flow to Add Update Delete items from Excel to SharePoint - Part 03- Full Build - Yo...

The marked field is the problem:

I am trying to import the values from this Excel to SharePoint. The marked column ist the one, which should be importet to the SharePoint column "Wochenarbeitszeit":

I made 2 unique varibales - one for my Excel information and one for my SharePoint information. I did this, so my flow could compare the values exactly.

This is what I used for my Excel variable (all in an "apply to each" with the Excel value):

Then I used "Get item" from SharePoint and made my second unique variable for my SharePoint content:

After that, I made again the "append to array variable" like in the last step.

Then I used an intersection:

After that I have my deletion part. That part works without problem.

And in the and, I have my creation part. Here ist the problem:

I used this formular to enter the values: item()?['Wie viele Wochenstunden?']

After running the flow, that column is missing 😞

Maybe one of you know, how I could solve this.

I can also more screenshots, if needed.

Thanks.

BR Nadja

[v-zhoqian-msft · Accepted solution]

Hi @Delany ,

Since you use "MyExcelKey" in Apply to each, you could try entering values using the following formula:

item()?['Wochenarbeitszeit']

Best Regards,

Community Support Team _ habsburg Qian

If this post helps, then please consider Accept it as the solution to help the other members find it.

[Delany]

Hi @v-zhoqian-msft ,

it worked. Thank you so much. And with your solution, I also understand some more about how to build these flows 🙂