Get Items from Multiple Lists using Power Automate

  Hi,

 

Below is the infra structure that we have in our Sharepoint site i.e.

 

In the primary list we have a column called Request ID.

 

In the secondary list we have to get the vendor details w.r.t Request ID

 

In the secondary list the column name is MasterReqID

 

Now as per the requirement we need to get the vendor details from secondary list w.r.t Request ID and

 

Should send to vendor details user ID of Request ID which is primary list as below

 

Finally we made this worked as mentioned below











Comments

Post a Comment

Popular posts from this blog

Stepper in the Canvas Power App

Image
Hi,   I have a configured a stepper in the canvas power app as mentioned below First, I have created a UI through circle, inside circle I have set up a label to mention as 1,2,3 and 4.   To display the progress, I have placed a rectangle in between the circles.   So now on click of Next button in the bottom, must display the tick image to represent the tab movement   To achieve this, first I have set a global variable on the OnVisible property of the screen There after having written the switch statement to increment the value of varformsteppervalue as below   Switch(       varformsteppervalue,       1, Set(varformsteppervalue, 2),       2, Set(varformsteppervalue, 3)       3, Set(varformsteppervalue, 4) )   After that set, the below condition to display the tick image on the click of Next button.
Read more

Configure Image Loader in the Canvas Power App

Image
  Hi,   User will enter the url and will click on Validate button.   There after a loader must be displayed on the center of the screen   For this spinner image has been added just below the screen After setting up the x,y position of the spinner image.   Set the visible property of the image spinner as shown below Set the visible property of the rectangle as shown below Updated the below code snippet on button click of the Validate button Finally, spinner image is getting loaded on click of Validate button
Read more