Unanswered

Update Item (SharePoint Online Source) update wrong value

(0) Share

Report

Posted on by BacktoTrack

Hello Power Automate Community,

the following problem starting at 26.03.2024 until now. Before this Flow works over 5 months good (only problems with the data source outside).
Maybe someone have a idea whats happens here.

Expected behavior:

Run over all filtered data rows from a excel file (saved on SPO)
Transform the float value out of a string ( "250 EURO (€)" to 250)
Check if this data row already exists at SPO list -> Load the exists data from a SPO list
Update item to the value from step 2. (overwrite existing value)

Actual it doing this:

works as expected
works as expected
works as expected
New Value is 500, Load from existing data row is 250, Update Item fills 670.82 in

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Unknown geen idee 1,757 on at

Like (1)

Report
Copy link

Link copied!

Dear B,
Your screenshot is too big/unclear to zoom and get any details ... but in any case. My experience is that while connections can do funny things in PowerAutomate, expressions/actions/calculations always do what they are supposed to.
So, while not 100% guaranteed, there is either something in your data which causes the result or in your flow logic.
I suspect it is the first ... suggest you trace the data throughout your flow.
You do this by adding a Compose action before and after each step with the data you want to see (Mind you, this is sometimes different from the output data from an action, hence the need for the Compose).
Once you trace this data you will find where you go wrong ...

Hope this helps,
Happy flowing,
Koen

Was this reply helpful? Yes No
BacktoTrack 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks you Koen for the hint with compose.

I rebuild a little part of the long flow and in this session it's works (from the perspective of variable handling)

For me it looks like that this flow have a big problem with the initialize variables. Maybe it's a bug? I mean after "Set variable" Action the "Compose" Action show me a complete other value. (and yes I check all Initialize actions for double definitions)

The last option is to rebuild everything from stretch. But his will not bring trust into the Microsoft Flows in my company.

Was this reply helpful? Yes No