cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnMacDougall
Advocate IV
Advocate IV

Filtering based on a SharePoint ID

I'm trying to filter an Excel table based on the SharePoint ID from the "When an item is created or modified" trigger.

 

When I run the flow, I see the Filter array step is always empty and doesn't filter on the row.

 

If I try the filter step based on a text column in the table, it works and returns the correct row.

 

I have done the exact same, except instead with a PowerApps trigger (PowerApp connected to the SharePoint list and passing the item ID) and that worked too.

 

How can I get it to work with the SharePoint ID?

 

2019-03-12_15-47-35.png

1 ACCEPTED SOLUTION

Accepted Solutions
JohnMacDougall
Advocate IV
Advocate IV

Seems the ID needs to be a text?

View solution in original post

1 REPLY 1
JohnMacDougall
Advocate IV
Advocate IV

Seems the ID needs to be a text?

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,820)