Dear Community, I have the following issue.
I need to show a price value from Excel file to SharePoint list, so if I create a new item and based on some columns then bring "price".
Based on the following info:
Excel List:
| Supplier Name | Country | Role | Role level | type | Final Price |
| Supplier 1 | Germany | Secretary | Secretary Level 1 | Hour | 100 |
| Supplier 2 | Spain | Intern | Intern level 2 | Hour | 25 |
SharePoint List:
| Supplier Name | Country | Role | Role level | type | Final Price |
| Supplier 1 | Germany | Secretary | Secretary Level 1 | Hour | bring price from Excel |
| Supplier 2 | Spain | Intern | Intern level 2 | Hour | bring price from Excel |
So based on:
- Supplier Name
- Country
- Role
- Role level
Look up the price in Excel file and display it in SharePoint list
