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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Best practice to look ...
Power Automate
Unanswered

Best practice to look at one SharePoint list, match the contents of an item to another list, and pull information from it, you can follow these

(0) ShareShare
ReportReport
Posted on by 107

I am working on a flow that starts from a form, and then the contents for the form are placed into a SharePoint list. If the name of a product on this form matches the name of a product on my pricing list, pull all associated information. Right now I am using replace, but I think there has to be a more streamlined way to do this that would allow me to make changes in the SharePoint list, and the flow to continue to work properly. I am not very versed in JSON. Once my flow has the information from the pricing list, i have an action item to populate a word template and save. Any help would be appreciated. Also, I have used the replace to try to remove the [,], and " from my outputs but they are still in the first SharePoint list after the test run. 

ChrissyRamirez_0-1707146928149.png

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @ChrissyRamirez The Apply to Each action isn't necessary when getting the response details. If you started building your flow in the New Designer—Power Automate will automatically nest the Get response details inside an Apply to Each action. 

    creativeopinion_0-1707147561909.png

    I would recommend using the Classic Designer for your flow especially since you are using the MS Form trigger and action. The New Designer still has bugs.

    creativeopinion_1-1707147626385.png

     

    I would recommend checking out this Tutorial I recently uploaded: How to Get a Microsoft Form RSVP Response into a SharePoint List

     

    I cover the following in this video tutorial:

    How to get a Microsoft Form Response into SharePoint

    How to get a Microsoft Form ID

    How to get a Microsoft Form response

    How to Build a Microsoft Form with Conditional Fields

    How to used Branching in Microsoft Forms

    How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

    How to parse a Microsoft Form multiple choice response as string of text

    How to convert a text response to a number

    How to use the Switch action

    How to create a custom email confirmation for a Microsoft Form submission

    How to Create a Custom View in a SharePoint list

    How to use the Compose Action

    How to write Power Automate Expressions

     

    In regards to getting information from another list. You definitely don't want to nest a Get Items action inside an Apply to Each action. After you Create an Item in the SP list, are you wanting to get additional information from another SP list to insert into the list you've created your item in?

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok
     
  • ChrissyRamirez Profile Picture
    107 on at

    I need to get additional information from the 2nd list to populate the word template. For instance, if a camera is marked in the first list, I want to refer to the second list for the price and description, then populate the word template. 

  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @ChrissyRamirez Build your flow so that the Get response details is not nested inside an Apply to Each action. I would also recommend using a Manual Trigger for your flow to help speed up the flow building process so you can quickly trigger tests while building your flow. You can refer to my YT Tutorial on how to do this.

     

    Post a screenshot once your flow is set up with the Manual Trigger (up until you've Created the Item). Run a test to ensure your item is created as expected.

  • ChrissyRamirez Profile Picture
    107 on at

    @creativeopinion 

     

    I have been working on rebuilding my flow, however, I am having an issue dealing with a mutlichoice form field without the apply to all options. I am using this expression: 

     

    replace(
        replace(
            replace(
                replace(
                    replace(
                        replace(
                            replace(
                                body('Get_response_details')?['re80bca71c1d54116b1fc2de3bcce553f'],
                                '[', ' '
                            ),
                            ']', ' '
                        ),
                        'Carrying Case', '401'
                    ),
                    'Signature Pad', '402'
                ),
                'QR Scanner', '403'
            ),
            'ID Reader', '404'
        ),
        'Camera-DSLR', '405'
    )
     
    Can you make a suggestion? This expression looks at one field, if the field has data, it stops looking, if it is empty it moves on to the next. Then is replaces the name of the product with my product code. 
  • ChrissyRamirez Profile Picture
    107 on at
    Correction :

    if(
        or(
            not(empty(outputs('Get_response_details')?['body/rd727ac0ba49e4e7b8e2a9242b73bd205'])) ,
            not(empty(outputs('Get_response_details')?['body/r447d318cdc884adeaf2db3ece1a7b850']))
        ),
        [],
        [
            replace(
                replace(
                    replace(
                        replace(
                            replace(
                                replace(
                                    replace(
                                        outputs('Get_response_details')?['body/rd727ac0ba49e4e7b8e2a9242b73bd205'],
                                        '[', ' '
                                    ),
                                    ']', ' '
                                ),
                                'Carrying Case', '401'
                            ),
                            'Signature Pad', '402'
                        ),
                        'QR Scanner', '403'
                    ),
                    'ID Reader', '404'
                ),
                'Camera-DSLR', '405'
            ),
            replace(
                replace(
                    replace(
                        replace(
                            replace(
                                replace(
                                    replace(
                                        outputs('Get_response_details')?['body/r447d318cdc884adeaf2db3ece1a7b850'],
                                        '[', ' '
                                    ),
                                    ']', ' '
                                ),
                                'Carrying Case', '401'
                            ),
                            'Signature Pad', '402'
                        ),
                        'QR Scanner', '403'
                    ),
                    'ID Reader', '404'
                ),
                'Camera-DSLR', '405'
            )
        ]
    )
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @ChrissyRamirez It would be helpful to see how you've set up your form. I can't provide any recommendations without getting the full picture. The more information you can provide ... the easier it is for me to understand what you are trying to do. Thanks!

  • ChrissyRamirez Profile Picture
    107 on at
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @ChrissyRamirez I need a better idea of how the form fields are mapped to your SharePoint list. There are a lot of fields in your form. 

  • ChrissyRamirez Profile Picture
    107 on at

    ChrissyRamirez_0-1707401706846.png

    ChrissyRamirez_1-1707401744356.pngChrissyRamirez_2-1707401772820.png

    All of the fields that show an expression have this formate: 

    if(
        and(
            not(empty(outputs('Get_response_details')?['body/r22fe474cf62c4ee7824bd636f4a8c3d6'])),
            not(equals(outputs('Get_response_details')?['body/r22fe474cf62c4ee7824bd636f4a8c3d6'], null))
        ),
        float(replace(replace(trim(outputs('Get_response_details')?['body/r22fe474cf62c4ee7824bd636f4a8c3d6']), '"', ''), ',', '')),
        0
    )
    ChrissyRamirez_3-1707401848426.png

    I am using these variables to pull in the information in the products purchased for options, installation/training, and the base system. Then it returns the product number. This was to help me use the Product number to pull data from my master pricing list. 

     

    This is the expression for my base system. It only has one response 

    if(
        not(empty(outputs('Get_response_details')?['body/rd46b0c0ceba040c4b210c4401fe90c17'])),
        replace(
            replace(
                replace(
                    replace(
                        outputs('Get_response_details')?['body/rd46b0c0ceba040c4b210c4401fe90c17'],
                        'Ten-Print Desktop', '003'
                    ),
                    'Palm-Print Desktop', '005'
                ),
                'Ten-Print Kiosk', '008'
            ),
            'Palm-Print Kiosk', '002'
        ),
        ''
    )
    This is the one that I use for Options. THe system options will be in one of three fields, and it can contain 0 - 7 responses. 
    replace(
        replace(
            replace(
                replace(
                    replace(
                        replace(
                            replace(
                                replace(
                                    outputs('Get_response_details')?['body/rd727ac0ba49e4e7b8e2a9242b73bd205'],
                                    '[', ' '
                                ),
                                ']', ' '
                            ),
                            'Carrying Case', '401'
                        ),
                        'Signature Pad', '402'
                    ),
                    'QR Scanner', '403'
                ),
                'ID Reader', '404'
            ),
            'Camera-DSLR', '405'
        ),
        ',', ''
    )
     
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @ChrissyRamirez I would recommend removing the Create Item action all together first while you troubleshoot your expressions. Instead of inserting the expressions directly into the Create Item action. Put them into a Compose action (remember to rename your actions to keep things organized). Start with one first so you can view the output of your expression.

     

    You can copy your existing flow and work on a copy.

     

    For example, start with the Total Purchase Price. Insert your expression and run a test. 

    creativeopinion_0-1707403316005.png

     

    For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

    In this tutorial I cover:

     How to troubleshoot a false Condition action result

     How to get dynamic content when it isn’t selectable from the list of dynamic content

     How to troubleshoot an Apply to Each action that isn’t looping through

     How to troubleshoot a skipped Apply to Each action

     How to troubleshoot a Filter Query

     How to use a SharePoint yes/no column in a Filter Query

     How to use Compose actions to troubleshoot a Power Automate flow

    How to troubleshoot multiple emails being sent

     How to troubleshoot multiple Teams messages being sent

     

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard