Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Item ID issues

(0) ShareShare
ReportReport
Posted on by 193

hello, I have created a flow that kicks off when a new item is created on a sharepoint calendar. It creates the same item on a second calendar on the same site. 

 

 

 

 

flow1.PNG

 

 I have a second flow that I created for updates. When existing item is modified, update Item in sharepoint

flow2.PNG

 

 

due to the first flow not setting the ID of new item in the second calendar, the second flow fails because it cannot find the proper ID. Is there any way to set the ID in the new item on the first flow??

 

 

Categories:
  • Roberts2727 Profile Picture
    Roberts2727 193 on at
    Re: Item ID issues

    So, 

    after adding some more items to my list and testing, it seems the sharepoint odata filter query is not working at this time. Even with the filter query in place to filter only items with a certain title all items are returned. Sigh. I ran the flow and it changed the title of 178 entries on the calendar... 

     

    @Stephen any Idea when SharePoint odata filter query will be supported? According to this post its still in development. 

     

    https://powerusers.microsoft.com/t5/Flow-Ideas/SharePoint-Get-Items-Filter/idc-p/12016#M448 

  • abm abm Profile Picture
    abm abm 32,288 on at
    Re: Item ID issues

    Excellent.

  • Roberts2727 Profile Picture
    Roberts2727 193 on at
    Re: Item ID issues

    Thanks,

    Get item step inbetween the update worked perfect

  • Verified answer
    abm abm Profile Picture
    abm abm 32,288 on at
    Re: Item ID issues

    Try to use the SharePoint Get Items ODATA Query template. Set the filter to set the unique values of your first updates.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics