cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
spin-man
Helper I
Helper I

Use MS Flow to create a new item in a sharepoint list using data from another sharepoint list

I'm at a loss :(. I have tried so many different ways to do this flow and can't get any of them to work.  Maybe someone where knows how to do this.

 

Use Case:

When List A's field called MSA In Process (Yes/No field) is set to Yes, I want MS Flow to create a new item in List B using the Company / Contact data in List A.  Company / Contact field in List A is populated from another list called Contacts, List A & B have this field to populate this information.

 

Any help would be much appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
Brad_Groux
Community Champion
Community Champion

You can try bool('true'), 'true' or just true. Sorry, on mobile so can't test just now.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

5 REPLIES 5
Brad_Groux
Community Champion
Community Champion

This is a rather easy Flow, when an item is created or modified in LIST 1, compare the condition of the Yes/No column, and if it is Yes, create an item in LIST 2. Example:ListUpdatedCreateOnCondition.PNG

If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Here is the Flow setup as your example.  I can't get it to get past the condition step.  The only way I've been able to get it to work at that step is using Switch instead of Condition.

Screen Shot 2019-05-22 at 1.45.37 PM.png

 

Here is the results after running a test.

Screen Shot 2019-05-22 at 1.45.02 PM.png

Brad_Groux
Community Champion
Community Champion

What is the column type of the Yes/No (MSA In ...) column? If it is Yes/No column type, use the bool(true), if it is a single line of text, then just use Yes

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

It is the Yes/No column type and I've been trying to get the bool(true) to work and it doesn't.

Brad_Groux
Community Champion
Community Champion

You can try bool('true'), 'true' or just true. Sorry, on mobile so can't test just now.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,935)