cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Edit Item

FlowBsp1.jpgFlowBsp2.jpg

Hello guys,

 

im trying to edit the request number(Anforderungsnummer)  manually after my last action ( sending e-mail 2). The previous actions will update the requeststatus for every uploaded and accepted request and send an email to the next person. This person has to add/edit the request number after the previous actions but i dont know how to do it. I want the person to edit the requestnumber and MicrosoftFlow to update the requestnumber in the list and send an email with the updated number to another person. Does anybody know how to do it ? I have tried several methods but they only work for 1 request. As soon as i upload several requests at a different time, the flow only runs for 1 request or sends emails with the requestnumber 0.  It would be better if the Flow-Team could add a modify action for items and not only a trigger.

 

Best Regards,
Hamudi

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Edit Item

Hi Hamudi,

 

It seems that Flow doesn’t have a modify action for items, currently it only has a trigger “SharePoint – When an existing item is modified”. Please consider to submit an idea at Flow Ideas Forum, so it might be considered in the future releases.

As a workaround, please consider to create another flow which is triggered by “SharePoint – When an existing item is modified”, then add a condition to check if the RequestNumber has a value. If YES, send an email to another person.


About how to configure the Condition, I assume this thread could be a reference for you:
https://powerusers.microsoft.com/t5/Microsoft-Flow-Knowledge-Base/How-to-check-if-a-field-is-blank/t...

 

Please feel free reply if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Edit Item

Hello @v-yamao-msft Mabel Mao,

 

first of all thanks for the reply but the method you have suggested me give me this error InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2042': 'The template language function 'empty' expects its parameter to be an object, an array or a string. The provided value is of type 'Float'. Please see https://aka.ms/logicexpressions#empty for usage details.'. 

 

I have replaced @empty(triggerBody()?['euru']) euru with my Anforderungsnummer(Request Number) if i understood it right. I have submitted the idea for the modfiy action at Flow Ideas Forum.

 

Best regards,

Hamudi

Highlighted
Community Support
Community Support

Re: Edit Item

Hi Hamudi,

 

Thanks for updating. The method I suggested wroked before, but when I test it again on my side, I found that it also desn't work for me.

 

It seems that the empty function requires an array or a string. I will try to update the thread after a confirmation on my side.

 

Best regards, 

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Edit Item

What you could do is in the condition to check if the value is null 
is cast the value to a string 
and then check if that value is null

eg: @empty(string(triggerBody()?['euru'])) 

This gets round the error you get where the provided value is a float and also allows the check for null

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,756)