Unanswered

Parameter changes from EXCEL to SP

(1) Share

Report

Posted on by jamescosten

643

I have a flow that reads an excel document and then updates the SP columns. I have created a new column in the excel but when i try to link it to the SP column it changes it from excel to SP type?

This obviously makes the flow not work and it doesn't change it for the other excel parameters? Why is it doing this?

The whole flow is this:

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report

HI @jamescosten You need to make sure that the dynamic content that you are using should be from List rows present in Time Sheet Export Sheet not from Get Items.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
jamescosten 643 on at

Like (1)

Report

@ANB I am selecting the correct Dynamic content as shown in the image.

Should the function text be different from this?
The SP list from the get item doesn't have a column called Time sheet total, it just shows as an SP item for some reason.

Was this reply helpful? Yes No
Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (2)

Report

Hi @jamescosten , Use this items('Apply_to_each')?['Time Sheet Total'].

Basically you have nested apply to each and if you item() within child apply to each it will give the content from Gets Items.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (1)

Report

Hi @jamescosten !

How about trying it in the old designer? Does this issue still persist there?

When shifting to old designer, remove that item and again insert the same one and see if that works in the old designer.

Was this reply helpful? Yes No