cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
efialtes Kudo Kingpin
Kudo Kingpin

Changes on Sharepoint Online trigger output implementation?

Last week I had a flow up and running, trigger block was "Sharepoint Online: When a new item was created".

Sharepoint list structure included a Lookup column, also a Choice column.

Since Filter Queries on that trigger seemed not to work at all, I added a Condition block, evaluating the value of the Choice column:

@or(equals(triggerBody()['EntregaMuestra'], 'Mano'), equals(triggerBody()['EntregaMuestra'], 'Mensajero'))

 

I have tested it today and the condition fails. After checking the visual logs, it looks the way Microsoft Flow handles Choice data type columns on sharepoint lists have changed.

 

Sharepoint_list_choice.png

 

Also notices that last week one of the trigger's outputs was the item ID of the value selected for the Lookup column. This ID allowed me to invoke "Sharepoint Online: get Item"  and get associated values on the second Sharepoint List; but now, this ID output is no longer available.

Sharepoint_list_lookup_ID.png

1.- I can adapt easily my flow to the first change described above, however I do not see how I can adapt my flow to the second change described. Any suggestions?

2.-Do you publish "Release Notes" whenever you apply such kind of changes on Microsoft Flow implementation? If answer is yes, where can I find them?

 

 

5 REPLIES 5
Power Apps
Power Apps

Re: Changes on Sharepoint Online trigger output implementation?

Thank you for reporting this! @merwan, any idea if Sharepoint changed the way their schemas work recently?

 

I'm also failing to see a workaround for the second issue. It looks like their perhaps there was some type checking locked down in the description in the Sharepoint api. 

 

We publish release notes for Flow itself every week or two, but there is not really any good point of reference for changes to the individual services that integrate with Flow. 

efialtes Kudo Kingpin
Kudo Kingpin

Re: Changes on Sharepoint Online trigger output implementation?

@Samuel

Thanks for taking the time to answer. 

Getting as an Output the ID of Lookup Columns was a really useful functionality, since it helped to override some Sharepoint limitations.

 

Let's assume you have a Sharepoint List (ListA) with choice /lookup type columns. Then you implement a new Sharepoint List (ListB) with Lookup Column referring to ListB. On ListB you can "lookup" List-A text-type columns, but you cannot lookup ListA choice/lookup type columns.

Whit Microsoft flow trigger implementation available last week, this limitation was solved. You could get all the column values of a new added item to ListB, and since this list had a lookup column referring to List A; you got also the ID of the referred item on ListA.

With Microsoft flow trigger implementation available yesterday, this cannot be done anymore.

 

You guys are building a really interesting product; I hope you finally keep this second feature as it was working last week!

Jacques
Regular Visitor

Re: Changes on Sharepoint Online trigger output implementation?

Did you ever get this resolved? 

 

I'm trying to do a simple flow such that when an item is created in List A, which has a lookup column from List B, the related item in List B needs to be updated. However in the Flow I can't get the ID/value for the lookup column from List A. 

 

My trigger is 'New item Created'

My next step is 'Get Item' using the ID from the new item created in the first step

From here I don't know how to actually retrieve the ID/Value from the lookup column that should have come from Step 2

 

My final step would have been to update List B which I assumed would be the Flow SharePoint Update Item action but it requires the ID of the item to update but the dynamic content fields don't show any other fields apart from ID from the Get Item action. 

efialtes Kudo Kingpin
Kudo Kingpin

Re: Changes on Sharepoint Online trigger output implementation?

@Jacques I'm afraid I didn't get any feedback on this topic, I used to try it everynow and then with no result.

This is one of the handicaps of this marvellous tool, if you work with "official" templates everything goes fine, but as soon as you start exploring more complex combinations, tiny limitations arise, and time spent finding workarounds increases exponentially.

Jacques
Regular Visitor

Re: Changes on Sharepoint Online trigger output implementation?

@efialtes Thanks. I have to agree with your assertion regarding time spent finding workarounds.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,313)