Unanswered

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

(0) Share

Report

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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-chenzhi on at

Like (0)

Report

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.

Here is the flow.

When input UserName.

It shows like this.

Best Regards,

Zhi Chen

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No