308
Hi I have 5 sharepoint lists connect to powerapps app.
I need to calculate :
A list SiteInspector with ID of address in a form must sumif 4 itens from another list SiteInspectorUn with same ID.
Is that possible to have this in powerapps?
The sumif must apply in sharepoint lists. (different ones)
Is that possible?
Thanks for help
Hi @alessandramaced ,
Could you please share a bit more about your scenario?
Do you want to calculate value for a column in your SiteInspector List against corresponding record in your SiteInspectorUn with same ID value?
Based on the needs that you mentioned, I think the LookUp function could achieve your needs. Within the Edit form which connected to your SiteInspector List, unlock the specific data card, set the Default property of the Text Input box to following:
Share
Report
All responses (
Answers (
ThisItem.NumberColumn_SiteInspector + LookUp('SiteInspectorUn List', ID = ThisItem.ID, NumberColumn_SiteInspectorUn)Note: The NumberColumn_SiteInspector represents the Number type column in your SiteInspector List. The NumberColumn_SiteInspectorUn represents the Number type column in your SiteInspectorUn List.
Of course, if you want to sum 4 column values of a record from your SiteInspectorUn List with same ID value from your SiteInspector List record, please try the following workaround:
Within the Edit form which is connected to your SiteInspector List, unlock the specific the field data card, set the Default property of the Text Input box to following:
LookUp(
'SiteInspectorUn List',
ID = ThisItem.ID,
Sum(NumberColumn_1, NumberColumn_2, NumberColumn_3, NumberColumn_4)
)
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
