Process Template Language Error with Person Department

(0) Share

Report

Posted on by RiccoHipp1903

284

Hello guys,

I have a problem. I need to check the department of a Person in the Person Field from Sharepoint.

Reason is, that there are multiple CEOs based on Departments.

The following Error is Coming Up

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'startsWith' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#startswith for usage details.'.

I just write the Department-Names in the fields, no function is used

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

rajasubr 75 on at

Like (0)

Report

Hello,

This is because of the reason how to mentioned the department names. Like Dep1,Dep3 and etc.

as per the MS article starts with function will expect the text which needs to be found inside a ‘’. Like the below:

startsWith('<text>', '<searchText>')

so, please change and try.

Happy to help you if still the issue persists.

Was this reply helpful? Yes No
RiccoHipp1903 284 on at

Like (1)

Report

@rajasubr I will try it out. But i have to wait to test it. I will come back to you.

Was this reply helpful? Yes No
rajasubr 75 on at

Like (0)

Report

Thanks. I will wait for your further response.

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

Like (0)

Report

@RiccoHipp1903

You say that you are "check the department of a Person in the Person Field from Sharepoint"

Then you say "I just write the Department-Names in the fields, no function is used".

What type of column are you referencing in your condition? A person or group column or a text column?

Also, if the person or group column allows for multiple entries, you should be in a loop.

Was this reply helpful? Yes No
RiccoHipp1903 284 on at

Like (0)

Report
Hello Scott,

I'm sorry for beeing unclear.

The Value I use is from a single Person Column 8No puliple selection or no group selection) the Department from that Column. So in my picture that would be the Column 'Mitarbeiter' and used 'Mitarbeiter Department' in the Power Automate.
"I just write the Department-Names in the fields, no function is used" i just write eg. IT, what means it looks like this (not the actual code, just a textform of the picture Condition):
@{triggerOutputs()?['body/Mitarbeiter/Department']} startswith IT

Was this reply helpful? Yes No
rajasubr 75 on at

Like (1)

Report

Hi,

I replicated the scenario and it is working fine. Below is a sample picture of my workflow.

Floe before run:

Flow after run

So, I request you to delete the action and retry or just give it a try by simply creating a sample flow.

My SharePoint Sample List:

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

RiccoHipp1903 284 on at

Like (1)

Report

that also didn't work for me .
I found an alternative. I used the Office365Users Connector before and use the Department Value of this Connector instead of the SharePoint Department Value. That works really well

Was this reply helpful? Yes No
rajasubr 75 on at

Like (0)

Report

Thanks.

Was this reply helpful? Yes No