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.
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:
Please feel free reply if you need more help.
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.
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.
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
This gets round the error you get where the provided value is a float and also allows the check for null
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!