You’re offline. This is a read only version of the page.
629
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:
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.
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
@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.
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
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
