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 / Give Numerical Value t...
Power Automate
Unanswered

Give Numerical Value to Microsoft Forms response

(0) ShareShare
ReportReport
Posted on by 2

Hello,

 

This is really specific and confusing but hopefully someone will have at least an idea of an approach that might help. [You can skip this but I'm explaining the project] I intern at a non-profit and I'm working on making the donation receipts digital, right now this is ready and the PDF  receipt is created and sent to the donor and saved in our database, however the process after is to give a dollar value for the donation to be inputted and registered to the donor name.

 

Each item is registered in a different question (Example attached) and I'm trying to match it to an excel file that has every item and in a different column it has the dollar value for it, I want it to give all the item a dollar value and calculate the total. (After calculating that total it will be added to an a excel sheet but that's a different task).

 

I would be really thankful for any suggestions or ideas, it will be better if the solution does not require Power Automate Premium because I'm a non-paid intern and IT team refusing getting the subscription. 

 

Thansk!

Example 1 - Donation Input.PNGExample 2 - Item Value.PNG

Categories:
I have the same question (0)
  • AhmedDandeni Profile Picture
    2 on at

    I forgot to mention, the pricing list have over 2500 item not just the 4

  • takolota1 Profile Picture
    4,974 Moderator on at

    It would be much better if your form & your Excel had some unique identifier for the items.

    That way you could use that to filter the Excel table.

     

    If you can’t set that up, then you can still pull in all the Excel values in the List rows present in table action.

    Then in a loop for each item in the donation, you could use a Filter array action on the Excel List rows output to filter to any rows where the Excel item column values contain certain words in the Item description from the form response. So you’ll probably split the Item description content on spaces, then take the 1st 2 words or the 1st & last word for the right-side of the Filter array conditional against the Excel Item column in the left side of the conditional.

    Then you can check if it returned a single row (probably your result) or multiple rows (you’ll need to set it to notify someone to review the entry).

    Once you have a single result, you can then use certain expression notation like

    first(body(Filter_array))?[‘InsertPriceColumnName’] 

    to get the price value for that row it filtered to.

     

    Once each form response item has a price associated to it, you should be able to figure out how to add them in a loop pretty easily, maybe with an increment variable action with the increment amount set to the mul(quantity, price) of each response item or something.

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 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard