Notifications
Announcements
I am creating a flow which is getting all items from share point site list according to different views and creating record into D365 finance and operations. I am getting the below error.
help me to create a proper flow which can skip the null values and create record in D365 which are not null in sharepoint.
@Alkindi1222 you can filter out the null values with a filter query of [column] ne null:
RobLos GallardosIf I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
@RobElliott Many thanks for your instant reply, i get some other error while running flow: Did not work.
added legal status ne null
@Alkindi1222 that's because you've got a space in your column name (I never use spaces). Try it with the column's internal name which is probably legalstatus.
Hi @Alkindi1222 ,
Please run Get items action without configuring Filter Query and get the internal name of the specified field from the body of the action.
Then configure this field in Filter Query as suggested by @RobElliott and try again.
Best Regards,
Many Thanks @RobElliott & @v-bacao-msft ,
The filter query worked for me after getting the correct column name from the sharepoint url --> list setting and column name.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 522 Super User 2025 Season 2
Tomac 364 Moderator
abm abm 243 Most Valuable Professional
