Hi all!
I set up an automated flow where someone enters a Forms list, which is sent to Sharepoint. From Sharepoint the data needs to be exported in a certain, already existing, Excel sheet, where multiple Xlookups need to occur. The calculation fields are already existing, so I really need to be able to export the Sharepoint data in field E1 for example. Afterwards I want to put the calculated fields in an e-mail to the customer.
After making the calculations the data needs to be cleared again for the next calculation/offer.
I left out the Sharepoint step in my picture but this is what I already have:
What would you do? Make the vlookups in Sharepoint with if/and or export to Excel or maybe even use PowerApps?
Appreciate your feedback!

Report
All responses (
Answers (