Unanswered

Replace Dynamic content with message when writing to SharePoint list using expressions?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

Does anyone know how I can replace content being written to a SP list based on the value of the dynamic content. Ideally something with the same logic as shown below.

IF value = 1234

Change to Test text

Else use dynamic content.

Cheers,

Adam

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

ScottShearer 25,280 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

How about this:

if(equals(triggerBody()?['ColumnA'],'1234'), 'test text', triggerBody()?['ColumnA'])

In my example, if Column A = 1234, then return "test text" otherwise use the value in ColumnA

Please post here and let me know if this solves your issue.

Scott

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you please share a bit more about your scenario?

Further, could you please share more details about your SharePoint list?

I agree with @ScottShearer's thought almost, I think the if() function could achieve your needs. I have made a test on my side and please take a try with the following workaround:

The Column B field set to following formula:

if(equals(triggerBody()?['Column_x0020_A'],'1234'),'Test',triggerBody()?['Column_x0020_A'])

Note: The Column A and Column B are both Single line of text type column in my SharePoint list. In order to include the Dynamic content within your if expression, you should firstly select the if expression, then select the Dynamic content tab and simply click the field you want to use.

The flow works successfully as below:

If the Column A is equal to 1234:

If the Column A value is not equal to 1234:

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

More details about the if() function, please check the following article:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language#logical-functions

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for your help.
When I used this code and added my dynamic content as you mentioned it wasn't giving me any errors and running was successfully.
But the name in the sharepoint list did not change at all.
Any ideas on how to fix this problem?

heres my code below:
if(equals(triggerBody()?['requester_id'],'12345678'), 'requester name here',triggerBody()?['requester_id'])

My goal is to be able to take the freshdesk requester ID and change it to the name of the requester for ease of use.

Thanks,
Adam

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for your help.
When I used the code Scott provided and added my dynamic content as mentioned it wasn't giving me any errors and running was successfully.
But the name in the sharepoint list did not change at all.
Any ideas on how to fix this problem?

heres my code below:
if(equals(triggerBody()?['requester_id'],'12345678'), 'requester name here',triggerBody()?['requester_id'])

My goal is to be able to take the freshdesk requester ID and change it to the name of the requester for ease of use.

Thanks,
Adam

Was this reply helpful? Yes No
ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you post a screenshot of your Flow? This will make it easier to assist.

What type of column is requester_ID? Person or Group? Text Column?

Also, does the run history provide any clues to why the column is not being updated?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Request ID goes into the customer field in the SP list which is a single line of text.

Was this reply helpful? Yes No
ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I am wondering if there is an issue with the requester_id column.
Can you take a look at the run history and see if you are getting anything back?

Try inserting just the requester_id into the customer column (remove the expression) and see if it works (as a test).

Was this reply helpful? Yes No