cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filtering out DevOps items to add them to Dataverse

Hi guys!

 

Im guessing its pretty simple but im having trouble figuring it out, here's the problem:

 

Im getting Items from DevOps (but can be any other place) with unique ID of the items, afterwards i want to check if this unique ID exists in my Dataverse table(or SP list) and if it doesnt i want to create a new record or update existing one, how can i approach this?

 

Thanks in advance!

3 REPLIES 3
abm
Super User III
Super User III

Hi @Anonymous 

 

To check the record exists in Dataverse or SP List you need to use the Filter Query under the List Items (SharePoint) or List Rows (Dataverse).

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Anonymous
Not applicable

Hey! Thanks for your reply, after filtering array how would i add the item, assuming it doesnt exist to the SP list?

abm
Super User III
Super User III

Add a row action (Dataverse) step.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,974)