flow not updating field in list in another field in another list

[Anonymous]

Hi,

I am trying to create an overtime powerapp using 2 sharepoint lists and a approval workflow.

One list contains my name and total time of overtime. 

The other list contains my name, the starting hours and ending hours and the calculated time of that day I did overtime.

The basics are that I open a powerapp, my name is filled in, I enter the start and end date and start and end hour. 

IT then calculates the overtime and I can add a reason and click on Submit.

When this is done the approval flow starts and a mail is sent to my boss. If he then approves it, the calculated overtime should be added to my total time I have.

In the workflow however it does not seem to be able to find my id (or name) between the lists so it can add the time to the correct user. (in this example I just coded it, it would add 1, so not the real time it should add)

[yashag2255]

Hi @Anonymous 

Please try using Outcome: 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Hi, @yashag2255 

I had tried outcome, but then it did not work either.

I created a totally new flow and now that works again;

but then in the Update item it says : BadRequest.

Body:
{
"LstUsers_TotUren": "add(items('Apply_to_each')?['Lst_Users_TotUren'], triggerBody()?['Lst_OverUren_Totaal'])"
}

{
"status": 400,
"message": "Input string was not in a correct format.\r\nclientRequestId: 41ee8e1e-5961-4350-b700-b619a12e537a\r\nserviceRequestId: 41ee8e1e-5961-4350-b700-b619a12e537a"
}

[yashag2255]

Hi @Anonymous 

Looks like there is a small creepy error that we are missing. Can you please share screenshots of the entire flow once?

[Anonymous]

@yashag2255 

PS: I also did the first condition on OR, as AND also does not seem to work. AAAAAAArrrrgh

[yashag2255]

Hi @Anonymous 

Can you get rid of the compose action and directly put the formula in the expression editor for that particular column?

Also, What is the datatype of the Approved column of your SP list? Note that if it is type choice you need to put Approved value in the condition instead of just approved. 

I am assuming that you are using the filter query in the Get Items action. 

[Anonymous]

@yashag2255 

But if I do 

add(item()?['LstUsers_TotUren'], 20)

it works fine

do want me to put the add(items.... value in the field where I put "output" in the update item part?

The datatype of Approved is a boolean , so it is True or False

I have re-added the filter in the get items, it was not added again after recreating the flow

[yashag2255]

@Anonymous 

That is strange. Yes! In place of output, you need to place the cursor and in the expression editor, put the add expression. 

Can you try doing this--> In the add expression, after the first operand (basically after the comma), come to the dynamic selector and then scroll to find the other field to add to from the trigger list. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

@yashag2255 

the counting is working now.

First thing was that the f**king field was still a string and not a number.

I used the code: 

add(item()?['LstUsers_TotUren'], triggerBody()?['Lst_OverUren_TotaalTijd'])

AND if you change this, you need to close all, create a new record before it will work in the flow....

Next is the AND condition which is not working allthoug h I pasted the fields in the mail and it says :

approved: False , response: Approve

so what I do in the condtion is also good????

[Anonymous]

@yashag2255 

Are you maybe also good with Powerapps? 🙂 -> https://powerusers.microsoft.com/t5/Creating-Apps/how-to-update-a-lookup-field/td-p/328028