web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Help with expression

Power Automate

Unanswered

Help with expression

(0) Share

Report

Report

Posted on by Archiehelp

Hi All,

Can someone fix this expression for me.

contains(triggerOutputs()?['body/{Path}'], outputs('Get_a_row')?['body/MBM 1'], replace('NYS, 'NYS', 'S'))

What I am trying to achieve.

Updating Row in Excel doc by matching part of the folder path with column title, replacing the current text within the cell from NYS to S when a document is submitted as trigger. If the folder path does not match with the column title I would like the cell to remain NYS.

Any help with this would be much appreciated.

Thanks

Archie

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Archiehelp you expression should be as follows, replace 'celltoreplace' with the actual cell name which needs to be replaced
if(contains(triggerOutputs()?['body/ID'],outputs('Get_a_row')?['body/MBM 1']),replace(outputs('Get_a_row')?['body/celltoreplace'],''),outputs('Get_a_row')?['body/celltoreplace'])

Join the conversation