Answered

How to retrieve value from SharePoint and compare

(0) Share

Report

Posted on by new_to_power

I'm a newcomer to Power Automate and could use some guidance, so your suggestions would be greatly appreciated. Within a SharePoint list, I've set up a dropdown menu for a column named Department. In my workflow, I'm looking to verify whether the department's value is Arts and, if so, add the user to the Arts security group. Similarly, if the department is "English," I want to add the user to the English security group. I've created a variable named checkingdepartment of type boolean with no default value. However, I'm currently struggling to figure out how to compare or check the value of the column from SharePoint. Any help or advice on this matter would be highly valued.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

new_to_power 6 on at

Like (0)

Report
Copy link

Link copied!

Just to clarify Department column in SharePoint is of type "Choice", if it helps

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can use a Condition or a Switch. I think you should use a Switch since it is easier to see the different actions taken based on the value.

I don't know what the action source you are using like (Get Items, When an Item is Created, etc...) but if you have a choice column, you want the dynamic content for that column that ends with "Value" since that will be the single text output.

Below is an example sharepoint list that has a Choice column for InvoiceStatus.

I have a Switch control that uses the Value of the InvoiceStatus column. In the first Case if the value is equal to Pending then it will start an approval. If the value is equal to Denied it will send an email. If it is neither one of those values it goes to the default case which I left blank.

Switch Control

Here you can see there are multiple dynamic content options for InvoiceStatus, but I'm using the one for Value.

Choice Column Value

Let me know if that works for you,

Was this reply helpful? Yes No
new_to_power 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for providing guidance. This helped me to get it working.

Can I also clarify another question is there a way to set usage location through power automate workflow for a user creation as part of workflow. I cannot figure this out.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

I don't understand the question?

"is there a way to set usage location through power automate workflow for a user creation as part of workflow"

That might be something I am unfamiliar with. You should probably post a new topic with more details about what you need.

Was this reply helpful? Yes No
new_to_power 6 on at

Like (0)

Report
Copy link

Link copied!

I was referring to highlighted parameter to be populated for a new user created in Azure AD,

Was this reply helpful? Yes No