Thanks in advance for the help!
I'm fairly new to Power Automate. I am trying to make a flow where the following happens.
- A list is edited/updated
- only alert users on certain fields
- send email
The flow works when one of the "Or" conditions aren't met. But when one of them is met, it fails. I am coming behind someone else trying to figure this out. So I don't know if it's setup the correct way. Error message is attached on one of the photos.
Here is the email code: <p class="editor-paragraph">The following has been modified for @{concat('<a href="', triggerBody()?['{Link}'], '">', triggerBody()?['Title'], '</a>')}<br><br>BORROWER(S): @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/Borrower_x0028_s_x0029_'], triggerBody()?['Borrower_x0028_s_x0029_'], '')}<br><br>GUARANTOR(S): @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/Guarantor_x0028_s_x0029_'], triggerBody()?['Guarantor_x0028_s_x0029_'], '')}<br><br>PROPOSED FEE: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/PROPOSEDFEE'], triggerBody()?['PROPOSEDFEE'], '')}<br><br>PROPOSED RATE: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/PROPOSEDRATE'], triggerBody()?['PROPOSEDRATE'], '')}<br><br>LOAN AMOUNT: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/field_3'], triggerBody()?['field_3'], '')}<br><br>NEW MONEY: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/NEWMONEY'], triggerBody()?['NEWMONEY'], '')}<br><br>PROPOSED PURPOSE CODE: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/PROPOSEDPURPOSECODE'], triggerBody()?['PROPOSEDPURPOSECODE'], '')}<br><br>PROPOSED TERM: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/PROPOSEDTERM'], triggerBody()?['PROPOSEDTERM'], '')}<br><br>PROPOSED AMORTIZATION: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/AMORTIZATION'], triggerBody()?['AMORTIZATION'], '')}<br><br>APPROVAL AUTHORITY: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/field_15'], triggerBody()?['field_15'], '')}<br><br>APPROVAL RECEIVED: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/field_9'], triggerBody()?['field_9'], '')}<br><br>MEETING NOTES: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/MEETINGNOTES'], triggerBody()?['MEETINGNOTES'], '')}</p>