web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Building a flow in Pow...
Power Automate - Building Flows
Unanswered

Building a flow in Power Automation to show inkonsistenz of 2 Lists

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

Dear my friends,

 

I moved from MS Access now to SharePoint and Power Automation and I am trying to solve a problem.

 

I am building a system to manage the qualification system in a company. One List in Sharepoint includes the Skills that the employer needs. The list includes the Username and the Skills. The other list shows all skills that have been learned with the date when the employer learned the skill.

 

Now I want to compare the 2 Lists to see in another List which Skills are missing and must be learned by the employers.

 

Do u have some ideas how i can build this flow?

 

I hope u can help me

Best Regards

Categories:
Business Process Flows
I have the same question (0)
  • v-chenzhi Profile Picture
    v-chenzhi on at
    Re: Building a flow in Power Automation to show inkonsistenz of 2 Lists

    Hi @Anonymous ,

     

    Could you please show me more about your scenario? What is your trigger and output?

    I have a test on my side, please try the following workaround.

    I create two lists in SharePoint.

    vchenzhi_0-1640077724933.png

    vchenzhi_1-1640077762151.png

    Here is the flow.

    vchenzhi_2-1640077972198.png

    vchenzhi_3-1640078040686.png

    vchenzhi_4-1640078154158.png

    vchenzhi_5-1640078281891.png

    vchenzhi_8-1640078403571.png

    When input UserName.

    vchenzhi_6-1640078315229.png

    It shows like this.

    vchenzhi_7-1640078328859.png

     

     

    Best Regards,

    Zhi Chen

     

     

     

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Building a flow in Power Automation to show inkonsistenz of 2 Lists

    Hi v-chenzhi, first of all really thank u for ur help. My scenario is that my users add in the List "Skill needed" their employers and select the skills that they need as u has shown. In the other list there is the information about the employers which skills they have already learned the skills here are added manualy through the lists or added from another list were the new learned skills are added.

     

    The trigger should be something like a button that shows the user directly all of his employers and the list of the needed skills that are missing. 

     

    I tried to build the workflow but what should I write completly in the Shema under Apply to each 2 -> Parse JSON because I cant see the whole code

     

    Best Regards

     

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 666 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 382 Moderator

#3
developerAJ Profile Picture

developerAJ 254

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans