How to get values from different SharePoint and input the sum Value

(0) Share

Report

Posted on by Elderscroll

I finally solved this problem by myself!
Thank you for your interest, Thank you @Hardesh15 !

If you don't mind, I'd appreciate it if you could also take a look at the problem in the link below.

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-automatically-reduce-parts-when-an-order-comes-in/m-p/1995738#M116601

Hi Community,

I really need your help.

Described :
There is a column named 'Stock' in SharePoint A and 'inQuantity' in SharePoint B.
1. Send approval request when SharePoint B is modified
2. The value of SharePoint B 'inQuantity' is added to SharePoint A Stock only when approval is complete.

I wrote an approval flow, but I don't know how to update it by adding the value of SharePoint when the approval is complete.

I would really appreciate it if you could help me.

I am attaching the flow I wrote.↓

Categories:

General topics

All responses (5)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Elderscroll Use get items action to fetch value from SharePoint List.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Elderscroll 36 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hardesh15
Thanks for your reply.
I know that items in each SharePoint can be acquired through 'Get items'.
After obtaining the 'partsQuantity' and 'inQuantity' values of SharePoint A and B with the Get item action, I tried to reflect Sum value to SharePoint A with the Update item, but an error occurred.
could you please help me?
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Elderscroll Pls share complete error messages from screen.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Elderscroll 36 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hardesh15
Are you referring to this screen?
I am thinking that after specifying 'Stock' and 'inQuantity' as each variable, I should update the item by setting the sum of the variables as a new variable.
But 'Initialize variable' doesn't work under "If yes".
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Elderscroll You can not initialize variable inside condition block. you need to initialize variable before condition block.

Yes pls paste all text related to errors.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in