Dears,
I have 2 SharePoint lists.
First One: 'ProductsTime' : each product have a time(number column). eg 1 hour for Powerapps product 1 hour for Power automate...
Second List: 'Request' I Lookup the Product column(accept multiple choice value) from 1st list to second with time column.
I Create an app: that submit the form of the 2de list in order to add new record.
As shown above the product column is in a datacardvalue dropdown that accept multiple choice.
My target is to count or calculate the time according to selected product in dropdown.
if user choose power apps & power automate so the time is 2h
If user choose just power apps so the time is equal to 1h.
How can i achieve this through flow or from power apps and how ?
Any idea
Thanks.